C_CABillgPlnItem

Billing Plan Items | view: CCA_BIP_I | TRAN | Extraction: Not supported | Component: Convergent Invoicing
Tables used: DFKKBIX_BIP_H, DFKKBIX_BIP_I, ADCP, ADRC, BUT020, BUT021_FS, TGSB, TGSBT, BUT000, TFK2607, TFK2607T, TFK8210, TFK8210T, TFK8205E, TFK8205ET, TFK8212, TFK8212T, TFK8213, TFK8213T, TFK8211, TFK8211T, TFK8240, TFK8240T, TFK2609, TFK2609T, TFKHVO, TFKHVOT, TFK_RA_SERVTYP, TFK_RA_SERVTYP_T, TFKTVO, TFKTVOT, T001, TKA02, T685, T685T, FKKVK, T005, T005T, TCURC, TCURX, TCURT, TVTW, TVTWT, TSPA, TSPAT, MARA, MAKT, TVKO, TVKOT, T006, T006A, TB008S, TB008U, TFK000, TFK000P
Column Name Description
CABillgPlnNumber FK Billing Plan Number
CABillgPlnItem Sequence Number of Billing Plan Item
Column Name Description
💲 Currency Key (TransactionCurrency):
CABillgPlnItemAmount Amount in Transaction Currency with +/- Sign
Column Name Description
📏 Billing Quantity Unit of Billing Plan Item (CABillgPlnItemQuantityUnit):
CABillgPlnItemQuantity Billing Quantity of Billing Plan Item
Column Name Description
CABillgPlnItemStartDate Valid From
CABillgPlnItmEndDate Valid to
CABillgPlnItemTermStartDate Term From
CABillgPlnItemTermEndDate Term To
CAStartDateForBillingPeriod Start Date of First Billing Period
CABillgPlnItemReqDteLast Last Reqest Date for Billing Plan Items
CABillgPlnItemReqDteNext Next Request Date of Billing Plan Items
CABillgPlnItemRequestedToDte Billing Plan Items Requested Until
Column Name Description
CABillgPlnItemStatus Status of Billing Plan Item Show values
CABillgPlnItemRecurring Recurring Billing Plan Item Show values
CATaxIsIncluded Tax Included in Amount Show values
CABillgPlnItemAmountDetnType Type of Amount Determination Show values
CABillgPlnItemAmountDateType Type of Amount Determination Date Show values
CABillgPlnItemPriceDateType Type of Pricing Date Show values
CASubApplication Subapplication in Contract Accounts Receivable and Payable Show values
CABillgPlnSubItmExist Subitem Exists Show values
CAApplicationArea Application Area Show values
CABillgPlnItemCanceled Billing Plan Item Discarded Show values
CABillgPlnItemChildExist Follow-On Item Exists Show values
CAInvcgOffsettingAction Action Code for Offsetting Show values
CAInvcgOffsettingProcedure Offsetting Procedure Show values
CAIsRevnAcctgTransfRecordRlvt Order Item Created for Transfer to Revenue Accounting Show values
ConditionIsForStatistics Condition Is Statistical Show values
Column Name Description Domain name
CABillgPlnTypeText Description of Billing Plan Type TEXT50
CABillgPlnItmTxt Description of Billing Plan Item BIPITEMTEXT_KK
CABillgPlnItemExtRef External Reference of Billing Plan Item BIPITEMREF_KK
CAContract Reference Specifications from Contract VTREF_KK
CAContractSemanticObject Semantic Object for Contract TEXT30
CAProviderContractItemNumber Contract: Item Number VTPOS_KK
CAProviderContractItemUUID External GUID of Provider Contract Items SYSUUID
Material Material Number CHAR40
CAAccountDeterminationCode Account Determination ID KOFIZ_KK
CABillgPlnItemMain Number of Main Item BILLPLANITEM_KK
CABillgPlnItemParent Number of Higher-Level Billing Plan Item BILLPLANITEM_KK
CABillgPlnItemNrOfBllbleItm No. of Billing Plan Item Requests
CAInvcgOffsettingReferenceKey Offsetting Reference Key CHAR20S
CABillgPlnItmStatusText Short Text for Fixed Values DDTEXT
CABillgPlnItmExcptnRsnText Description of Adjustment Reason for Billing Plan Item TEXT50_KK
CABillgCycleText Name of Billing Cycle TEXT50
CABillgPlnItmTypeText Description of Billing Plan Item Type TEXT50
CABillgPlnItmCatText Description of Billing Plan Item Category TEXT50
CurrencyName Description TEXT40
UnitOfMeasureName Unit of Measurement Text (Maximum 10 Characters) TEXT10
CAConditionTypeName Description TEXT30
CABillgPlnItmAmtDetnTypeText Short Text for Fixed Values DDTEXT
CABillgPlnItmAmtDateTypeText Description (250 Characters)
CABillgPlnItmPrcDateTypeText Description (250 Characters)
CAMainTransactionName Name of Main Transaction TEXT30
CASubTransactionName Name of Subtransaction TEXT30
CARevnAcctgServiceTypeText Name of Service Types for Revenue Accounting Item TEXT50_KK
CADependentItemTypeText Dependent Item Type Description DITTYPE_TXT_KK
CASubApplicationText Description (250 Characters)
DivisionName Division Description TEXT20
CompanyCodeName Name of Company Code or Company TEXT25
BusinessAreaName Business Area Description TEXT30
MaterialName Material Description TEXT40
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
CAInvcgOffsettingActionText Short Text for Fixed Values DDTEXT
CAInvcgOffsettingCategoryTxt Text for Offsetting Category TEXT60
CAInvcgOffsettingProcedText Short Text for Fixed Values DDTEXT
ConditionTypeName Description TEXT30
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • C_CABILLGPLNITEM.BUSINESSAREA == TGSB.GSBER
  • C_CABILLGPLNITEM.MANDT == TGSB.MANDT
