CIC_CUSTBPADDRESS

CDS View
23 Fields 1 CDS Views

Proj. View on BP Address

CIC_CUSTBPADDRESS is a CDS View in S/4HANA. Proj. View on BP Address. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
CIC_CustomerAddress view_entity from Proj. View on Customer Address

Fields (23)

KeyField CDS FieldsUsed in Views
KEY AddressNumber AddressNumber 1
KEY BusinessPartner BusinessPartner 1
_OrganizationAddress _OrganizationAddress 1
AdditionalCityName AdditionalCityName 1
AddressTimeZone AddressTimeZone 1
Building Building 1
BusinessPartnerName1 BusinessPartnerName1 1
BusinessPartnerName2 BusinessPartnerName2 1
BusinessPartnerName3 BusinessPartnerName3 1
BusinessPartnerName4 BusinessPartnerName4 1
CareOfName CareOfName 1
CityCode CityCode 1
CityName CityName 1
Country Country 1
Floor Floor 1
HouseNumber HouseNumber 1
Person Person 1
PostalCode PostalCode 1
Region Region 1
RoomNumber RoomNumber 1
StreetName StreetName 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

-- Proj. View on BP Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CIC_CUSTBPADDRESS (
    ADDRESSNUMBER,
    BUSINESSPARTNER,
    _ORGANIZATIONADDRESS,
    ADDITIONALCITYNAME,
    ADDRESSTIMEZONE,
    BUILDING,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    BUSINESSPARTNERNAME3,
    BUSINESSPARTNERNAME4,
    CAREOFNAME,
    CITYCODE,
    CITYNAME,
    COUNTRY,
    FLOOR,
    HOUSENUMBER,
    PERSON,
    POSTALCODE,
    REGION,
    ROOMNUMBER,
    STREETNAME,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (ADDRESSNUMBER, BUSINESSPARTNER)
);

Learn More