DFS_FE_ADDR_D - I_FRCELMNTORGTP I_FRCELMNTORGADDRESSTP

I_FRCELMNTORGTP I_FRCELMNTORGADDRESSTP information is stored in SAP table DFS_FE_ADDR_D.
It is part of development package IS_S4DFS_FE_VDM_TP in software component IS-DFS-OF-FE. This development package consists of objects that can be grouped under "TP Object Views and BOPF Artifacts for Force Element".

Fields for table DFS_FE_ADDR_D

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
DRAFTUUIDUUID serving as key (parent key, root key)X/BOBF/UUIDRAW16
PARENTDRAFTUUIDUUID serving as key (parent key, root key)/BOBF/UUIDRAW16
FORCEELEMENTORGIDObject IDHROBJIDNUMC16
FRCELMNTORGTYPEObject TypeOTYPECHAR4
FRCELMNTORGSUBTYPESubtypeSUBTYPCHAR8
FRCELMNTORGPLNGSTATUSPlanning StatusISTAT_DCHAR2
FRCELMNTORGVALDTYSTARTDATEStart DateBEGDATUMDATS16
FRCELMNTORGVALDTYENDDATEEnd DateENDDATUMDATS16
NUMBEROFFORCEELEMENTORGNumber of Infotype Record With Same KeySEQNRNUMC6
FRCELMNTORGPLANVERSIONPlan VersionPLVARCHAR4
FRCELMNTORGINFOTYPEInfotypeINFOTYPCHAR8
ADDRESSNUMBERAddress NumberAD_ADDRNUMCHAR20
FRCELMNTORGADDRFROMDATEValid-from date - in current Release only 00010101 possibleAD_DATE_FRDATS16
NATIONVersion ID for International AddressesAD_NATIONCHAR2
FRCELMNTORGADDRGEOLOCLONGITUDEGeolocation Longitude/ISDFPS/GEOLONDEC8
FRCELMNTORGADDRGEOLOCLATITUDEGeolocation Latitude/ISDFPS/GEOLATDEC8
FRCELMNTORGADDRGEOLOCALTITUDEGeolocation Altitude/ISDFPS/GEOALTDEC5
FRCELMNTORGADDRGEOLOCATIONLocation Code/ISDFPS/LOCATION_CODECHAR12
FRCELMNTORGPLNGSTSCRITLTYINT11
FRCELMNTORGVALDTYSTARTDATEFOEDStart DateBEGDATUMDATS16
FRCELMNTORGVALDTYENDDATEFOEDEnd DateENDDATUMDATS16
FRCELMNTORGSUBTYPEFOEDSubtypeSUBTYPCHAR8
FRCELMNTORGADDRTODATEValid-to date in current Release only 99991231 possibleAD_DATE_TODATS16
FRCELMNTORGADDRTITLEForm-of-Address KeyAD_TITLECHAR8
FRCELMNTORGADDRNAME1Name 1AD_NAME1CHAR80
FRCELMNTORGADDRNAME2Name 2AD_NAME2CHAR80
FRCELMNTORGADDRNAME3Name 3AD_NAME3CHAR80
FRCELMNTORGADDRNAME4Name 4AD_NAME4CHAR80
FRCELMNTORGADDRCAREOFNAMEc/o nameAD_NAME_COCHAR80
CITYNAMECityAD_CITY1CHAR80
FRCELMNTORGADDRDISTRICTDistrictAD_CITY2CHAR80
HOMECITYNAMECity (different from postal city)AD_CITY3CHAR80
REGIONALSTRUCTUREGROUPINGRegional structure groupingREGIOGROUPCHAR16
POSTALCODECity postal codeAD_PSTCD1CHAR20
FRCELMNTORGADDRPOBOXPOSTALCODEPO Box Postal CodeAD_PSTCD2CHAR20
COMPANYPOSTALCODECompany Postal Code (for Large Customers)AD_PSTCD3CHAR20
POBOXPO BoxAD_POBXCHAR20
FRCELMNTORGADDRNONDELIVREASONStreet Address Undeliverable FlagAD_NO_USESCHAR8
FRCELMNTORGPOBOXNONDELIVRSNPO Box Address Undeliverable FlagAD_NO_USEPCHAR8
FRCELMNTORGISPOBOXWTHOUTNMBRFlag: PO Box Without NumberAD_POBXNUMCHAR2
FRCELMNTORGADDRPOBOXCITYNAMEPO Box cityAD_POBXLOCCHAR80
FRCELMNTORGADDRPOBOXREGIONRegion for PO Box (Country/Region, State, Province, ...)AD_POBXREGCHAR6
FRCELMNTORGADDRPOBOXCOUNTRYPO Box of Country/RegionAD_POBXCTYCHAR6
TRANSPORTZONETransportation zone to or from which the goods are deliveredLZONECHAR20
STREETNAMEStreetAD_STREETCHAR120
HOUSENUMBERHouse NumberAD_HSNM1CHAR20
FRCELMNTORGHSNMBRSUPLMNTTEXTHouse number supplementAD_HSNM2CHAR20
FRCELMNTORGADDRSTREETNAME2Street 2AD_STRSPP1CHAR80
FRCELMNTORGADDRSTREETNAME3Street 3AD_STRSPP2CHAR80
FRCELMNTORGADDRSTREETNAME4Street 4AD_STRSPP3CHAR80
FRCELMNTORGADDRLOCATIONNAMEStreet 5AD_LCTNCHAR80
BUILDINGBuilding (Number or Code)AD_BLDNGCHAR40
FLOORFloor in buildingAD_FLOORCHAR20
ROOMNUMBERRoom or Apartment NumberAD_ROOMNUMCHAR20
COUNTRYCODECountry/Region KeyLAND1CHAR6
LANGUAGECODELanguage KeySPRASLANG2
REGIONRegion (State, Province, County)REGIOCHAR6
ADDRESSSEARCHTEXT1Search Term 1AD_SORT1CHAR40
ADDRESSSEARCHTEXT2Search Term 2AD_SORT2CHAR40
COMMUNICATIONMEDIUMTYPECommunication Method (Key) (Business Address Services)AD_COMMCHAR6
ADDRESSFAXNUMBERFirst Fax No.: Area Code + NumberAD_FXNMBR1CHAR60
FRCELMNTORGADDRFAXNUMBEREXTNFirst fax no.: extensionAD_FXXTNS1CHAR20
ADDRESSTIMEZONEAddress time zoneAD_TZONECHAR12
FRCELMNTORGADDRTAXJURISDICTIONTax JurisdictionAD_TXJCDCHAR30
FRCELMNTORGADDRPOBOXLOBBYNAMEPO Box LobbyAD_PO_BOX_LBYCHAR80
DELIVERYSERVICETYPECODEType of Delivery ServiceAD_DELIVERY_SERVICE_TYPECHAR8
FRCELMNTORGADDRDELIVSRVCNUMBERNumber of Delivery ServiceAD_DELIVERY_SERVICE_NUMBERCHAR20
PERSONNUMBERPerson NumberAD_PERSNUMCHAR20
FRCELMNTORGADDRSEQUENCENUMBERSequence NumberAD_CONSNUMNUMC6
FRCELMNTORGADDRTELEPHONENUMBERTelephone no.: dialling code+numberAD_TLNMBRCHAR60
FRCELMNTORGADDRTELEXTENSIONTelephone no.: ExtensionAD_TLXTNSCHAR20
FRCELMNTORGADDRCELLPHONENUMBERTelephone no.: dialling code+numberAD_TLNMBRCHAR60
PHONENUMBERTYPEIndicator: Telephone is a Mobile TelephoneAD_FLGMOBCHAR2
ADDRESSTEXTAddress notesAD_REMARK1CHAR100
EMAILADDRESSE-Mail AddressAD_SMTPADRCHAR482
FRCELMNTORGGEOLOCATIONUUIDGUID 16GEOGUIDRAW16
ADDRESSIDAddress NumberAD_ADDRNUMCHAR20
FRCELMNTORGGEOLOCLONGITUDEGeo location longitudeGEOLONDEC8
FRCELMNTORGGEOLOCLATITUDEGeo location latitudeGEOLATDEC8
FRCELMNTORGGEOLOCALTITUDEGeo location heightGEOALTDEC5
FRCELMNTORGGEOLOCPRECISIONPrecision (street, postal code, ...) of a Geo locationGEOPRECISNUMC8
FRCELMNTORGGEOLOCTIMEZONETime ZoneTIMEZONECHAR12
FRCELMNTORGGEOLOCCRTNDTETIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TIMESTAMPDEC8
FRCELMNTORGGEOLOCCREATEDBYUSERUser NameUNAMECHAR24
FRCELMNTORGGEOLOCCHGDDATETIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TIMESTAMPDEC8
FRCELMNTORGGEOLOCLASTCHGDBYUSRUser NameUNAMECHAR24
FRCELMNTORGADDRGEOLOCLONFOEDGeo location longitudeGEOLONDEC8
FRCELMNTORGADDRGEOLOCLATFOEDGeo location latitudeGEOLATDEC8
FRCELMNTORGADDRGEOLOCALTDFOEDGeo location heightGEOALTDEC5
HASACTIVEENTITYDraft - Indicator - Has active documentSDRAFT_HAS_ACTIVECHAR2
.INCLUDESDRAFT_WRITE_DRAFT_ADMIN0
DRAFTENTITYCREATIONDATETIMEDraft Created OnSDRAFT_CREATED_ATDEC11
DRAFTENTITYLASTCHANGEDATETIMEDraft Last Changed OnSDRAFT_LAST_CHANGED_ATDEC11
DRAFTADMINISTRATIVEDATAUUIDTechnical ID for the Administrative Data of a Draft DocumentSDRAFT_ADMIN_UUIDRAW16
DRAFTENTITYCONSISTENCYSTATUSDraft - Consistency StatusSDRAFT_CONSISTENCY_STATUSCHAR2
DRAFTENTITYOPERATIONCODEDraft - Operation CodeSDRAFT_OPERATION_CODECHAR2
Privacy Policy