_CUSTOMER

70 Fields

_CUSTOMER is an SAP database table in S/4HANA. It contains 70 fields.

Fields (70)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1
KEY CompanyCode CompanyCode 1
KEY Customer CUST,Customer,CustomerFullName 13
_CustomerClassification _CustomerClassification 2
AccountingClerkEmailAddress CustomerClerkEmailAddress 1
AddressID AddressID,SDCustomerAddressID 4
AddressSearchTerm1 AddressSearchTerm1 1
AddressSearchTerm2 AddressSearchTerm2 1
AlternativePayeeIsAllowed AlternativePayeeIsAllowed,AlternativePayerIsAllowed 4
AlternativePayerAccount AlternativePayerAccount,knrza 3
AuthorizationGroup AUTHGRPCUSTOMER,AuthorizationGroup,BPPersonAuthorizationGroup,CUSTOMERAUTHORIZATIONGROUP,CustomerAuthznGrp,CustomerBasicAuthorizationGrp,CustomerCompanyAuthznGroup,CustomerFinsAuthorizationGrp 71
BillingIsBlockedForCustomer BillingIsBlockedForCustomer 4
BPCustomerName BPCustomerName,CustomerName 10
BusinessPartnerName1 BusinessPartnerName1 2
BusinessPartnerName2 BusinessPartnerName2 2
BusinessPartnerUUID BusinessPartnerUUID 1
City City 1
CityName CityName 18
CompanyName CompanyName,Customer,CustomerCompanyName 4
Country BusinessPartnerCountry,Country,CustomerCountry,ShipToPartyCountry,VATRegistrationCountry 32
CreatedByUser CreatedByUser,CustomerCreatedByUser 4
CreationDate CreationDate,CustomerCreationDate 4
customer_begru cust_owner_begru,customer_begru 5
customer_name name1_kna1 2
CustomerAccountGroup CustomerAccountGroup 54
CustomerClassification CustomerClassification 14
CustomerCorporateGroup CustomerCorporateGroup 6
CustomerFullName CustomerFullName,CustomerName,JointVenturePartnerLongText 25
CustomerName BusinessPartnerName,CustomerName,CustomerNameForFilter,JointVenturePartnerShortText 194
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
DeliveryIsBlocked DeliveryIsBlocked,DeliveryIsBlockedForCustomer 6
EmailAdress EmailAdress 1
FullName FullName 1
Industry CustomerIndustry,Industry 6
IsBusinessPurposeCompleted IsBusinessPurposeCompleted,IsBusPrpsCmpltdCustomer,ISCUSTOMERBUSPRPSCMPLTD,PURPOSECOMPLETEDCUSTOMER 30
IsOneTimeAccount CustomerIsOneTimeAccount,IsOneTimeAccount,OneTimeCustomer 6
IsSalesProspect IsSalesProspect 3
NielsenRegion NielsenRegion 5
OrderIsBlockedForCustomer OrderIsBlockedForCustomer 6
OrganizationBPName1 CUSTOMER_NAME,CustomerName,CustomerName_H,CustomerSearchText,OrganizationBPName1 32
OrganizationBPName2 CustomerAdditionalName,OrganizationBPName2 20
PaymentIsBlockedForCustomer PaymentIsBlockedForCustomer 3
PhoneNumber PhoneNumber 1
PortugueseCustomerWithVersion PortugueseCustomerWithVersion 1
PostalCode PostalCode 7
PostBox PostBox 1
PostingIsBlocked PostingIsBlocked,PostingIsBlockedForCustomer 7
Region Region 4
SortField CustomerSearchText 1
Street Street 1
StreetName StreetName 2
Supplier Supplier 2
TaxJurisdiction CustomerTaxJurisdiction 1
TaxNumber1 CustomerTaxID1,TaxNumber1 2
TaxNumber2 CustomerTaxID2,TaxNumber2 2
TaxNumber3 CustomerTaxID3 1
TaxNumber4 CustomerTaxID4 1
TaxNumber5 CustomerTaxID5,CustomerVATRegistration 3
VATRegistration AuthorizationGroup,CustomerVATRegistration,VATRegistration 7

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 (
    BUSINESSPARTNER,
    COMPANYCODE,
    CUSTOMER,
    _CUSTOMERCLASSIFICATION,
    ACCOUNTINGCLERKEMAILADDRESS,
    ADDRESSID,
    ADDRESSSEARCHTERM1,
    ADDRESSSEARCHTERM2,
    ALTERNATIVEPAYEEISALLOWED,
    ALTERNATIVEPAYERACCOUNT,
    AUTHORIZATIONGROUP,
    BILLINGISBLOCKEDFORCUSTOMER,
    BPCUSTOMERNAME,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    BUSINESSPARTNERUUID,
    CITY,
    CITYNAME,
    COMPANYNAME,
    COUNTRY,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMER_BEGRU,
    CUSTOMER_NAME,
    CUSTOMERACCOUNTGROUP,
    CUSTOMERCLASSIFICATION,
    CUSTOMERCORPORATEGROUP,
    CUSTOMERFULLNAME,
    CUSTOMERNAME,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    DELETIONINDICATOR,
    DELIVERYISBLOCKED,
    EMAILADRESS,
    FULLNAME,
    INDUSTRY,
    ISBUSINESSPURPOSECOMPLETED,
    ISONETIMEACCOUNT,
    ISSALESPROSPECT,
    NIELSENREGION,
    ORDERISBLOCKEDFORCUSTOMER,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    PAYMENTISBLOCKEDFORCUSTOMER,
    PHONENUMBER,
    PORTUGUESECUSTOMERWITHVERSION,
    POSTALCODE,
    POSTBOX,
    POSTINGISBLOCKED,
    REGION,
    SORTFIELD,
    STREET,
    STREETNAME,
    SUPPLIER,
    TAXJURISDICTION,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    VATREGISTRATION,
    PRIMARY KEY (BUSINESSPARTNER, COMPANYCODE, CUSTOMER)
);

Learn More