I_BUSINESSPARTNERADDRESSTP

CDS View
55 Fields 1 CDS Views

Business Partner Address

I_BUSINESSPARTNERADDRESSTP is a CDS View in S/4HANA. Business Partner Address. It contains 55 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_BusinessPartnerAddress view from CONSUMPTION Business Partner Address

Fields (55)

KeyField CDS FieldsUsed in Views
KEY AddressNumber AddressNumber 1
KEY BusinessPartner BusinessPartner 1
AdditionalStreetPrefixName AdditionalStreetPrefixName 1
AdditionalStreetSuffixName AdditionalStreetSuffixName 1
AddressMoveDate AddressMoveDate 1
AddressNumberForEdit AddressNumberForEdit 1
AddressTimeZone AddressTimeZone 1
AddressValidityEndDate AddressValidityEndDate 1
AddressValidityStartDate AddressValidityStartDate 1
BPTargetAddressID BPTargetAddressID 1
BPTargetAddressText BPTargetAddressText 1
BusinessPartnerForEdit BusinessPartnerForEdit 1
CareOfName CareOfName 1
CityName CityName 1
CompanyPostalCode CompanyPostalCode 1
CorrespondenceLanguage CorrespondenceLanguage 1
Country Country 1
County County 1
CustomerSupplierCityName CustomerSupplierCityName 1
CustomerSupplierStreetName CustomerSupplierStreetName 1
DeliveryServiceNumber DeliveryServiceNumber 1
DeliveryServiceTypeCode DeliveryServiceTypeCode 1
District District 1
EmailAddress EmailAddress 1
FaxCountry FaxCountry 1
FaxNumber FaxNumber 1
FaxNumberExtension FaxNumberExtension 1
HomeCityName HomeCityName 1
HouseNumber HouseNumber 1
HouseNumberSupplementText HouseNumberSupplementText 1
MobilePhoneCountry MobilePhoneCountry 1
MobilePhoneNumber MobilePhoneNumber 1
PhoneNumber PhoneNumber 1
PhoneNumberCountry PhoneNumberCountry 1
PhoneNumberExtension PhoneNumberExtension 1
POBox POBox 1
POBoxDeviatingCityName POBoxDeviatingCityName 1
POBoxDeviatingCountry POBoxDeviatingCountry 1
POBoxDeviatingRegion POBoxDeviatingRegion 1
POBoxIsWithoutNumber POBoxIsWithoutNumber 1
POBoxLobbyName POBoxLobbyName 1
POBoxPostalCode POBoxPostalCode 1
PostalCode PostalCode 1
PrfrdCommMediumType PrfrdCommMediumType 1
Region Region 1
StandardUsage StandardUsage 1
StreetName StreetName 1
StreetPrefixName StreetPrefixName 1
StreetSuffixName StreetSuffixName 1
TaxJurisdiction TaxJurisdiction 1
TaxJurisdictionByProvider TaxJurisdictionByProvider 1
TownshipName TownshipName 1
TransportZone TransportZone 1
URLFieldLength URLFieldLength 1
WebsiteURL WebsiteURL 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.

-- Business Partner Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPARTNERADDRESSTP (
    ADDRESSNUMBER,
    BUSINESSPARTNER,
    ADDITIONALSTREETPREFIXNAME,
    ADDITIONALSTREETSUFFIXNAME,
    ADDRESSMOVEDATE,
    ADDRESSNUMBERFOREDIT,
    ADDRESSTIMEZONE,
    ADDRESSVALIDITYENDDATE,
    ADDRESSVALIDITYSTARTDATE,
    BPTARGETADDRESSID,
    BPTARGETADDRESSTEXT,
    BUSINESSPARTNERFOREDIT,
    CAREOFNAME,
    CITYNAME,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    COUNTY,
    CUSTOMERSUPPLIERCITYNAME,
    CUSTOMERSUPPLIERSTREETNAME,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICT,
    EMAILADDRESS,
    FAXCOUNTRY,
    FAXNUMBER,
    FAXNUMBEREXTENSION,
    HOMECITYNAME,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    MOBILEPHONECOUNTRY,
    MOBILEPHONENUMBER,
    PHONENUMBER,
    PHONENUMBERCOUNTRY,
    PHONENUMBEREXTENSION,
    POBOX,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    STANDARDUSAGE,
    STREETNAME,
    STREETPREFIXNAME,
    STREETSUFFIXNAME,
    TAXJURISDICTION,
    TAXJURISDICTIONBYPROVIDER,
    TOWNSHIPNAME,
    TRANSPORTZONE,
    URLFIELDLENGTH,
    WEBSITEURL,
    PRIMARY KEY (ADDRESSNUMBER, BUSINESSPARTNER)
);

Learn More