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 1
KEY Customer Customer,SoldToParty 9
KEY gjahr gjahr 1
KEY koart koart 1
KEY konko konko 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY SoldToParty SoldToParty 1
_CompanyCode _CompanyCode 1
_Customer _Customer 1
_CustomerText _CustomerText 1
AddressID AddressID 1
AuthorizationGroup AuthorizationGroup,CustomerAuthznGrp 8
BPCustomerName BPCustomerName 1
BusinessPartner BusinessPartner 1
businessPartnerId businessPartnerId 2
BusinessPartnerName1 BusinessPartnerName1 1
BusinessPartnerName2 BusinessPartnerName2 1
BusinessPartnerUUID BusinessPartnerUUID 1
CityName CityName 1
company_name companyName 2
Country Country,CustomerCountry 3
CustomerAccountGroup CustomerAccountGroup,CustomerAccountGrp 5
CustomerClassification CustomerClassification 1
CustomerFullName CustomerFullName 1
CustomerName CustomerName 5
DataController1 BP1DataController1,DataController1 6
DataController10 BP1DataController10,DataController10 6
DataController2 BP1DataController2,DataController2 6
DataController3 BP1DataController3,DataController3 6
DataController4 BP1DataController4,DataController4 6
DataController5 BP1DataController5,DataController5 6
DataController6 BP1DataController6,DataController6 6
DataController7 BP1DataController7,DataController7 6
DataController8 BP1DataController8,DataController8 6
DataController9 BP1DataController9,DataController9 6
DataControllerSet BP1DataControllerSet,DataControllerSet 6
DeletionIndicator DeletionIndicator 1
DistributionChannel DistributionChannel 1
Division Division 1
drft_uuid drft_uuid 1
email_address companyEmailAddress 2
HouseNumber HouseNumber 1
IsBusinessPurposeCompleted CustomerIsBusPrpsCmpltd,IsBusinessPurposeCompleted,IsBusPrpsCmpltdCustomer 7
IsOneTimeAccount IsOneTimeAccount 1
Language Language 1
NO_SAFTCustomerID NO_SAFTCustomerID 1
OrganizationBPName1 OrganizationBPName1 1
OrganizationBPName2 OrganizationBPName2 1
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 2
TaxNumber2 TaxNumber2 1
VATRegistration CustomerVATRegistration 1
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,
    BPCUSTOMERNAME,
    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,
    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