_BUSINESSPARTNERADDRESS

24 Fields

_BUSINESSPARTNERADDRESS is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
KEY AddressNumber AddressNumber 3
AddressLine1Text AddressLine1Text 1
AddressUUID BusinessPartnerAddressUUID 2
City City 1
CityName CityName 4
CompanyPostalCode CompanyPostalCode 3
Country Country 7
DeliveryServiceNumber DeliveryServiceNumber 3
DeliveryServiceTypeCode DeliveryServiceTypeCode 3
HouseNumber HouseNumber 3
POBox POBox 3
POBoxDeviatingCityName POBoxDeviatingCityName 3
POBoxDeviatingCountry POBoxDeviatingCountry 3
POBoxDeviatingRegion POBoxDeviatingRegion 3
POBoxIsWithoutNumber POBoxIsWithoutNumber 3
POBoxPostalCode POBoxPostalCode 3
PostalCode PostalCode 7
Region Region 4
Street Street 1
StreetName StreetName 3
TaxJurisdiction TaxJurisdiction 3
TransportZone TransportZone 3
ValidityEndDate ValidityEndDateTime 1
ValidityStartDate ValidityStartDateTime 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 _BUSINESSPARTNERADDRESS (
    ADDRESSNUMBER,
    ADDRESSLINE1TEXT,
    ADDRESSUUID,
    CITY,
    CITYNAME,
    COMPANYPOSTALCODE,
    COUNTRY,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    HOUSENUMBER,
    POBOX,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXPOSTALCODE,
    POSTALCODE,
    REGION,
    STREET,
    STREETNAME,
    TAXJURISDICTION,
    TRANSPORTZONE,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (ADDRESSNUMBER)
);

Learn More