Billing Cycle
  • Billing Cycle
  • Client
  • C_CABILLGPLNITEM.CABILLGCYCLE == TFK2607.CYCLE
  • C_CABILLGPLNITEM.MANDT == TFK2607.MANDT
Billing Plan Category C_CABILLGPLNITEM.CABILLGPLNCATEGORY == TFK8210.BIPCAT
Billing Quantity Unit of Billing Plan Item
  • Billing Quantity Unit of Billing Plan Item
  • Client
  • C_CABILLGPLNITEM.CABILLGPLNITEMQUANTITYUNIT == T006.MSEHI
  • C_CABILLGPLNITEM.MANDT == T006.MANDT
Service Type for Revenue Accounting
  • Service Type for Revenue Accounting
  • Client
Billing Plan Item Category C_CABILLGPLNITEM.CABILLGPLNITMCAT == TFK8212.BIPITEMCAT
Reason for Adjusting a Billing Plan Item
  • Client
  • Reason for Adjusting a Billing Plan Item
  • C_CABILLGPLNITEM.MANDT == TFK8205E.MANDT
  • C_CABILLGPLNITEM.CABILLGPLNITMEXCPTNREASON == TFK8205E.ITEM_EXCREASON
Billing Plan Item Type
  • Client
  • Billing Plan Item Type
  • C_CABILLGPLNITEM.MANDT == TFK8213.MANDT
  • C_CABILLGPLNITEM.CABILLGPLNITMTYPE == TFK8213.BIPITEMTYPE
Billing Plan Type
  • Billing Plan Type
  • Client
  • C_CABILLGPLNITEM.CABILLGPLNTYPE == TFK8211.BIPTYPE
  • C_CABILLGPLNITEM.MANDT == TFK8211.MANDT
Condition Type
  • ?
  • ?
  • Client
  • Condition Type
  • C_CABILLGPLNITEM.[column in domain "KAPPL"] == T685.KAPPL
  • C_CABILLGPLNITEM.[column in domain "KVEWE"] == T685.KVEWE
  • C_CABILLGPLNITEM.MANDT == T685.MANDT
  • C_CABILLGPLNITEM.CACONDITIONTYPE == T685.KSCHL
