What is I_CABillPrntBillgPlnItem in SAP S/4HANA?

I_CABillPrntBillgPlnItem is a composite CDS view in SAP S/4HANA. Abrechnungsplanpositionen It contains 76 fields.

Which tables does I_CABillPrntBillgPlnItem read from?

I_CABillPrntBillgPlnItem reads data from: I_CABillgPlnItem, I_CAInvcgDocRelation.

What VDM layer is I_CABillPrntBillgPlnItem?

I_CABillPrntBillgPlnItem is classified as a Composite view that combines data from multiple basic views.

I_CABillPrntBillgPlnItem

DDL: I_CABILLPRNTBILLGPLNITEM Type: view_entity COMPOSITE

76 Fields 2 Data Sources 1 Associations

Abrechnungsplanpositionen

I_CABillPrntBillgPlnItem is a Composite CDS View that provides data about "Abrechnungsplanpositionen" in SAP S/4HANA. It reads from 2 data sources (I_CABillgPlnItem, I_CAInvcgDocRelation) and exposes 76 fields with key fields CAInvoicingDocument, CAInvcgReferenceObject, CABillgPlnNumber, CABillgPlnItem. It has 1 association to related views.

Data Sources (2)

Source	Alias	Join Type
I_CABillgPlnItem	_CABillgPlnItem	right_outer
I_CAInvcgDocRelation	_CAInvcgDocRelation	from

Parameters (1)

Name	Type	Default
P_Language	langu

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_CABillPrntBillgPlnHeader	_CABillPrntBillgPlnHeader	`$projection.CABillgPlnNumber = _CABillPrntBillgPlnHeader.CABillgPlnNumber`

Annotations (7)

Name	Value	Level
VDM.viewType	#COMPOSITE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
AccessControl.personalData.blocking	#REQUIRED	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Abrechnungsplanpositionen	view

Fields (76)

