_ORGANIZATIONADDRESS

48 Fields

_ORGANIZATIONADDRESS is an SAP database table in S/4HANA. It contains 48 fields.

Fields (48)

KeyField CDS FieldsUsed in Views
_Country _Country 2
_EmailAddress _EmailAddress 1
_FormOfAddress _FormOfAddress 2
_Region _Region 4
AddresseeFullName FullName 5
AddresseeName1 BusinessPartnerName1 3
AddresseeName2 BusinessPartnerName2 6
AddresseeName3 BusinessPartnerName3 3
AddresseeName4 BusinessPartnerName4 3
AddressID AddressID 3
AddressPersonID AddressPersonID 1
AddressRepresentationCode Nation 2
AddressSearchTerm1 SearchTerm1 2
AddressTimeZone AddressTimeZone 3
Building Building 2
CareOfName CareOfName 2
CityName CityName,PlantCityName 6
CityNumber CityCode 2
CompanyPostalCode CompanyPostalCode 2
CorrespondenceLanguage CorrespondenceLanguage 2
Country Country,PlantCountry 6
DeliveryServiceNumber DeliveryServiceNumber 2
DeliveryServiceTypeCode DeliveryServiceTypeCode 2
DistrictName District 2
Floor Floor 2
FormOfAddress FormOfAddress 3
HouseNumber HouseNumber 3
HouseNumberSupplementText HouseNumberSupplementText 2
POBox POBox 2
POBoxDeviatingCityName POBoxDeviatingCityName 2
POBoxDeviatingCountry POBoxDeviatingCountry 2
POBoxDeviatingRegion POBoxDeviatingRegion 2
POBoxIsWithoutNumber POBoxIsWithoutNumber 2
POBoxLobbyName POBoxLobbyName 2
POBoxPostalCode POBoxPostalCode 2
PostalCode PlantPostalCode,PostalCode 6
PrfrdCommMediumType PrfrdCommMediumType 2
Region PlantRegion,Region 6
RoomNumber RoomNumber 2
SecondaryRegionName County 2
StreetName PlantStreetName,StreetName 6
StreetPrefixName1 StreetPrefixName 2
StreetPrefixName2 AdditionalStreetPrefixName 2
StreetSuffixName1 StreetSuffixName 2
StreetSuffixName2 AdditionalStreetSuffixName 2
TaxJurisdiction TaxJurisdiction 2
TransportZone TransportZone 2
VillageName HomeCityName 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 _ORGANIZATIONADDRESS (
    _COUNTRY,
    _EMAILADDRESS,
    _FORMOFADDRESS,
    _REGION,
    ADDRESSEEFULLNAME,
    ADDRESSEENAME1,
    ADDRESSEENAME2,
    ADDRESSEENAME3,
    ADDRESSEENAME4,
    ADDRESSID,
    ADDRESSPERSONID,
    ADDRESSREPRESENTATIONCODE,
    ADDRESSSEARCHTERM1,
    ADDRESSTIMEZONE,
    BUILDING,
    CAREOFNAME,
    CITYNAME,
    CITYNUMBER,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICTNAME,
    FLOOR,
    FORMOFADDRESS,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    POBOX,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    ROOMNUMBER,
    SECONDARYREGIONNAME,
    STREETNAME,
    STREETPREFIXNAME1,
    STREETPREFIXNAME2,
    STREETSUFFIXNAME1,
    STREETSUFFIXNAME2,
    TAXJURISDICTION,
    TRANSPORTZONE,
    VILLAGENAME
);

Learn More