I_BUSINESSPARTNERCUSTCO
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA