_FRCELMNTORGBUSINESSADDRESS

46 Fields

_FRCELMNTORGBUSINESSADDRESS is an SAP database table in S/4HANA. It contains 46 fields.

Fields (46)

KeyField CDS FieldsUsed in Views
AddressFaxNumber AddressFaxNumber 2
AddressGroup AddressGroup 1
AddressSearchText1 AddressSearchText1 2
AddressSearchText2 AddressSearchText2 2
AddressTimeZone AddressTimeZone 2
Building Building 2
CityName CityName 2
CommunicationMediumType CommunicationMediumType 2
CompanyPostalCode CompanyPostalCode 2
CountryCode CountryCode 2
DeliveryServiceTypeCode DeliveryServiceTypeCode 2
Floor Floor 2
FrcElmntOrgAddrCareOfName FrcElmntOrgAddrCareOfName 2
FrcElmntOrgAddrDelivSrvcNumber FrcElmntOrgAddrDelivSrvcNumber 2
FrcElmntOrgAddrDistrict FrcElmntOrgAddrDistrict 2
FrcElmntOrgAddrFaxNumberExtn FrcElmntOrgAddrFaxNumberExtn 2
FrcElmntOrgAddrLocationName FrcElmntOrgAddrLocationName 2
FrcElmntOrgAddrName1 FrcElmntOrgAddrName1 2
FrcElmntOrgAddrName2 FrcElmntOrgAddrName2 2
FrcElmntOrgAddrName3 FrcElmntOrgAddrName3 2
FrcElmntOrgAddrName4 FrcElmntOrgAddrName4 2
FrcElmntOrgAddrNonDelivReason FrcElmntOrgAddrNonDelivReason 2
FrcElmntOrgAddrPOBoxCityName FrcElmntOrgAddrPOBoxCityName 2
FrcElmntOrgAddrPOBoxCountry FrcElmntOrgAddrPOBoxCountry 2
FrcElmntOrgAddrPOBoxLobbyName FrcElmntOrgAddrPOBoxLobbyName 2
FrcElmntOrgAddrPOBoxPostalCode FrcElmntOrgAddrPOBoxPostalCode 2
FrcElmntOrgAddrPOBoxRegion FrcElmntOrgAddrPOBoxRegion 2
FrcElmntOrgAddrStreetName2 FrcElmntOrgAddrStreetName2 2
FrcElmntOrgAddrStreetName3 FrcElmntOrgAddrStreetName3 2
FrcElmntOrgAddrStreetName4 FrcElmntOrgAddrStreetName4 2
FrcElmntOrgAddrTaxJurisdiction FrcElmntOrgAddrTaxJurisdiction 2
FrcElmntOrgAddrTitle FrcElmntOrgAddrTitle 1
FrcElmntOrgAddrToDate FrcElmntOrgAddrToDate 1
FrcElmntOrgHsNmbrSuplmntText FrcElmntOrgHsNmbrSuplmntText 2
FrcElmntOrgIsPOBoxWthoutNmbr FrcElmntOrgIsPOBoxWthoutNmbr 2
FrcElmntOrgPOBoxNonDelivRsn FrcElmntOrgPOBoxNonDelivRsn 2
HomeCityName HomeCityName 2
HouseNumber HouseNumber 2
LanguageCode LanguageCode 2
POBox POBox 2
PostalCode PostalCode 2
Region Region 2
RegionalStructureGrouping RegionalStructureGrouping 2
RoomNumber RoomNumber 2
StreetName StreetName 2
TransportZone TransportZone 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _FRCELMNTORGBUSINESSADDRESS (
    ADDRESSFAXNUMBER,
    ADDRESSGROUP,
    ADDRESSSEARCHTEXT1,
    ADDRESSSEARCHTEXT2,
    ADDRESSTIMEZONE,
    BUILDING,
    CITYNAME,
    COMMUNICATIONMEDIUMTYPE,
    COMPANYPOSTALCODE,
    COUNTRYCODE,
    DELIVERYSERVICETYPECODE,
    FLOOR,
    FRCELMNTORGADDRCAREOFNAME,
    FRCELMNTORGADDRDELIVSRVCNUMBER,
    FRCELMNTORGADDRDISTRICT,
    FRCELMNTORGADDRFAXNUMBEREXTN,
    FRCELMNTORGADDRLOCATIONNAME,
    FRCELMNTORGADDRNAME1,
    FRCELMNTORGADDRNAME2,
    FRCELMNTORGADDRNAME3,
    FRCELMNTORGADDRNAME4,
    FRCELMNTORGADDRNONDELIVREASON,
    FRCELMNTORGADDRPOBOXCITYNAME,
    FRCELMNTORGADDRPOBOXCOUNTRY,
    FRCELMNTORGADDRPOBOXLOBBYNAME,
    FRCELMNTORGADDRPOBOXPOSTALCODE,
    FRCELMNTORGADDRPOBOXREGION,
    FRCELMNTORGADDRSTREETNAME2,
    FRCELMNTORGADDRSTREETNAME3,
    FRCELMNTORGADDRSTREETNAME4,
    FRCELMNTORGADDRTAXJURISDICTION,
    FRCELMNTORGADDRTITLE,
    FRCELMNTORGADDRTODATE,
    FRCELMNTORGHSNMBRSUPLMNTTEXT,
    FRCELMNTORGISPOBOXWTHOUTNMBR,
    FRCELMNTORGPOBOXNONDELIVRSN,
    HOMECITYNAME,
    HOUSENUMBER,
    LANGUAGECODE,
    POBOX,
    POSTALCODE,
    REGION,
    REGIONALSTRUCTUREGROUPING,
    ROOMNUMBER,
    STREETNAME,
    TRANSPORTZONE
);

Learn More