I_CABillgPlnItem

Billing Plan Item | view: ICA_BIP_I | TRAN | Extraction: Not supported | Component: Convergent Invoicing
Tables used: DFKKBIX_BIP_I
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
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
CAInvcgOffsettingAction Action Code for Offsetting Show values
CAInvcgOffsettingProcedure Offsetting Procedure Show values
CABillgPlnItemCanceled Billing Plan Item Discarded Show values
CABillgPlnSubItmExist Subitem Exists Show values
CABillgPlnItemChildExist Follow-On Item Exists Show values
CABillgPlnItemStatus Status of Billing Plan Item Show values
CAIsRevnAcctgTransfRecordRlvt Order Item Created for Transfer to Revenue Accounting Show values
ConditionIsForStatistics Condition Is Statistical Show values
Column Name Description Domain name
CABillgPlnItmTxt Description of Billing Plan Item BIPITEMTEXT_KK
CABillgPlnItemExtRef External Reference of Billing Plan Item BIPITEMREF_KK
CABillgPlnItemRecurring Recurring Billing Plan Item
CAContract Reference Specifications from Contract VTREF_KK
CAProviderContractItemNumber Contract: Item Number VTPOS_KK
CAProviderContractItemUUID External GUID of Provider Contract Items SYSUUID
Material Material Number CHAR40
CAAccountDeterminationCode Account Determination ID KOFIZ_KK
CAInvcgOffsettingReferenceKey Offsetting Reference Key CHAR20S
CABillgPlnItemMain Number of Main Item BILLPLANITEM_KK
CABillgPlnItemParent Number of Higher-Level Billing Plan Item
CABillgPlnItemNrOfBllbleItm No. of Billing Plan Item Requests
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • I_CABILLGPLNITEM.BUSINESSAREA == TGSB.GSBER
  • I_CABILLGPLNITEM.MANDT == TGSB.MANDT
Billing Cycle
  • Client
  • Billing Cycle
  • I_CABILLGPLNITEM.MANDT == TFK2607.MANDT
  • I_CABILLGPLNITEM.CABILLGCYCLE == TFK2607.CYCLE
Billing Quantity Unit of Billing Plan Item
  • Client
  • Billing Quantity Unit of Billing Plan Item
  • I_CABILLGPLNITEM.MANDT == T006.MANDT
  • I_CABILLGPLNITEM.CABILLGPLNITEMQUANTITYUNIT == T006.MSEHI
Service Type for Revenue Accounting
  • Client
  • Service Type for Revenue Accounting
Billing Plan Item Category I_CABILLGPLNITEM.CABILLGPLNITMCAT == TFK8212.BIPITEMCAT
Reason for Adjusting a Billing Plan Item
  • Client
  • Reason for Adjusting a Billing Plan Item
  • I_CABILLGPLNITEM.MANDT == TFK8205E.MANDT
  • I_CABILLGPLNITEM.CABILLGPLNITMEXCPTNREASON == TFK8205E.ITEM_EXCREASON
Billing Plan Item Type
  • Billing Plan Item Type
  • Client
  • I_CABILLGPLNITEM.CABILLGPLNITMTYPE == TFK8213.BIPITEMTYPE
  • I_CABILLGPLNITEM.MANDT == TFK8213.MANDT
Condition Type
  • Client
  • ?
  • ?
  • Condition Type
  • I_CABILLGPLNITEM.MANDT == T685.MANDT
  • I_CABILLGPLNITEM.[column in domain "KAPPL"] == T685.KAPPL
  • I_CABILLGPLNITEM.[column in domain "KVEWE"] == T685.KVEWE
  • I_CABILLGPLNITEM.CACONDITIONTYPE == T685.KSCHL
Dependent Item Type
  • Dependent Item Type
  • Client
  • I_CABILLGPLNITEM.CADEPENDENTITEMTYPE == TFK8240.DITTYPE
  • I_CABILLGPLNITEM.MANDT == TFK8240.MANDT
Offsetting Category
  • Client
  • Offsetting Category
  • I_CABILLGPLNITEM.MANDT == TFK2609.MANDT
  • I_CABILLGPLNITEM.CAINVCGOFFSETTINGCATEGORY == TFK2609.OFFSET_CAT
Main Transaction for Line Item
  • Client
  • Main Transaction for Line Item
  • ?
  • I_CABILLGPLNITEM.MANDT == TFKHVO.MANDT
  • I_CABILLGPLNITEM.CAMAINTRANSACTION == TFKHVO.HVORG
  • I_CABILLGPLNITEM.[column in domain "APPLK_KK"] == TFKHVO.APPLK
Subtransaction for Document Item
  • Client
  • Subtransaction for Document Item
  • Main Transaction for Line Item
  • ?
  • I_CABILLGPLNITEM.MANDT == TFKTVO.MANDT
  • I_CABILLGPLNITEM.CASUBTRANSACTION == TFKTVO.TVORG
  • I_CABILLGPLNITEM.CAMAINTRANSACTION == TFKTVO.HVORG
  • I_CABILLGPLNITEM.[column in domain "APPLK_KK"] == TFKTVO.APPLK
Company Code
  • Client
  • Company Code
  • I_CABILLGPLNITEM.MANDT == T001.MANDT
  • I_CABILLGPLNITEM.COMPANYCODE == T001.BUKRS
Condition Type
  • Client
  • Condition Type
  • ?
  • ?
  • I_CABILLGPLNITEM.MANDT == T685.MANDT
  • I_CABILLGPLNITEM.CONDITIONTYPE == T685.KSCHL
  • I_CABILLGPLNITEM.[column in domain "KAPPL"] == T685.KAPPL
  • I_CABILLGPLNITEM.[column in domain "KVEWE"] == T685.KVEWE
Distribution Channel
  • Client
  • Distribution Channel
  • I_CABILLGPLNITEM.MANDT == TVTW.MANDT
  • I_CABILLGPLNITEM.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_CABILLGPLNITEM.MANDT == TSPA.MANDT
  • I_CABILLGPLNITEM.DIVISION == TSPA.SPART
Sales Organization
  • Client
  • Sales Organization
  • I_CABILLGPLNITEM.MANDT == TVKO.MANDT
  • I_CABILLGPLNITEM.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • I_CABILLGPLNITEM.MANDT == T007A.MANDT
  • I_CABILLGPLNITEM.TAXCODE == T007A.MWSKZ
  • I_CABILLGPLNITEM.[column in domain "KALSM_D"] == T007A.KALSM
Currency Key
  • Client
  • Currency Key
  • I_CABILLGPLNITEM.MANDT == TCURC.MANDT
  • I_CABILLGPLNITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Indicator: Tax Determination Code
  • Indicator: Tax Determination Code
  • Client
  • ?
  • ?
  • I_CABILLGPLNITEM.CATAXDETERMINATIONCODE == TE011.ERMWSKZ
  • I_CABILLGPLNITEM.MANDT == TE011.MANDT
  • I_CABILLGPLNITEM.[column in domain "ABZEITSCH"] == TE011.AB
  • I_CABILLGPLNITEM.[column in domain "LAND1"] == TE011.LAND1