I_BUSINESSPARTNERCUSTCO

CDS View

core view for customer company code

I_BUSINESSPARTNERCUSTCO is a CDS View in S/4HANA. core view for customer company code. It contains 52 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
/SCMTMS/CV_BP_Company view from Obsolete: Use CDS View /SCMTMS/VE_BPCOM
/SCMTMS/CV_BP_Company view left_outer Obsolete: Use CDS View /SCMTMS/VE_BPCOM
/SCMTMS/VE_BPCOM view_entity from BOPF: Business Partner Company Data
/SCMTMS/VE_BPCOM view_entity left_outer BOPF: Business Partner Company Data
I_BusinessPartnerCustCoTP view from TRANSACTIONAL BO view for customer companycode
I_CustomerCompanyCodeTP view_entity from TRANSACTIONAL Customer Company Code - TP

Fields (52)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner,BusinessPartnerForEdit,partner 3
KEY CompanyCode company_code,CompanyCode,CompanyCodeForEdit 3
AccountByCustomer AccountByCustomer,eikto_cust 3
AccountingClerk AccountingClerk 1
AccountingClerkFaxNumber AccountingClerkFaxNumber 1
AccountingClerkInternetAddress AccountingClerkInternetAddress 1
AccountingClerkPhoneNumber AccountingClerkPhoneNumber 1
AcctsReceivablePledgingCode AcctsReceivablePledgingCode 1
AlternativePayerAccount AlternativePayerAccount 1
APARToleranceGroup APARToleranceGroup 1
AuthorizationGroup AuthorizationGroup 2
BillExchChargePaymentTerms BillExchChargePaymentTerms 1
BusinessPartnerUUID BusinessPartnerUUID 1
BuyingGroupAccountNumber BuyingGroupAccountNumber 1
CashPlanningGroup CashPlanningGroup 1
CheckPaidDurationInDays CheckPaidDurationInDays 1
CollectiveInvoiceVariant CollectiveInvoiceVariant 1
CompanyCodeName CompanyCodeName 1
Country Country 1
CreditMemoPaymentTerms CreditMemoPaymentTerms 1
Customer Customer 1
CustomerAccountNote CustomerAccountNote 1
CustomerHeadOffice CustomerHeadOffice 1
CustomerPaymentBlockingReason CustomerPaymentBlockingReason 1
CustomerSupplierClearingIsUsed CustomerSupplierClearingIsUsed 1
CustPreviousMasterRecordNumber CustPreviousMasterRecordNumber 1
DeletionIsBlocked DeletionIsBlocked 1
ExtendedWhldgTaxIsActive ExtendedWhldgTaxIsActive 1
HouseBank HouseBank 1
InterestCalculationCode InterestCalculationCode 1
InterestCalculationDate InterestCalculationDate 1
IntrstCalcFrequencyInMonths IntrstCalcFrequencyInMonths 1
IsToBeLocallyProcessed IsToBeLocallyProcessed 1
ItemIsToBePaidSeparately ItemIsToBePaidSeparately 1
KnownOrNegotiatedLeave KnownOrNegotiatedLeave 1
LastInterestCalcRunDate LastInterestCalcRunDate 1
LayoutSortingRule LayoutSortingRule 1
LockboxInternalID LockboxInternalID 1
PaymentBlockingReason PaymentBlockingReason 1
PaymentClearingGroup PaymentClearingGroup 1
PaymentMethodsList PaymentMethodsList 1
PaymentMethodSupplement PaymentMethodSupplement 1
PaymentReason PaymentReason 1
PaymentTerms PaymentTerms,zterm_cust 3
PaytAdviceIsSentbyEDI PaytAdviceIsSentbyEDI 1
PersonnelNumber PersonnelNumber 1
PhysicalInventoryBlockInd PhysicalInventoryBlockInd,sperr_cust 3
ReconciliationAccount ReconciliationAccount 1
RecordPaymentHistoryIndicator RecordPaymentHistoryIndicator 1
SupplierReleaseGroup SupplierReleaseGroup 1
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.

-- core view for customer company code
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPARTNERCUSTCO (
    BUSINESSPARTNER,
    COMPANYCODE,
    ACCOUNTBYCUSTOMER,
    ACCOUNTINGCLERK,
    ACCOUNTINGCLERKFAXNUMBER,
    ACCOUNTINGCLERKINTERNETADDRESS,
    ACCOUNTINGCLERKPHONENUMBER,
    ACCTSRECEIVABLEPLEDGINGCODE,
    ALTERNATIVEPAYERACCOUNT,
    APARTOLERANCEGROUP,
    AUTHORIZATIONGROUP,
    BILLEXCHCHARGEPAYMENTTERMS,
    BUSINESSPARTNERUUID,
    BUYINGGROUPACCOUNTNUMBER,
    CASHPLANNINGGROUP,
    CHECKPAIDDURATIONINDAYS,
    COLLECTIVEINVOICEVARIANT,
    COMPANYCODENAME,
    COUNTRY,
    CREDITMEMOPAYMENTTERMS,
    CUSTOMER,
    CUSTOMERACCOUNTNOTE,
    CUSTOMERHEADOFFICE,
    CUSTOMERPAYMENTBLOCKINGREASON,
    CUSTOMERSUPPLIERCLEARINGISUSED,
    CUSTPREVIOUSMASTERRECORDNUMBER,
    DELETIONISBLOCKED,
    EXTENDEDWHLDGTAXISACTIVE,
    HOUSEBANK,
    INTERESTCALCULATIONCODE,
    INTERESTCALCULATIONDATE,
    INTRSTCALCFREQUENCYINMONTHS,
    ISTOBELOCALLYPROCESSED,
    ITEMISTOBEPAIDSEPARATELY,
    KNOWNORNEGOTIATEDLEAVE,
    LASTINTERESTCALCRUNDATE,
    LAYOUTSORTINGRULE,
    LOCKBOXINTERNALID,
    PAYMENTBLOCKINGREASON,
    PAYMENTCLEARINGGROUP,
    PAYMENTMETHODSLIST,
    PAYMENTMETHODSUPPLEMENT,
    PAYMENTREASON,
    PAYMENTTERMS,
    PAYTADVICEISSENTBYEDI,
    PERSONNELNUMBER,
    PHYSICALINVENTORYBLOCKIND,
    RECONCILIATIONACCOUNT,
    RECORDPAYMENTHISTORYINDICATOR,
    SUPPLIERRELEASEGROUP,
    USERATCUSTOMER,
    VALUEADJUSTMENTKEY,
    PRIMARY KEY (BUSINESSPARTNER, COMPANYCODE)
);