I_ADDRORGNAMEPOSTALADDRESS

CDS View
64 Fields 11 CDS Views

Postal Address and Organization Name

I_ADDRORGNAMEPOSTALADDRESS is a CDS View in S/4HANA. Postal Address and Organization Name. It contains 64 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
CRMS4_IU_C_PRMFTS view inner Premise by free text
I_AddressPostalAddress view_entity from BASIC Postal Address
I_BankOrganizationAddress view_entity from COMPOSITE Address of an Organization used for Bank
I_EWA_SalesContractCube view_entity inner COMPOSITE Sales Contract - Cube
I_OrganizationAddress view_entity from BASIC Address of an Organization
I_OrgNamePostlAddrDfltRprstn view_entity from COMPOSITE Dflt Addr Rprstn for Org and Postal
I_PostalWorkplaceAddress view_entity union BASIC Person Address type from ADRC & ADCP
P_BillingAddrOrgNamePostalAddr view_entity from COMPOSITE
P_EWM_Address view_entity from COMPOSITE
R_AddrAddlRepresentationTP view_entity from Additional Representation - TP
R_OrganizationAddressTP view_entity from Organization Address - TP

Fields (64)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 2
KEY AddressRepresentationCode AddressRepresentationCode 3
_AddressRepresentationCode _AddressRepresentationCode 1
_Country _Country 4
_FormOfAddress _FormOfAddress 2
_Region _Region 4
_TransportationZone _TransportationZone 3
AddressChangedByUser AddressChangedByUser 2
AddressChangedOnDateTime AddressChangedOnDateTime 1
AddressCreatedByUser AddressCreatedByUser 2
AddressCreatedOnDateTime AddressCreatedOnDateTime 1
AddresseeName1 AddresseeName1 3
AddresseeName2 AddresseeName2 3
AddresseeName3 AddresseeName3 3
AddresseeName4 AddresseeName4 3
AddressGroup AddressGroup 3
AddressIsPersonAddress AddressIsPersonAddress 3
AddressSearchTerm1 AddressSearchTerm1 3
AddressSearchTerm2 AddressSearchTerm2 3
AddressTimeZone AddressTimeZone 3
Building Building 3
CareOfName CareOfName 3
CityName CityName 4
CityNumber CityNumber 3
CompanyPostalCode CompanyPostalCode 3
CorrespondenceLanguage CorrespondenceLanguage 3
Country Country 4
DeliveryServiceNumber DeliveryServiceNumber 3
DeliveryServiceTypeCode DeliveryServiceTypeCode 3
DistrictName DistrictName 3
DistrictNumber DistrictNumber 1
Floor Floor 3
FormOfAddress FormOfAddress 3
HouseNumber HouseNumber 4
HouseNumberSupplementText HouseNumberSupplementText 3
POBox POBox 3
POBoxAddrNonDeliverableReason POBoxAddrNonDeliverableReason 3
POBoxDeviatingCityCode POBoxDeviatingCityCode 3
POBoxDeviatingCityName POBoxDeviatingCityName 3
POBoxDeviatingCountry POBoxDeviatingCountry 3
POBoxDeviatingRegion POBoxDeviatingRegion 3
POBoxIsWithoutNumber POBoxIsWithoutNumber 3
POBoxLobbyName POBoxLobbyName 3
POBoxPostalCode POBoxPostalCode 3
PostalCode PostalCode 4
PrfrdCommMediumType PrfrdCommMediumType 3
Region Region 4
RegionalStructureCheckStatus RegionalStructureCheckStatus 3
RegionalStructureGroup RegionalStructureGroup 1
RoomNumber RoomNumber 3
SecondaryRegion SecondaryRegion 3
SecondaryRegionName SecondaryRegionName 3
Street Street 3
StreetAddrNonDeliverableReason StreetAddrNonDeliverableReason 3
StreetName StreetName 4
StreetPrefixName1 StreetPrefixName1 3
StreetPrefixName2 StreetPrefixName2 3
StreetSuffixName1 StreetSuffixName1 3
StreetSuffixName2 StreetSuffixName2 3
TaxJurisdiction TaxJurisdiction 3
TertiaryRegion TertiaryRegion 3
TertiaryRegionName TertiaryRegionName 3
TransportZone TransportZone 3
VillageName VillageName 3

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.

-- Postal Address and Organization Name
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ADDRORGNAMEPOSTALADDRESS (
    ADDRESSID,
    ADDRESSREPRESENTATIONCODE,
    _ADDRESSREPRESENTATIONCODE,
    _COUNTRY,
    _FORMOFADDRESS,
    _REGION,
    _TRANSPORTATIONZONE,
    ADDRESSCHANGEDBYUSER,
    ADDRESSCHANGEDONDATETIME,
    ADDRESSCREATEDBYUSER,
    ADDRESSCREATEDONDATETIME,
    ADDRESSEENAME1,
    ADDRESSEENAME2,
    ADDRESSEENAME3,
    ADDRESSEENAME4,
    ADDRESSGROUP,
    ADDRESSISPERSONADDRESS,
    ADDRESSSEARCHTERM1,
    ADDRESSSEARCHTERM2,
    ADDRESSTIMEZONE,
    BUILDING,
    CAREOFNAME,
    CITYNAME,
    CITYNUMBER,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICTNAME,
    DISTRICTNUMBER,
    FLOOR,
    FORMOFADDRESS,
    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,
    VILLAGENAME,
    PRIMARY KEY (ADDRESSID, ADDRESSREPRESENTATIONCODE)
);

Learn More