Key	Field	Source Table	Source Field	Description
KEY	CAInvoicingDocument	I_CAInvcgDocRelation	CAInvoicingDocument	Invoic. Doc.
KEY	CAInvcgReferenceObject	I_CAInvcgDocRelation	CAInvcgReferenceObject	Reference Obj.
KEY	CABillgPlnNumber	I_CABillgPlnItem	CABillgPlnNumber	Billing Plan
KEY	CABillgPlnItem	I_CABillgPlnItem	CABillgPlnItem	Item
	CABillgPlnItemStatus	I_CABillgPlnItem	CABillgPlnItemStatus	Status
	CABillgPlnItmCat	I_CABillgPlnItem	CABillgPlnItmCat	Billing Pln Itm Cat.
	CABillgPlnItmType	I_CABillgPlnItem	CABillgPlnItmType	Billing Plan Itm Typ
	CABillgPlnItmTxt	I_CABillgPlnItem	CABillgPlnItmTxt	Name
	CABillgPlnItemExtRef	I_CABillgPlnItem	CABillgPlnItemExtRef	Ext. Reference
	CABillgPlnItemStartDate	I_CABillgPlnItem	CABillgPlnItemStartDate	Valid From
	CABillgPlnItmEndDate	I_CABillgPlnItem	CABillgPlnItmEndDate	Valid to
	CABillgPlnItemTermStartDate	I_CABillgPlnItem	CABillgPlnItemTermStartDate	Term From
	CABillgPlnItemTermEndDate	I_CABillgPlnItem	CABillgPlnItemTermEndDate	Term To
	CABillgPlnItemRecurring	I_CABillgPlnItem	CABillgPlnItemRecurring	RecurringBillgPlnItm
	CABillgCycle	I_CABillgPlnItem	CABillgCycle	Billing Cycle
	CABillgPlnItemAmount	I_CABillgPlnItem	CABillgPlnItemAmount	Amount
	TransactionCurrency	I_CABillgPlnItem	TransactionCurrency	Transaction Currency
	CATaxIsIncluded	I_CABillgPlnItem	CATaxIsIncluded	Gross
	CABillgPlnItemQuantity	I_CABillgPlnItem	CABillgPlnItemQuantity	Billing Quantity
	CABillgPlnItemQuantityUnit	I_CABillgPlnItem	CABillgPlnItemQuantityUnit	Unit of Measure
	CATaxDeterminationCode	I_CABillgPlnItem	CATaxDeterminationCode	Tax Determination
	TaxCode	I_CABillgPlnItem	TaxCode	Tax Code
	CABillgPlnItemReqDteLast	I_CABillgPlnItem	CABillgPlnItemReqDteLast	Last Request
	CABillgPlnItemReqDteNext	I_CABillgPlnItem	CABillgPlnItemReqDteNext	Next Request
	CABillgPlnDvtgNextRequestDate	I_CABillgPlnItem	CABillgPlnDvtgNextRequestDate	Diff. ReqDate
	CABillgPlnItemRequestedToDte	I_CABillgPlnItem	CABillgPlnItemRequestedToDte	Requested Until
	CABillgPlnItmExcptnReason	I_CABillgPlnItem	CABillgPlnItmExcptnReason	Adjust. Reason
	CAConditionType	I_CABillgPlnItem	CAConditionType	Condition Type
	CABillgPlnItemAmountDetnType	I_CABillgPlnItem	CABillgPlnItemAmountDetnType	Type of Amount Detn
	CABillgPlnItemAmountDateType	I_CABillgPlnItem	CABillgPlnItemAmountDateType	Type of Amount Detn Date
	CABillgPlnItemPriceDateType	I_CABillgPlnItem	CABillgPlnItemPriceDateType	Type Pricing Date
	CAContract	I_CABillgPlnItem	CAContract	Contract
	CASubApplication	I_CABillgPlnItem	CASubApplication	Subapplication
	CAProviderContractItemNumber	I_CABillgPlnItem	CAProviderContractItemNumber	Contract Item
	CAProviderContractItemUUID	I_CABillgPlnItem	CAProviderContractItemUUID	Contr.Item ID
	CABillgPlnSubItmExist	I_CABillgPlnItem	CABillgPlnSubItmExist	Subitm Exists
	Division	I_CABillgPlnItem	Division	Internal Division ID
	CompanyCode	I_CABillgPlnItem	CompanyCode	Receiver Company Code
	BusinessArea	I_CABillgPlnItem	BusinessArea	Business Area
	Segment	I_CABillgPlnItem	Segment	Segment number
	CAMainTransaction	I_CABillgPlnItem	CAMainTransaction	Main Trans.
	CASubTransaction	I_CABillgPlnItem	CASubTransaction	Subtransaction
	Material	I_CABillgPlnItem	Material	Vehicle Model
	SalesOrganization	I_CABillgPlnItem	SalesOrganization	Sales Organization
	DistributionChannel	I_CABillgPlnItem	DistributionChannel	RefDistCh-Cust/Mat.
	CABillgPlnItemServiceType	I_CABillgPlnItem	CABillgPlnItemServiceType	Service Type
	CADependentItemType	I_CABillgPlnItem	CADependentItemType	Dependent Item Type
	CAAccountDeterminationCode	I_CABillgPlnItem	CAAccountDeterminationCode	Acct Determ. ID
	CABillgPlnItemCanceled	I_CABillgPlnItem	CABillgPlnItemCanceled	Item Discarded
	CABillgPlnItemMain	I_CABillgPlnItem	CABillgPlnItemMain	Main Item
	CABillgPlnItemChildExist	I_CABillgPlnItem	CABillgPlnItemChildExist	Follow-On Itm Exists
	CABillgPlnItemParent	I_CABillgPlnItem	CABillgPlnItemParent	HigherLevelItem
	CABillgPlnItemNrOfBllbleItm	I_CABillgPlnItem	CABillgPlnItemNrOfBllbleItm	No. of Requests
	CAInvcgOffsettingAction	I_CABillgPlnItem	CAInvcgOffsettingAction	Action Offsett.
	CAInvcgOffsettingCategory	I_CABillgPlnItem	CAInvcgOffsettingCategory	Offsetting Cat.
	CAInvcgOffsettingProcedure	I_CABillgPlnItem	CAInvcgOffsettingProcedure	Offsett. Proc.
	CAInvcgOffsettingReferenceKey	I_CABillgPlnItem	CAInvcgOffsettingReferenceKey	Offsetting Ref.
	ConditionType	I_CABillgPlnItem	ConditionType	Condition type
	ConditionIsForStatistics	I_CABillgPlnItem	ConditionIsForStatistics	Statistical
	CANetDueDate	I_CABillgPlnItem	CANetDueDate	Net Due Date
	CAIsRevnAcctgTransfRecordRlvt	I_CABillgPlnItem	CAIsRevnAcctgTransfRecordRlvt	OrderItm Exists
	CABillgPlnItmTypeText
	CABillgPlnItmStatusText
	CABillgPlnItmCatText
	DivisionName
	CAInvcgOffsettingActionText
	CAInvcgOffsettingCategoryTxt
	CAInvcgOffsettingProcedText
	_CABillPrntBillgPlnHeader		_CABillPrntBillgPlnHeader
	_CABillgPln	I_CABillgPlnItem	_CABillgPln
	_CABillgPlnItmStatus	I_CABillgPlnItem	_CABillgPlnItmStatus
	_CABillgPlnItmCat	I_CABillgPlnItem	_CABillgPlnItmCat
	_CABillgPlnItmType	I_CABillgPlnItem	_CABillgPlnItmType
	_CAInvcgOffsettingAction	I_CABillgPlnItem	_CAInvcgOffsettingAction
	_CAInvcgOffsettingCategory	I_CABillgPlnItem	_CAInvcgOffsettingCategory
	_CAInvcgOffsettingProcedure	I_CABillgPlnItem	_CAInvcgOffsettingProcedure

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CABillPrntBillgPlnItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_Language : langu

