_CUSTOMER

75 Fields

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

Fields (75)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1
KEY CompanyCode CompanyCode 1
KEY Customer BusinessPartner,CUST,Customer,CustomerFullName 19
_CustomerClassification _CustomerClassification 2
AccountingClerkEmailAddress CustomerClerkEmailAddress 1
AddressID AddressID,SDCustomerAddressID 6
AddressSearchTerm1 AddressSearchTerm1 1
AddressSearchTerm2 AddressSearchTerm2 1
AlternativePayeeIsAllowed AlternativePayeeIsAllowed,AlternativePayerIsAllowed 5
AlternativePayerAccount AlternativePayerAccount,knrza 4
AuthorizationGroup AUTHGRPCUSTOMER,AuthorizationGroup,CUSTOMERAUTHORIZATIONGROUP,CustomerAuthznGrp,CustomerBasicAuthorizationGrp,CustomerCompanyAuthznGroup,CustomerFinsAuthorizationGrp 76
BillingIsBlockedForCustomer BillingIsBlockedForCustomer 4
BPCustomerFullName BPCustomerFullName,CustomerFullName,CustomerName,JointVenturePartnerLongText 11
BPCustomerName BPCustomerName,CustomerName,JointVenturePartner2ShortText,JointVenturePartnerShortText 38
BusinessPartnerName1 BusinessPartnerName1,JointVenturePartnerName,OrganizationBPName1 4
BusinessPartnerName2 BusinessPartnerName2,OrganizationBPName2 3
BusinessPartnerNumber BusinessPartnerNumber 1
City City 1
CityName CityName 20
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear 1
CompanyName CompanyName,Customer,CustomerCompanyName 4
Country BusinessPartnerCountry,Country,CustomerCountry,ShipToPartyCountry,VATRegistrationCountry 33
CreatedByUser CreatedByUser,CustomerCreatedByUser 4
CreationDate CreationDate,CustomerCreationDate 4
customer_begru cust_owner_begru,customer_begru 5
customer_name name1_kna1 2
CustomerAccountGroup CustomerAccountGroup 57
CustomerClassification CustomerClassification 14
CustomerCorporateGroup CustomerCorporateGroup 6
CustomerFullName CustomerFullName,CustomerName 23
CustomerName BusinessPartnerName,CustomerName,CustomerNameForFilter,JointVenturePartnerShortText,SoldToPartyName 178
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 4
DeletionIndicator DeletionIndicator 1
DeliveryIsBlocked DeliveryIsBlocked,DeliveryIsBlockedForCustomer 6
EmailAdress EmailAdress 1
FullName FullName 1
Industry CustomerIndustry,Industry 6
InvoiceItemReference InvoiceItemReference 1
InvoiceReference InvoiceReference 1
IsBusinessPurposeCompleted CustomerIsBusPrpsCmpltd,IsBusinessPurposeCompleted,IsBusPrpsCmpltdCustomer,ISCUSTOMERBUSPRPSCMPLTD,PURPOSECOMPLETEDCUSTOMER 31
IsOneTimeAccount CustomerIsOneTimeAccount,IsOneTimeAccount,OneTimeCustomer 8
IsSalesProspect IsSalesProspect 3
NielsenRegion NielsenRegion 5
OrderIsBlockedForCustomer OrderIsBlockedForCustomer 6
OrganizationBPName1 BusinessPartnerOrgLongName,CUSTOMER_NAME,CustomerName,CustomerName_H,CustomerSearchText,OrganizationBPName1 35
OrganizationBPName2 CustomerAdditionalName,OrganizationBPName2 20
PaymentIsBlockedForCustomer PaymentIsBlockedForCustomer 3
PhoneNumber PhoneNumber 1
PortugueseCustomerWithVersion PortugueseCustomerWithVersion 1
PostalCode PostalCode 8
PostBox PostBox 1
PostingIsBlocked PostingIsBlocked,PostingIsBlockedForCustomer 8
Region CustomerRegion,Region 5
SortField CustomerSearchText 1
Street Street 1
StreetName StreetName 3
Supplier Supplier 3
TaxJurisdiction CustomerTaxJurisdiction 1
TaxNumber1 CustomerTaxID1,TaxNumber1 2
TaxNumber2 CustomerTaxID2,TaxNumber2 2
TaxNumber3 CustomerTaxID3 1
TaxNumber4 CustomerTaxID4 1
TaxNumber5 CustomerTaxID5,CustomerVATRegistration 3
TradingPartner TradingPartner 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,
    BPCUSTOMERFULLNAME,
    BPCUSTOMERNAME,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    BUSINESSPARTNERNUMBER,
    CITY,
    CITYNAME,
    CLEARINGJOURNALENTRYFISCALYEAR,
    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,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    ISBUSINESSPURPOSECOMPLETED,
    ISONETIMEACCOUNT,
    ISSALESPROSPECT,
    NIELSENREGION,
    ORDERISBLOCKEDFORCUSTOMER,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    PAYMENTISBLOCKEDFORCUSTOMER,
    PHONENUMBER,
    PORTUGUESECUSTOMERWITHVERSION,
    POSTALCODE,
    POSTBOX,
    POSTINGISBLOCKED,
    REGION,
    SORTFIELD,
    STREET,
    STREETNAME,
    SUPPLIER,
    TAXJURISDICTION,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TRADINGPARTNER,
    VATREGISTRATION,
    PRIMARY KEY (BUSINESSPARTNER, COMPANYCODE, CUSTOMER)
);

Learn More