_ORGNAMEPOSTALADDRESS

51 Fields

_ORGNAMEPOSTALADDRESS is an SAP database table in S/4HANA. It contains 51 fields.

Fields (51)

KeyField CDS FieldsUsed in Views
_Country _Country 2
_Region _Region 2
AddressChangedByUser AddressChangedByUser 1
AddressChangedOnDateTime AddressChangedOnDateTime 1
AddressCreatedByUser AddressCreatedByUser 1
AddressCreatedOnDateTime AddressCreatedOnDateTime 1
AddressGroup AddressGroup 1
AddressTimeZone AddressTimeZone 1
Building Building 1
CareOfName CareOfName 1
CityName CityName 3
CityNumber CityNumber 1
CompanyPostalCode CompanyPostalCode 1
Country Country 5
DeliveryServiceNumber DeliveryServiceNumber 1
DeliveryServiceTypeCode DeliveryServiceTypeCode 1
DistrictName DistrictName 3
DistrictNumber DistrictNumber 1
Floor Floor 1
HouseNumber HouseNumber 3
HouseNumberSupplementText HouseNumberSupplementText 1
POBox POBox 3
POBoxAddrNonDeliverableReason POBoxAddrNonDeliverableReason 1
POBoxDeviatingCityCode POBoxDeviatingCityCode 1
POBoxDeviatingCityName POBoxDeviatingCityName 1
POBoxDeviatingCountry POBoxDeviatingCountry 1
POBoxDeviatingRegion POBoxDeviatingRegion 1
POBoxIsWithoutNumber POBoxIsWithoutNumber 1
POBoxLobbyName POBoxLobbyName 1
POBoxPostalCode POBoxPostalCode 3
PostalCode PostalCode 3
PrfrdCommMediumType PrfrdCommMediumType 1
Region Region 3
RegionalStructureCheckStatus RegionalStructureCheckStatus 1
RegionalStructureGroup RegionalStructureGroup 1
RoomNumber RoomNumber 1
SecondaryRegion SecondaryRegion 1
SecondaryRegionName SecondaryRegionName 1
Street Street 1
StreetAddrNonDeliverableReason StreetAddrNonDeliverableReason 1
StreetName StreetName 3
StreetPrefixName1 StreetPrefixName1 3
StreetPrefixName2 StreetPrefixName2 3
StreetSuffixName1 StreetSuffixName1 3
StreetSuffixName2 StreetSuffixName2 3
TaxJurisdiction TaxJurisdiction 3
TertiaryRegion TertiaryRegion 1
TertiaryRegionName TertiaryRegionName 1
TransportZone TransportZone 3
Village Village 1
VillageName VillageName 1

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 _ORGNAMEPOSTALADDRESS (
    _COUNTRY,
    _REGION,
    ADDRESSCHANGEDBYUSER,
    ADDRESSCHANGEDONDATETIME,
    ADDRESSCREATEDBYUSER,
    ADDRESSCREATEDONDATETIME,
    ADDRESSGROUP,
    ADDRESSTIMEZONE,
    BUILDING,
    CAREOFNAME,
    CITYNAME,
    CITYNUMBER,
    COMPANYPOSTALCODE,
    COUNTRY,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICTNAME,
    DISTRICTNUMBER,
    FLOOR,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    POBOX,
    POBOXADDRNONDELIVERABLEREASON,
    POBOXDEVIATINGCITYCODE,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    REGIONALSTRUCTURECHECKSTATUS,
    REGIONALSTRUCTUREGROUP,
    ROOMNUMBER,
    SECONDARYREGION,
    SECONDARYREGIONNAME,
    STREET,
    STREETADDRNONDELIVERABLEREASON,
    STREETNAME,
    STREETPREFIXNAME1,
    STREETPREFIXNAME2,
    STREETSUFFIXNAME1,
    STREETSUFFIXNAME2,
    TAXJURISDICTION,
    TERTIARYREGION,
    TERTIARYREGIONNAME,
    TRANSPORTZONE,
    VILLAGE,
    VILLAGENAME
);

Learn More