I_CABillPrntBillgPlnItem

Billing Plan Items | view: ICABIPRBIPI | TRAN | Extraction: Not supported | Component: Convergent Invoicing
Tables used: DFKKBIX_BIP_I, DFKKINVDOC_X, TFK8212, TFK8212T, TFK8213, TFK8213T, TFK2608X, TFK2608XT, TSPA, TSPAT
Column Name Description
CAInvoicingDocument Number of Invoicing Document
CAInvcgReferenceObject FK Reference Object
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
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
Column Name Description Domain name
CABillgPlnItmTxt Description of Billing Plan Item BIPITEMTEXT_KK
CABillgPlnItemExtRef External Reference of Billing Plan Item BIPITEMREF_KK
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
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
CABillgPlnItmTypeText Description of Billing Plan Item Type TEXT50
CABillgPlnItmStatusText Short Text for Fixed Values DDTEXT
CABillgPlnItmCatText Description of Billing Plan Item Category TEXT50
DivisionName Division Description TEXT20
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • I_CABILLPRNTBILLGPLNITEM.MANDT == TGSB.MANDT
  • I_CABILLPRNTBILLGPLNITEM.BUSINESSAREA == TGSB.GSBER
Billing Cycle
  • Client
  • Billing Cycle
  • I_CABILLPRNTBILLGPLNITEM.MANDT == TFK2607.MANDT
  • I_CABILLPRNTBILLGPLNITEM.CABILLGCYCLE == TFK2607.CYCLE
Billing Quantity Unit of Billing Plan Item
  • Client
  • Billing Quantity Unit of Billing Plan Item
  • I_CABILLPRNTBILLGPLNITEM.MANDT == T006.MANDT
  • I_CABILLPRNTBILLGPLNITEM.CABILLGPLNITEMQUANTITYUNIT == T006.MSEHI
Service Type for Revenue Accounting
  • Client
  • Service Type for Revenue Accounting
Billing Plan Item Category I_CABILLPRNTBILLGPLNITEM.CABILLGPLNITMCAT == TFK8212.BIPITEMCAT
Reason for Adjusting a Billing Plan Item
  • Client
  • Reason for Adjusting a Billing Plan Item
  • I_CABILLPRNTBILLGPLNITEM.MANDT == TFK8205E.MANDT
  • I_CABILLPRNTBILLGPLNITEM.CABILLGPLNITMEXCPTNREASON == TFK8205E.ITEM_EXCREASON
Billing Plan Item Type
  • Client
  • Billing Plan Item Type
  • I_CABILLPRNTBILLGPLNITEM.MANDT == TFK8213.MANDT
  • I_CABILLPRNTBILLGPLNITEM.CABILLGPLNITMTYPE == TFK8213.BIPITEMTYPE
Condition Type
  • Client
  • ?
  • ?
  • Condition Type
  • I_CABILLPRNTBILLGPLNITEM.MANDT == T685.MANDT
  • I_CABILLPRNTBILLGPLNITEM.[column in domain "KAPPL"] == T685.KAPPL
  • I_CABILLPRNTBILLGPLNITEM.[column in domain "KVEWE"] == T685.KVEWE
  • I_CABILLPRNTBILLGPLNITEM.CACONDITIONTYPE == T685.KSCHL
Dependent Item Type
  • Client
  • Dependent Item Type
  • I_CABILLPRNTBILLGPLNITEM.MANDT == TFK8240.MANDT
  • I_CABILLPRNTBILLGPLNITEM.CADEPENDENTITEMTYPE == TFK8240.DITTYPE
Offsetting Category
  • Client
  • Offsetting Category
  • I_CABILLPRNTBILLGPLNITEM.MANDT == TFK2609.MANDT
  • I_CABILLPRNTBILLGPLNITEM.CAINVCGOFFSETTINGCATEGORY == TFK2609.OFFSET_CAT
Reference Object I_CABILLPRNTBILLGPLNITEM.CAINVCGREFERENCEOBJECT == TFK2608X.REFOBJNAME
Main Transaction for Line Item
  • Main Transaction for Line Item
  • Client
  • ?
  • I_CABILLPRNTBILLGPLNITEM.CAMAINTRANSACTION == TFKHVO.HVORG
  • I_CABILLPRNTBILLGPLNITEM.MANDT == TFKHVO.MANDT
  • I_CABILLPRNTBILLGPLNITEM.[column in domain "APPLK_KK"] == TFKHVO.APPLK
Subtransaction for Document Item
  • Main Transaction for Line Item
  • Client
  • ?
  • Subtransaction for Document Item
  • I_CABILLPRNTBILLGPLNITEM.CAMAINTRANSACTION == TFKTVO.HVORG
  • I_CABILLPRNTBILLGPLNITEM.MANDT == TFKTVO.MANDT
  • I_CABILLPRNTBILLGPLNITEM.[column in domain "APPLK_KK"] == TFKTVO.APPLK
  • I_CABILLPRNTBILLGPLNITEM.CASUBTRANSACTION == TFKTVO.TVORG
Company Code
  • Client
  • Company Code
  • I_CABILLPRNTBILLGPLNITEM.MANDT == T001.MANDT
  • I_CABILLPRNTBILLGPLNITEM.COMPANYCODE == T001.BUKRS
Condition Type
  • Client
  • ?
  • ?
  • Condition Type
  • I_CABILLPRNTBILLGPLNITEM.MANDT == T685.MANDT
  • I_CABILLPRNTBILLGPLNITEM.[column in domain "KAPPL"] == T685.KAPPL
  • I_CABILLPRNTBILLGPLNITEM.[column in domain "KVEWE"] == T685.KVEWE
  • I_CABILLPRNTBILLGPLNITEM.CONDITIONTYPE == T685.KSCHL
Distribution Channel
  • Client
  • Distribution Channel
  • I_CABILLPRNTBILLGPLNITEM.MANDT == TVTW.MANDT
  • I_CABILLPRNTBILLGPLNITEM.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_CABILLPRNTBILLGPLNITEM.MANDT == TSPA.MANDT
  • I_CABILLPRNTBILLGPLNITEM.DIVISION == TSPA.SPART
Sales Organization
  • Client
  • Sales Organization
  • I_CABILLPRNTBILLGPLNITEM.MANDT == TVKO.MANDT
  • I_CABILLPRNTBILLGPLNITEM.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_CABILLPRNTBILLGPLNITEM.MANDT == FAGL_SEGM.MANDT
  • I_CABILLPRNTBILLGPLNITEM.SEGMENT == FAGL_SEGM.SEGMENT
Tax on sales/purchases code
  • Client
  • ?
  • Tax on sales/purchases code
  • I_CABILLPRNTBILLGPLNITEM.MANDT == T007A.MANDT
  • I_CABILLPRNTBILLGPLNITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • I_CABILLPRNTBILLGPLNITEM.TAXCODE == T007A.MWSKZ
Currency Key
  • Client
  • Currency Key
  • I_CABILLPRNTBILLGPLNITEM.MANDT == TCURC.MANDT
  • I_CABILLPRNTBILLGPLNITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Indicator: Tax Determination Code
  • Client
  • ?
  • ?
  • Indicator: Tax Determination Code
  • I_CABILLPRNTBILLGPLNITEM.MANDT == TE011.MANDT
  • I_CABILLPRNTBILLGPLNITEM.[column in domain "ABZEITSCH"] == TE011.AB
  • I_CABILLPRNTBILLGPLNITEM.[column in domain "LAND1"] == TE011.LAND1
  • I_CABILLPRNTBILLGPLNITEM.CATAXDETERMINATIONCODE == TE011.ERMWSKZ