_CUSTOMERCOMPANY

33 Fields

_CUSTOMERCOMPANY is an SAP database table in S/4HANA. It contains 33 fields.

Fields (33)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode,CustomerCompanyCode 12
_CompanyCode _CompanyCode 1
_Customer _Customer 1
AccountByCustomer AccountByCustomer 1
AccountingClerk AccountingClerk 5
AccountingClerkInternetAddress AccountingClerkInternetAddress 2
AccountingClerkPhoneNumber AccountingClerkPhoneNumber 1
AlternativePayerAccount AlternativePayerAccount,knrzb 2
APARToleranceGroup APARToleranceGroup 1
AuthorizationGroup AuthorizationGroup,CoCodeSpcfcAuthorizationGroup,CustomerCompanyAuthznGroup,CustomerFinsAuthorizationGrp 32
CashPlanningGroup CashPlanningGroup 1
CreditMemoPaymentTerms CreditMemoPaymentTerms 1
Customer CustomerNum 1
CustomerAccountNote CustomerAccountNote 3
CustomerHeadOffice CustomerHeadOffice 1
CustomerSupplierClearingIsUsed CustomerSupplierClearingIsUsed 1
CustPreviousMasterRecordNumber CustPreviousMasterRecordNumber 1
DunningNoticeGroup DunningNoticeGroup 1
HouseBank HouseBank 1
InterestCalculationCode InterestCalculationCode 2
InterestCalculationDate InterestCalculationDate 2
IntrstCalcFrequencyInMonths IntrstCalcFrequencyInMonths 2
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
ItemIsToBePaidSeparately ItemIsToBePaidSeparately 1
LastInterestCalcRunDate LastInterestCalcRunDate 1
PaymentBlockingReason CustomerPaymentBlockingReason,PaymentBlockingReason 2
PaymentMethodsList PaymentMethodsList 1
PaymentTerms PaymentTerms 1
PaytAdviceIsSentbyEDI PaytAdviceIsSentbyEDI 1
PhysicalInventoryBlockInd PhysicalInventoryBlockInd 1
ReconciliationAccount ReconciliationAccount 7
UserAtCustomer UserAtCustomer 1
ValueAdjustmentKey ValueAdjustmentKey 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 _CUSTOMERCOMPANY (
    COMPANYCODE,
    _COMPANYCODE,
    _CUSTOMER,
    ACCOUNTBYCUSTOMER,
    ACCOUNTINGCLERK,
    ACCOUNTINGCLERKINTERNETADDRESS,
    ACCOUNTINGCLERKPHONENUMBER,
    ALTERNATIVEPAYERACCOUNT,
    APARTOLERANCEGROUP,
    AUTHORIZATIONGROUP,
    CASHPLANNINGGROUP,
    CREDITMEMOPAYMENTTERMS,
    CUSTOMER,
    CUSTOMERACCOUNTNOTE,
    CUSTOMERHEADOFFICE,
    CUSTOMERSUPPLIERCLEARINGISUSED,
    CUSTPREVIOUSMASTERRECORDNUMBER,
    DUNNINGNOTICEGROUP,
    HOUSEBANK,
    INTERESTCALCULATIONCODE,
    INTERESTCALCULATIONDATE,
    INTRSTCALCFREQUENCYINMONTHS,
    ISBUSINESSPURPOSECOMPLETED,
    ITEMISTOBEPAIDSEPARATELY,
    LASTINTERESTCALCRUNDATE,
    PAYMENTBLOCKINGREASON,
    PAYMENTMETHODSLIST,
    PAYMENTTERMS,
    PAYTADVICEISSENTBYEDI,
    PHYSICALINVENTORYBLOCKIND,
    RECONCILIATIONACCOUNT,
    USERATCUSTOMER,
    VALUEADJUSTMENTKEY,
    PRIMARY KEY (COMPANYCODE)
);

Learn More