I_CABillgPlnItemTP

Billing Plan Items | view: ICA_BIP_ITP | TRAN | Extraction: Not supported | Component: Convergent Invoicing
Tables used: DFKKBIX_BIP_H, DFKKBIX_BIP_I, T001, TKA02, T005
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
CABillgPlnItemRecurring Recurring Billing Plan Item 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
CAApplicationArea Application Area 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
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 BILLPLANITEM_KK
CABillgPlnItemNrOfBllbleItm No. of Billing Plan Item Requests
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • I_CABILLGPLNITEMTP.BUSINESSAREA == TGSB.GSBER
  • I_CABILLGPLNITEMTP.MANDT == TGSB.MANDT
Billing Cycle
  • Billing Cycle
  • Client
  • I_CABILLGPLNITEMTP.CABILLGCYCLE == TFK2607.CYCLE
  • I_CABILLGPLNITEMTP.MANDT == TFK2607.MANDT
Billing Quantity Unit of Billing Plan Item
  • Billing Quantity Unit of Billing Plan Item
  • Client
  • I_CABILLGPLNITEMTP.CABILLGPLNITEMQUANTITYUNIT == T006.MSEHI
  • I_CABILLGPLNITEMTP.MANDT == T006.MANDT
Service Type for Revenue Accounting
  • Client
  • Service Type for Revenue Accounting
Billing Plan Item Category I_CABILLGPLNITEMTP.CABILLGPLNITMCAT == TFK8212.BIPITEMCAT
Reason for Adjusting a Billing Plan Item
  • Reason for Adjusting a Billing Plan Item
  • Client
  • I_CABILLGPLNITEMTP.CABILLGPLNITMEXCPTNREASON == TFK8205E.ITEM_EXCREASON
  • I_CABILLGPLNITEMTP.MANDT == TFK8205E.MANDT
Billing Plan Item Type
  • Billing Plan Item Type
  • Client
  • I_CABILLGPLNITEMTP.CABILLGPLNITMTYPE == TFK8213.BIPITEMTYPE
  • I_CABILLGPLNITEMTP.MANDT == TFK8213.MANDT
Condition Type
  • Condition Type
  • ?
  • ?
  • Client
  • I_CABILLGPLNITEMTP.CACONDITIONTYPE == T685.KSCHL
  • I_CABILLGPLNITEMTP.[column in domain "KAPPL"] == T685.KAPPL
  • I_CABILLGPLNITEMTP.[column in domain "KVEWE"] == T685.KVEWE
  • I_CABILLGPLNITEMTP.MANDT == T685.MANDT
Dependent Item Type
  • Dependent Item Type
  • Client
  • I_CABILLGPLNITEMTP.CADEPENDENTITEMTYPE == TFK8240.DITTYPE
  • I_CABILLGPLNITEMTP.MANDT == TFK8240.MANDT
Offsetting Category
  • Offsetting Category
  • Client
  • I_CABILLGPLNITEMTP.CAINVCGOFFSETTINGCATEGORY == TFK2609.OFFSET_CAT
  • I_CABILLGPLNITEMTP.MANDT == TFK2609.MANDT
Main Transaction for Line Item
  • ?
  • Main Transaction for Line Item
  • Client
  • I_CABILLGPLNITEMTP.[column in domain "APPLK_KK"] == TFKHVO.APPLK
  • I_CABILLGPLNITEMTP.CAMAINTRANSACTION == TFKHVO.HVORG
  • I_CABILLGPLNITEMTP.MANDT == TFKHVO.MANDT
Subtransaction for Document Item
  • ?
  • Main Transaction for Line Item
  • Client
  • Subtransaction for Document Item
  • I_CABILLGPLNITEMTP.[column in domain "APPLK_KK"] == TFKTVO.APPLK
  • I_CABILLGPLNITEMTP.CAMAINTRANSACTION == TFKTVO.HVORG
  • I_CABILLGPLNITEMTP.MANDT == TFKTVO.MANDT
  • I_CABILLGPLNITEMTP.CASUBTRANSACTION == TFKTVO.TVORG
Company Code
  • Company Code
  • Client
  • I_CABILLGPLNITEMTP.COMPANYCODE == T001.BUKRS
  • I_CABILLGPLNITEMTP.MANDT == T001.MANDT
Condition Type
  • ?
  • ?
  • Condition Type
  • Client
  • I_CABILLGPLNITEMTP.[column in domain "KAPPL"] == T685.KAPPL
  • I_CABILLGPLNITEMTP.[column in domain "KVEWE"] == T685.KVEWE
  • I_CABILLGPLNITEMTP.CONDITIONTYPE == T685.KSCHL
  • I_CABILLGPLNITEMTP.MANDT == T685.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_CABILLGPLNITEMTP.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_CABILLGPLNITEMTP.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • I_CABILLGPLNITEMTP.DIVISION == TSPA.SPART
  • I_CABILLGPLNITEMTP.MANDT == TSPA.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_CABILLGPLNITEMTP.SALESORGANIZATION == TVKO.VKORG
  • I_CABILLGPLNITEMTP.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_CABILLGPLNITEMTP.SEGMENT == FAGL_SEGM.SEGMENT
  • I_CABILLGPLNITEMTP.MANDT == FAGL_SEGM.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • I_CABILLGPLNITEMTP.[column in domain "KVEWE"] == T683.KVEWE
  • I_CABILLGPLNITEMTP.[column in domain "KAPPL"] == T683.KAPPL
  • I_CABILLGPLNITEMTP.TAXCALCULATIONPROCEDURE == T683.KALSM
  • I_CABILLGPLNITEMTP.MANDT == T683.MANDT
Tax on sales/purchases code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Tax on sales/purchases code
  • Client
  • I_CABILLGPLNITEMTP.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • I_CABILLGPLNITEMTP.TAXCODE == T007A.MWSKZ
  • I_CABILLGPLNITEMTP.MANDT == T007A.MANDT
Currency Key
  • Currency Key
  • Client
  • I_CABILLGPLNITEMTP.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_CABILLGPLNITEMTP.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Indicator: Tax Determination Code
  • ?
  • ?
  • Indicator: Tax Determination Code
  • Client
  • I_CABILLGPLNITEMTP.[column in domain "ABZEITSCH"] == TE011.AB
  • I_CABILLGPLNITEMTP.[column in domain "LAND1"] == TE011.LAND1
  • I_CABILLGPLNITEMTP.CATAXDETERMINATIONCODE == TE011.ERMWSKZ
  • I_CABILLGPLNITEMTP.MANDT == TE011.MANDT