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, BUT021_FS, TB008S, TB008U, TFK000, TFK000P

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities (1)
📅 Dates (8)
☰ Categorical (15)
Other (39)
🔗 Relations (25)

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	`C_CABILLGPLNITEM.CABILLGPLNITEMSERVICETYPE == TFK_RA_SERVTYP.SERVICE_TYPE` `C_CABILLGPLNITEM.MANDT == TFK_RA_SERVTYP.MANDT`
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	`C_CABILLGPLNITEM.MANDT == FAGL_SEGM.MANDT` `C_CABILLGPLNITEM.SEGMENT == FAGL_SEGM.SEGMENT`
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`