Dependent Item Type
  • Client
  • Dependent Item Type
  • C_CABILLGPLNITEM.MANDT == TFK8240.MANDT
  • C_CABILLGPLNITEM.CADEPENDENTITEMTYPE == TFK8240.DITTYPE
Offsetting Category
  • Client
  • Offsetting Category
  • C_CABILLGPLNITEM.MANDT == TFK2609.MANDT
  • C_CABILLGPLNITEM.CAINVCGOFFSETTINGCATEGORY == TFK2609.OFFSET_CAT
Main Transaction for Line Item
  • Main Transaction for Line Item
  • ?
  • Client
  • C_CABILLGPLNITEM.CAMAINTRANSACTION == TFKHVO.HVORG
  • C_CABILLGPLNITEM.[column in domain "APPLK_KK"] == TFKHVO.APPLK
  • C_CABILLGPLNITEM.MANDT == TFKHVO.MANDT
Subtransaction for Document Item
  • Main Transaction for Line Item
  • ?
  • Client
  • Subtransaction for Document Item
  • C_CABILLGPLNITEM.CAMAINTRANSACTION == TFKTVO.HVORG
  • C_CABILLGPLNITEM.[column in domain "APPLK_KK"] == TFKTVO.APPLK
  • C_CABILLGPLNITEM.MANDT == TFKTVO.MANDT
  • C_CABILLGPLNITEM.CASUBTRANSACTION == TFKTVO.TVORG
Company Code
  • Client
  • Company Code
  • C_CABILLGPLNITEM.MANDT == T001.MANDT
  • C_CABILLGPLNITEM.COMPANYCODE == T001.BUKRS
Condition Type
  • ?
  • ?
  • Client
  • Condition Type
  • C_CABILLGPLNITEM.[column in domain "KAPPL"] == T685.KAPPL
  • C_CABILLGPLNITEM.[column in domain "KVEWE"] == T685.KVEWE
  • C_CABILLGPLNITEM.MANDT == T685.MANDT
  • C_CABILLGPLNITEM.CONDITIONTYPE == T685.KSCHL
Distribution Channel
  • Client
  • Distribution Channel
  • C_CABILLGPLNITEM.MANDT == TVTW.MANDT
  • C_CABILLGPLNITEM.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_CABILLGPLNITEM.MANDT == TSPA.MANDT
  • C_CABILLGPLNITEM.DIVISION == TSPA.SPART
Sales Organization
  • Client
  • Sales Organization
  • C_CABILLGPLNITEM.MANDT == TVKO.MANDT
  • C_CABILLGPLNITEM.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • C_CABILLGPLNITEM.[column in domain "KVEWE"] == T683.KVEWE
  • C_CABILLGPLNITEM.[column in domain "KAPPL"] == T683.KAPPL
  • C_CABILLGPLNITEM.MANDT == T683.MANDT
  • C_CABILLGPLNITEM.TAXCALCULATIONPROCEDURE == T683.KALSM
Tax on sales/purchases code
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Tax on sales/purchases code
  • C_CABILLGPLNITEM.MANDT == T007A.MANDT
  • C_CABILLGPLNITEM.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • C_CABILLGPLNITEM.TAXCODE == T007A.MWSKZ
Currency Key
  • Client
  • Currency Key
  • C_CABILLGPLNITEM.MANDT == TCURC.MANDT
  • C_CABILLGPLNITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Indicator: Tax Determination Code
  • ?
  • ?
  • Client
  • Indicator: Tax Determination Code
  • C_CABILLGPLNITEM.[column in domain "ABZEITSCH"] == TE011.AB
  • C_CABILLGPLNITEM.[column in domain "LAND1"] == TE011.LAND1
  • C_CABILLGPLNITEM.MANDT == TE011.MANDT
  • C_CABILLGPLNITEM.CATAXDETERMINATIONCODE == TE011.ERMWSKZ