CUSTOMER

66 Fields

CUSTOMER is an SAP database table in S/4HANA. It contains 66 fields.

Fields (66)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY belnr belnr 1
KEY bukrs bukrs 1
KEY buzei buzei 1
KEY CompanyCode CompanyCode 2
KEY Customer Customer,SoldToParty 10
KEY gjahr gjahr 1
KEY koart koart 1
KEY konko konko 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY SoldToParty SoldToParty 1
_CompanyCode _CompanyCode 2
_Customer _Customer 1
_CustomerText _CustomerText 1
AddressID AddressID 1
AuthorizationGroup AuthorizationGroup,CustomerAuthznGrp 8
BusinessPartner BusinessPartner 2
businessPartnerId businessPartnerId 2
BusinessPartnerName1 BusinessPartnerName1 1
BusinessPartnerName2 BusinessPartnerName2 1
BusinessPartnerUUID BusinessPartnerUUID 2
CityName CityName 1
company_name companyName 2
Country Country,CustomerCountry 3
CustomerAccountGroup CustomerAccountGroup 4
CustomerClassification CustomerClassification 1
CustomerFullName CustomerFullName 1
CustomerName CustomerName 6
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
DeletionIndicator DeletionIndicator 1
DistributionChannel DistributionChannel 1
Division Division 1
drft_uuid drft_uuid 1
email_address companyEmailAddress 2
GLAccount GLAccount 1
HouseNumber HouseNumber 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted,IsBusPrpsCmpltdCustomer 6
IsOneTimeAccount IsOneTimeAccount 2
Language Language 1
NO_SAFTCustomerID NO_SAFTCustomerID 1
OrganizationBPName1 OrganizationBPName1 2
OrganizationBPName2 OrganizationBPName2 2
POBox POBox 1
POBoxPostalCode POBoxPostalCode 1
PostalCode PostalCode 1
processing_status processing_status 1
processor processor 1
Region Region 1
RegionName RegionName 1
RU_PartnerOrganizationINN RU_PartnerOrganizationINN 1
SalesOrganization SalesOrganization 1
StreetName StreetName 1
TaxNumber1 TaxNumber1 3
TaxNumber2 TaxNumber2 2
VATRegistration CustomerVATRegistration,VATRegistration 2
web_address companyWebAddress 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 CUSTOMER (
    ACCOUNTINGDOCUMENT,
    BELNR,
    BUKRS,
    BUZEI,
    COMPANYCODE,
    CUSTOMER,
    GJAHR,
    KOART,
    KONKO,
    LEDGERGLLINEITEM,
    SOLDTOPARTY,
    _COMPANYCODE,
    _CUSTOMER,
    _CUSTOMERTEXT,
    ADDRESSID,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNER,
    BUSINESSPARTNERID,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    BUSINESSPARTNERUUID,
    CITYNAME,
    COMPANY_NAME,
    COUNTRY,
    CUSTOMERACCOUNTGROUP,
    CUSTOMERCLASSIFICATION,
    CUSTOMERFULLNAME,
    CUSTOMERNAME,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    DELETIONINDICATOR,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DRFT_UUID,
    EMAIL_ADDRESS,
    GLACCOUNT,
    HOUSENUMBER,
    ISBUSINESSPURPOSECOMPLETED,
    ISONETIMEACCOUNT,
    LANGUAGE,
    NO_SAFTCUSTOMERID,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    POBOX,
    POBOXPOSTALCODE,
    POSTALCODE,
    PROCESSING_STATUS,
    PROCESSOR,
    REGION,
    REGIONNAME,
    RU_PARTNERORGANIZATIONINN,
    SALESORGANIZATION,
    STREETNAME,
    TAXNUMBER1,
    TAXNUMBER2,
    VATREGISTRATION,
    WEB_ADDRESS,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, BELNR, BUKRS, BUZEI, COMPANYCODE, CUSTOMER, GJAHR, KOART, KONKO, LEDGERGLLINEITEM, SOLDTOPARTY)
);

Learn More