CREATE VIEW I_CABillPrntBillgPlnItem AS
SELECT
  _CAInvcgDocRelation.CAInvoicingDocument AS CAInvoicingDocument,
  _CAInvcgDocRelation.CAInvcgReferenceObject AS CAInvcgReferenceObject,
  _CABillgPlnItem.CABillgPlnNumber AS CABillgPlnNumber,
  _CABillgPlnItem.CABillgPlnItem AS CABillgPlnItem,
  _CABillgPlnItem.CABillgPlnItemStatus AS CABillgPlnItemStatus,
  _CABillgPlnItem.CABillgPlnItmCat AS CABillgPlnItmCat,
  _CABillgPlnItem.CABillgPlnItmType AS CABillgPlnItmType,
  _CABillgPlnItem.CABillgPlnItmTxt AS CABillgPlnItmTxt,
  _CABillgPlnItem.CABillgPlnItemExtRef AS CABillgPlnItemExtRef,
  _CABillgPlnItem.CABillgPlnItemStartDate AS CABillgPlnItemStartDate,
  _CABillgPlnItem.CABillgPlnItmEndDate AS CABillgPlnItmEndDate,
  _CABillgPlnItem.CABillgPlnItemTermStartDate AS CABillgPlnItemTermStartDate,
  _CABillgPlnItem.CABillgPlnItemTermEndDate AS CABillgPlnItemTermEndDate,
  _CABillgPlnItem.CABillgPlnItemRecurring AS CABillgPlnItemRecurring,
  _CABillgPlnItem.CABillgCycle AS CABillgCycle,
  _CABillgPlnItem.CABillgPlnItemAmount AS CABillgPlnItemAmount,
  _CABillgPlnItem.TransactionCurrency AS TransactionCurrency,
  _CABillgPlnItem.CATaxIsIncluded AS CATaxIsIncluded,
  _CABillgPlnItem.CABillgPlnItemQuantity AS CABillgPlnItemQuantity,
  _CABillgPlnItem.CABillgPlnItemQuantityUnit AS CABillgPlnItemQuantityUnit,
  _CABillgPlnItem.CATaxDeterminationCode AS CATaxDeterminationCode,
  _CABillgPlnItem.TaxCode AS TaxCode,
  _CABillgPlnItem.CABillgPlnItemReqDteLast AS CABillgPlnItemReqDteLast,
  _CABillgPlnItem.CABillgPlnItemReqDteNext AS CABillgPlnItemReqDteNext,
  _CABillgPlnItem.CABillgPlnDvtgNextRequestDate AS CABillgPlnDvtgNextRequestDate,
  _CABillgPlnItem.CABillgPlnItemRequestedToDte AS CABillgPlnItemRequestedToDte,
  _CABillgPlnItem.CABillgPlnItmExcptnReason AS CABillgPlnItmExcptnReason,
  _CABillgPlnItem.CAConditionType AS CAConditionType,
  _CABillgPlnItem.CABillgPlnItemAmountDetnType AS CABillgPlnItemAmountDetnType,
  _CABillgPlnItem.CABillgPlnItemAmountDateType AS CABillgPlnItemAmountDateType,
  _CABillgPlnItem.CABillgPlnItemPriceDateType AS CABillgPlnItemPriceDateType,
  _CABillgPlnItem.CAContract AS CAContract,
  _CABillgPlnItem.CASubApplication AS CASubApplication,
  _CABillgPlnItem.CAProviderContractItemNumber AS CAProviderContractItemNumber,
  _CABillgPlnItem.CAProviderContractItemUUID AS CAProviderContractItemUUID,
  _CABillgPlnItem.CABillgPlnSubItmExist AS CABillgPlnSubItmExist,
  _CABillgPlnItem.Division AS Division,
  _CABillgPlnItem.CompanyCode AS CompanyCode,
  _CABillgPlnItem.BusinessArea AS BusinessArea,
  _CABillgPlnItem.Segment AS Segment,
  _CABillgPlnItem.CAMainTransaction AS CAMainTransaction,
  _CABillgPlnItem.CASubTransaction AS CASubTransaction,
  _CABillgPlnItem.Material AS Material,
  _CABillgPlnItem.SalesOrganization AS SalesOrganization,
  _CABillgPlnItem.DistributionChannel AS DistributionChannel,
  _CABillgPlnItem.CABillgPlnItemServiceType AS CABillgPlnItemServiceType,
  _CABillgPlnItem.CADependentItemType AS CADependentItemType,
  _CABillgPlnItem.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  _CABillgPlnItem.CABillgPlnItemCanceled AS CABillgPlnItemCanceled,
  _CABillgPlnItem.CABillgPlnItemMain AS CABillgPlnItemMain,
  _CABillgPlnItem.CABillgPlnItemChildExist AS CABillgPlnItemChildExist,
  _CABillgPlnItem.CABillgPlnItemParent AS CABillgPlnItemParent,
  _CABillgPlnItem.CABillgPlnItemNrOfBllbleItm AS CABillgPlnItemNrOfBllbleItm,
  _CABillgPlnItem.CAInvcgOffsettingAction AS CAInvcgOffsettingAction,
  _CABillgPlnItem.CAInvcgOffsettingCategory AS CAInvcgOffsettingCategory,
  _CABillgPlnItem.CAInvcgOffsettingProcedure AS CAInvcgOffsettingProcedure,
  _CABillgPlnItem.CAInvcgOffsettingReferenceKey AS CAInvcgOffsettingReferenceKey,
  _CABillgPlnItem.ConditionType AS ConditionType,
  _CABillgPlnItem.ConditionIsForStatistics AS ConditionIsForStatistics,
  _CABillgPlnItem.CANetDueDate AS CANetDueDate,
  _CABillgPlnItem.CAIsRevnAcctgTransfRecordRlvt AS CAIsRevnAcctgTransfRecordRlvt,
  _CABillgPlnItem._CABillgPlnItmType._Text[1: Language=$parameters.P_Language].CABillgPlnItmTypeText AS CABillgPlnItmTypeText,
  _CABillgPlnItem._CABillgPlnItmStatus._Text[1: Language=$parameters.P_Language].CABillgPlnItmStatusText AS CABillgPlnItmStatusText,
  _CABillgPlnItem._CABillgPlnItmCat._Text[1: Language=$parameters.P_Language].CABillgPlnItmCatText AS CABillgPlnItmCatText,
  _CABillgPlnItem._Division._Text[1: Language=$parameters.P_Language].DivisionName AS DivisionName,
  _CABillgPlnItem._CAInvcgOffsettingAction._Text[1: Language=$parameters.P_Language].CAInvcgOffsettingActionText AS CAInvcgOffsettingActionText,
  _CABillgPlnItem._CAInvcgOffsettingCategory._Text[1: Language=$parameters.P_Language].CAInvcgOffsettingCategoryTxt AS CAInvcgOffsettingCategoryTxt,
  _CABillgPlnItem._CAInvcgOffsettingProcedure._Text[1: Language=$parameters.P_Language].CAInvcgOffsettingProcedText AS CAInvcgOffsettingProcedText,
  _CABillgPlnItem._CABillgPln AS _CABillgPln,
  _CABillgPlnItem._CABillgPlnItmStatus AS _CABillgPlnItmStatus,
  _CABillgPlnItem._CABillgPlnItmCat AS _CABillgPlnItmCat,
  _CABillgPlnItem._CABillgPlnItmType AS _CABillgPlnItmType,
  _CABillgPlnItem._CAInvcgOffsettingAction AS _CAInvcgOffsettingAction,
  _CABillgPlnItem._CAInvcgOffsettingCategory AS _CAInvcgOffsettingCategory,
  _CABillgPlnItem._CAInvcgOffsettingProcedure AS _CAInvcgOffsettingProcedure
FROM I_CAInvcgDocRelation AS _CAInvcgDocRelation
RIGHT OUTER JOIN I_CABillgPlnItem AS _CABillgPlnItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CABillPrntBillgPlnHeader AS _CABillPrntBillgPlnHeader ON CABillgPlnNumber = _CABillPrntBillgPlnHeader.CABillgPlnNumber  -- association [1..1]
;

Depth:

I_CABillPrntBillgPlnItem view_entity

I_CAInvcgDocRelation view_entity
I_CABillgPlnItem view_entity