I_CONTRACTACCOUNTPARTNER
Contract Account Partner
I_CONTRACTACCOUNTPARTNER is a CDS View in S/4HANA. Contract Account Partner. It contains 27 fields. 40 CDS views read from this table.
CDS Views using this table (40)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_ContractAccountPartner | view_entity | from | BASIC | Vertragskonto Partner |
| C_CAInvcgOvwDisp | view | from | CONSUMPTION | Fakturierungsübersicht für Vertr.konten |
| C_ContractacCBPCFO | view | from | CONSUMPTION | Vertragskonto |
| C_ContractAccountPartner | view | from | CONSUMPTION | Contract Account Partner |
| C_ContractAccountValueHelp | view | from | CONSUMPTION | Vertragskonto |
| C_OutsrtdUtilsBillgMaLeApply | view | left_outer | CONSUMPTION | Machine Learning Apply Data for Outsorted Billing |
| C_OutsrtdUtilsBillgMaLeTrng | view | left_outer | CONSUMPTION | Machine Learning Training Data for Outsorted Billing |
| C_OutsrtdUtilsInvcgDocOvw | view | inner | CONSUMPTION | Outsorted Invoicing Document |
| C_OutsrtdUtilsInvcgDocument | view_entity | inner | CONSUMPTION | Outsorted Invoicing Document |
| C_SbsMssProcgContractAccountVH | view_entity | from | CONSUMPTION | Contract Account |
| CRMS4_IU_I_CAP | view | from | Contract Account Partner | |
| CRMS4_IU_P_CNTBPC | view | left_outer | Business partner ISU-Contracts count | |
| CRMS4_IU_P_CNTBPCA | view | left_outer | Business partner contracts accounts count | |
| CRMS4_IU_P_CONBP | view | from | ||
| CRMS4_IU_P_PODBP | view | union | Point of Delivery by Business Partner | |
| CRMS4_IU_P_PODBP | view | from | Point of Delivery by Business Partner | |
| ESH_N_CONTRACTACCOUNT | view | from | ||
| I_ContractAccountPartnerStdVH | view | from | COMPOSITE | Contract Account Partner |
| I_ContractAccountPartnerVH | view | from | COMPOSITE | Suchhilfe für Vertragskonto Partner |
| I_LockedUtilsContrToBeInvcd | view | inner | COMPOSITE | Locked Contract to Be Invoiced |
| I_OpenUtilsBillgDocAndOrd | view | inner | COMPOSITE | Open Utilities Billing Document and Order |
| I_SchedldUtilsContrNotInvcd | view | inner | COMPOSITE | Scheduled Contract Has not Been Invoiced |
| I_SpprsdUtilsBillgOrdWthDets | view | inner | COMPOSITE | Suppressed Utilities Billing Order with Details |
| I_SuppressedUtilsBillgOrd | view | inner | COMPOSITE | Suppressed Utilities Billing Order |
| I_UtilitiesContractTP | view_entity | inner | TRANSACTIONAL | Utilities Contract |
| I_UtilitiesContractVH | view | inner | COMPOSITE | Contract Value Help |
| I_UtilitiesLossAccountVH | view | from | BASIC | ISU BR Engy Loss Contract Account |
| I_UtilsBillingOrder | view | inner | COMPOSITE | Utilities Billing Order |
| I_UtilsContrToBeBlld | view | inner | COMPOSITE | Utilities Contract to Be Billed |
| I_UtilsContrToBeBlldInvcdAnlys | view | inner | COMPOSITE | Analysis of Contract to Be Billed and Invoiced |
| I_UtilsContrToBeInvcd | view | inner | COMPOSITE | Contract to Be Invoiced |
| I_UtilsInvcgDocBillingData | view | inner | COMPOSITE | Billing Data for Invoicing Document |
| P_ContrAccountEnterpriseSearch | view | from | COMPOSITE | |
| P_ContractAccountPartner | view | from | COMPOSITE | |
| P_ISU_CSML_BUSPARTNERVH_BR | view | inner | BASIC | |
| P_ISU_CSML_PRINTORIGDOCVH_BR | view | inner | BASIC | |
| P_ISU_CSML_SIMULATEDDOCVH_BR | view | inner | BASIC | |
| P_ISU_CSMLDOCIB_BR | view | inner | BASIC | |
| P_ISU_EL_HEADER_BR | view | inner | BASIC | |
| R_ContractAccountPartnerTP | view_entity | from | TRANSACTIONAL | Contract Account Partner - TP |
Fields (27)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BusinessPartner | BusinessPartner | 14 |
| KEY | ContractAccount | ContractAccount | 11 |
| _AcctDetnCode | _AcctDetnCode | 5 | |
| _AltvContrAcc | _AltvContrAcc | 6 | |
| _AltvInvoiceRecipient | _AltvInvoiceRecipient | 2 | |
| _BusinessPartner | _BusinessPartner | 10 | |
| _ContrAcc | _ContrAcc | 6 | |
| CAAuthorizationGroup | CAAuthorizationGroup | 2 | |
| CABillgCycle | CABillgCycle | 2 | |
| CABusinessPartnerForPayment | CABusinessPartnerForPayment | 1 | |
| CACompanyCodeGroup | CACompanyCodeGroup | 1 | |
| CACorrespondenceVariant | CACorrespondenceVariant | 1 | |
| CADetnCodeForAltvInvoiceForm | CADetnCodeForAltvInvoiceForm | 1 | |
| CADunningProcedure | CADunningProcedure | 1 | |
| CAInvcgCategory | CAInvcgCategory | 2 | |
| CAInvcgSchedule | CAInvcgSchedule | 1 | |
| CALastDayOfBillingPeriod | CALastDayOfBillingPeriod | 1 | |
| CAPaymentMethodForIncgPayment | CAPaymentMethodForIncgPayment | 1 | |
| CAPaymentMethodForOutgPayment | CAPaymentMethodForOutgPayment | 1 | |
| CARelationshipOfBPToContrAcct | CARelationshipOfBPToContrAcct | 1 | |
| CAStandardCompanyCode | CAStandardCompanyCode | 4 | |
| CAStartDateForBillingPeriod | CAStartDateForBillingPeriod | 1 | |
| CATargetCurrencyForInvoicing | CATargetCurrencyForInvoicing | 1 | |
| ContractAccountName | ContractAccountName | 1 | |
| Country | Country | 1 | |
| CreationDate | CreationDate | 1 | |
| PaymentCondition | PaymentCondition | 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.
-- Contract Account Partner
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CONTRACTACCOUNTPARTNER (
BUSINESSPARTNER,
CONTRACTACCOUNT,
_ACCTDETNCODE,
_ALTVCONTRACC,
_ALTVINVOICERECIPIENT,
_BUSINESSPARTNER,
_CONTRACC,
CAAUTHORIZATIONGROUP,
CABILLGCYCLE,
CABUSINESSPARTNERFORPAYMENT,
CACOMPANYCODEGROUP,
CACORRESPONDENCEVARIANT,
CADETNCODEFORALTVINVOICEFORM,
CADUNNINGPROCEDURE,
CAINVCGCATEGORY,
CAINVCGSCHEDULE,
CALASTDAYOFBILLINGPERIOD,
CAPAYMENTMETHODFORINCGPAYMENT,
CAPAYMENTMETHODFOROUTGPAYMENT,
CARELATIONSHIPOFBPTOCONTRACCT,
CASTANDARDCOMPANYCODE,
CASTARTDATEFORBILLINGPERIOD,
CATARGETCURRENCYFORINVOICING,
CONTRACTACCOUNTNAME,
COUNTRY,
CREATIONDATE,
PAYMENTCONDITION,
PRIMARY KEY (BUSINESSPARTNER, CONTRACTACCOUNT)
);
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