I_SCRIPTEDORGANIZATIONADDRESS

CDS View
45 Fields 2 CDS Views

Interational Address Version

I_SCRIPTEDORGANIZATIONADDRESS is a CDS View in S/4HANA. Interational Address Version. It contains 45 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BusPartScriptedGroupAddress view inner BASIC International version of a business partner address
I_BusPartScriptedOrgAddress view inner BASIC International version of a business partner address

Fields (45)

KeyField CDS FieldsUsed in Views
KEY AddressRepresentationCode AddressRepresentationCode 2
AdditionalStreetPrefixName AdditionalStreetPrefixName 2
AdditionalStreetSuffixName AdditionalStreetSuffixName 2
AddressNonDeliverableReason AddressNonDeliverableReason 2
AddressTimeZone AddressTimeZone 2
Building Building 2
BusinessPartnerName1 BusinessPartnerName1 2
BusinessPartnerName2 BusinessPartnerName2 2
BusinessPartnerName3 BusinessPartnerName3 1
BusinessPartnerName4 BusinessPartnerName4 1
CareOfName CareOfName 2
CityFileTestStatus CityFileTestStatus 1
CityName CityName 2
CompanyPostalCode CompanyPostalCode 2
CorrespondenceLanguage CorrespondenceLanguage 2
Country Country 2
County BPCountyText,County 2
DeliveryServiceNumber DeliveryServiceNumber 2
DeliveryServiceTypeCode DeliveryServiceTypeCode 2
District District,DistrictName 2
Floor Floor 2
FormOfAddress FormOfAddress 2
FullName FullName 2
HomeCityName HomeCityName 2
HouseNumber HouseNumber 2
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 PostalCode 2
PostBoxNonDeliverableReason PostBoxNonDeliverableReason 2
PrfrdCommMediumType PrfrdCommMediumType 2
Region Region 2
RoomNumber RoomNumber 2
SearchTerm1 SearchTerm1 2
SearchTerm2 SearchTerm2 2
StreetName StreetName 2
StreetPrefixName StreetPrefixName 2
StreetSuffixName StreetSuffixName 2
TaxJurisdiction TaxJurisdiction 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.

-- Interational Address Version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SCRIPTEDORGANIZATIONADDRESS (
    ADDRESSREPRESENTATIONCODE,
    ADDITIONALSTREETPREFIXNAME,
    ADDITIONALSTREETSUFFIXNAME,
    ADDRESSNONDELIVERABLEREASON,
    ADDRESSTIMEZONE,
    BUILDING,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    BUSINESSPARTNERNAME3,
    BUSINESSPARTNERNAME4,
    CAREOFNAME,
    CITYFILETESTSTATUS,
    CITYNAME,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    COUNTY,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICT,
    FLOOR,
    FORMOFADDRESS,
    FULLNAME,
    HOMECITYNAME,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    POBOX,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    POSTBOXNONDELIVERABLEREASON,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    ROOMNUMBER,
    SEARCHTERM1,
    SEARCHTERM2,
    STREETNAME,
    STREETPREFIXNAME,
    STREETSUFFIXNAME,
    TAXJURISDICTION,
    TRANSPORTZONE,
    PRIMARY KEY (ADDRESSREPRESENTATIONCODE)
);

Learn More