CUSTOMERDATA

34 Fields

CUSTOMERDATA is an SAP database table in S/4HANA. It contains 34 fields.

Fields (34)

KeyField CDS FieldsUsed in Views
AuthorizationGroup AuthorizationGroup 1
BPCustomerName BPCustomerName 1
BPIsOrganization BusinessPartnerIsOrganization 1
BusinessPartner BusinessPartner 1
BusinessPartnerName BusinessPartnerName 1
Country CustomerCountry 1
CustCoIsBusPrpsCmpltd CustCoIsBusPrpsCmpltd 3
Customer Customer 2
CustomerAccountGroup CustomerAccountGroup 3
CustomerCompanyAuthznGroup CustomerCompanyAuthznGroup 3
CustomerFinsAuthorizationGrp CustomerAuthznGrp,CustomerFinsAuthorizationGrp 3
CustomerIsBusPrpsCmpltd CustomerIsBusPrpsCmpltd 3
CustomerName CustomerName 1
DataController1 BP1DataController1 1
DataController10 BP1DataController10 1
DataController2 BP1DataController2 1
DataController3 BP1DataController3 1
DataController4 BP1DataController4 1
DataController5 BP1DataController5 1
DataController6 BP1DataController6 1
DataController7 BP1DataController7 1
DataController8 BP1DataController8 1
DataController9 BP1DataController9 1
DataControllerSet BP1DataControllerSet 1
FirstName FirstName 1
IsNaturalPerson BusinessPartnerIsNaturalPerson 1
LastName LastName 1
MiddleName MiddleName 1
RU_PartnerOrganizationINN RU_PartnerOrganizationINN 1
RU_PartnerOrganizationKPP RU_PartnerOrganizationKPP 1
RU_PartnerPersonINN RU_PartnerPersonINN 1
Supplier Supplier 1
TaxNumber1 TaxNumber1 1
TaxNumber3 TaxNumber3 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 CUSTOMERDATA (
    AUTHORIZATIONGROUP,
    BPCUSTOMERNAME,
    BPISORGANIZATION,
    BUSINESSPARTNER,
    BUSINESSPARTNERNAME,
    COUNTRY,
    CUSTCOISBUSPRPSCMPLTD,
    CUSTOMER,
    CUSTOMERACCOUNTGROUP,
    CUSTOMERCOMPANYAUTHZNGROUP,
    CUSTOMERFINSAUTHORIZATIONGRP,
    CUSTOMERISBUSPRPSCMPLTD,
    CUSTOMERNAME,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    FIRSTNAME,
    ISNATURALPERSON,
    LASTNAME,
    MIDDLENAME,
    RU_PARTNERORGANIZATIONINN,
    RU_PARTNERORGANIZATIONKPP,
    RU_PARTNERPERSONINN,
    SUPPLIER,
    TAXNUMBER1,
    TAXNUMBER3
);

Learn More