P_RU_CUSTOMERDATA1

CDS View
23 Fields 2 CDS Views

P_RU_CUSTOMERDATA1 is a CDS View in S/4HANA. It contains 23 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RU_CustomerCompanyData view from CONSUMPTION
P_RU_CustomerData view from COMPOSITE

Fields (23)

KeyField CDS FieldsUsed in Views
KEY Customer Customer 2
_CustomerCompany _CustomerCompany 1
AddressID AddressID 2
AuthorizationGroup AuthorizationGroup,CustomerFinsAuthorizationGrp 2
BusinessPartner BusinessPartner 2
BusinessPartnerCategory BusinessPartnerCategory 2
Country Country 1
CustomerAccountGroup CustomerAccountGroup 2
DataController1 DataController1 2
DataController10 DataController10 2
DataController2 DataController2 2
DataController3 DataController3 2
DataController4 DataController4 2
DataController5 DataController5 2
DataController6 DataController6 2
DataController7 DataController7 2
DataController8 DataController8 2
DataController9 DataController9 2
DataControllerSet DataControllerSet 2
IsBusinessPurposeCompleted CustomerIsBusPrpsCmpltd,IsBusinessPurposeCompleted 2
IsNaturalPerson IsNaturalPerson 1
IsOneTimeAccount IsOneTimeAccount 1
PersonNumber PersonNumber 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RU_CUSTOMERDATA1 (
    CUSTOMER,
    _CUSTOMERCOMPANY,
    ADDRESSID,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNER,
    BUSINESSPARTNERCATEGORY,
    COUNTRY,
    CUSTOMERACCOUNTGROUP,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    ISBUSINESSPURPOSECOMPLETED,
    ISNATURALPERSON,
    ISONETIMEACCOUNT,
    PERSONNUMBER,
    PRIMARY KEY (CUSTOMER)
);

Learn More