What is I_CABillPrntBillgDocItem in SAP S/4HANA?

I_CABillPrntBillgDocItem is a composite CDS view in SAP S/4HANA. Abrechnungsbelegpositionen It contains 72 fields.

Which tables does I_CABillPrntBillgDocItem read from?

I_CABillPrntBillgDocItem reads data from: I_CABillgDocItem.

What VDM layer is I_CABillPrntBillgDocItem?

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

I_CABillPrntBillgDocItem

DDL: I_CABILLPRNTBILLGDOCITEM Type: view_entity COMPOSITE

72 Fields 1 Data Sources 3 Associations

Abrechnungsbelegpositionen

I_CABillPrntBillgDocItem is a Composite CDS View that provides data about "Abrechnungsbelegpositionen" in SAP S/4HANA. It reads from 1 data source (I_CABillgDocItem) and exposes 72 fields with key fields CABillgDocument, CABillgDocItem. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_CABillgDocItem	_CABillgDocItem	from

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_CABillPrntBillgDocHeader	_CABillPrntBillgDocHeader	`$projection.CABillgDocument = _CABillPrntBillgDocHeader.CABillgDocument`
[0..1]	I_CABillPrntBillgDocItem	_CABillPrntBillgDocItem	`$projection.CABillgDocument = _CABillPrntBillgDocItem.CABillgDocument and $projection.CABillgDocItem = _CABillPrntBillgDocItem.CABillgDocItem`
[0..1]	E_CABillgDocItem	_Extension	`$projection.CABillgDocument = _Extension.CABillgDocument and $projection.CABillgDocItem = _Extension.CABillgDocItem`

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	Abrechnungsbelegpositionen	view

Fields (72)

Key	Field	Source Table	Source Field	Description
KEY	CABillgDocument	I_CABillgDocItem	CABillgDocument	Billing Doc.
KEY	CABillgDocItem	I_CABillgDocItem	CABillgDocItem	Item
	CAIsDocItemSimulated	I_CABillgDocItem	CAIsDocItemSimulated	Item Simulated
	CABillgDocumentItemType	I_CABillgDocItem	CABillgDocumentItemType	Item Type
	CAContract	I_CABillgDocItem	CAContract	Contract
	CompanyCode	I_CABillgDocItem	CompanyCode	Receiver Company Code
	CAMainTransaction	I_CABillgDocItem	CAMainTransaction	Main Trans.
	CASubTransaction	I_CABillgDocItem	CASubTransaction	Subtransaction
	CAInvcgIsItemPostingRelevant	I_CABillgDocItem	CAInvcgIsItemPostingRelevant	Posting-Relevt
	CAInvcgIsItemPrintingRelevant	I_CABillgDocItem	CAInvcgIsItemPrintingRelevant	Print Relevant
	CABillgDocItemAmount	I_CABillgDocItem	CABillgDocItemAmount	Amount
	CABillgCurrency	I_CABillgDocItem	CABillgCurrency	Currency
	CATaxIsIncluded	I_CABillgDocItem	CATaxIsIncluded	Gross
	TaxCode	I_CABillgDocItem	TaxCode	Tax Code
	UnitOfMeasure	I_CABillgDocItem	UnitOfMeasure	Unit Protected Qty
	CABillgDocItemExternalNumber	I_CABillgDocItem	CABillgDocItemExternalNumber	External Item
	CAInvcgDocItemIsReversal	I_CABillgDocItem	CABillgDocItemIsReversal	Reversal Item
	CAInvcgCorrectionCategory	I_CABillgDocItem	CAInvcgCorrectionCategory	Invcg Correction Category
	CAInvcgIsNotBPRelevant	I_CABillgDocItem	CAInvcgIsNotBPRelevant	No BP Item
	CAInvcgSubstituteGroupPrinting	I_CABillgDocItem	CAInvcgSubstituteGroupPrinting	Substitute Group
	CAItemPeriodStartDate	I_CABillgDocItem	CAItemPeriodStartDate	Start Item Per.
	CAItemPeriodEndDate	I_CABillgDocItem	CAItemPeriodEndDate	End of Item Per
	CANetDueDate	I_CABillgDocItem	CANetDueDate	Net Due Date
	Division	I_CABillgDocItem	Division	Internal Division ID
	BusinessArea	I_CABillgDocItem	BusinessArea	Business Area
	BusinessPlace	I_CABillgDocItem	BusinessPlace	Business place
	Segment	I_CABillgDocItem	Segment	Segment number
	ProfitCenter	I_CABillgDocItem	ProfitCenter	Profit Center
	CAAccountDeterminationCode	I_CABillgDocItem	CAAccountDeterminationCode	Acct Determ. ID
	CATaxDetnType	I_CABillgDocItem	CATaxDetnType	Tax Calculation
	CATaxCountry	I_CABillgDocItem	CATaxCountry	Country/Region
	CATaxDateType	I_CABillgDocItem	CATaxDateType	Tax Date
	CABillgTaxGroup	I_CABillgDocItem	CABillgTaxGroup	Tax Grouping
	CAExternalTaxDate	I_CABillgDocItem	CAExternalTaxDate	Ext. Tax Date
	CATaxDeterminationCode	I_CABillgDocItem	CATaxDeterminationCode	Tax Determination
	CAAltvTaxDeterminationCode	I_CABillgDocItem	CAAltvTaxDeterminationCode	Altv Tax Detn Code
	CAAltvTaxCode	I_CABillgDocItem	CAAltvTaxCode	Altern.Tax Code
	CAOtherTaxCode	I_CABillgDocItem	CAOtherTaxCode	TxCde:Oth.Taxes
	TaxJurisdiction	I_CABillgDocItem	TaxJurisdiction	Tax Jurisdiction
	WithholdingTaxCode	I_CABillgDocItem	WithholdingTaxCode	WTax Code
	CAIsDownPaymentRequest	I_CABillgDocItem	CAIsDownPaymentRequest	Down Payment
	CABillgDeferredRevenueCategory	I_CABillgDocItem	CABillgDeferredRevenueCategory	Deferred Revenue Category
	CABillgDeferredRevenueDate	I_CABillgDocItem	CABillgDeferredRevenueDate	Transfer date
	CAInvcgDfrrdRevenueStatus	I_CABillgDocItem	CAInvcgDfrrdRevenueStatus	Deferred Revenues Status
	CAIsRevenueAccountingRelevant	I_CABillgDocItem	CAIsRevenueAccountingRelevant	Rev. Acctg Relevant
	CARevenueAccountingServiceType	I_CABillgDocItem	CARevenueAccountingServiceType	Service Type
	CABillgDocItemIsBIRelevant	I_CABillgDocItem	CABillgDocItemIsBIRelevant	BI-Relevant
	CABillgDocItemIsFICORelevant	I_CABillgDocItem	CABillgDocItemIsFICORelevant	FI/CO-Relevant
	CAProviderContractItemNumber	I_CABillgDocItem	CAProviderContractItemNumber	Contract Item
	CASubApplication	I_CABillgDocItem	CASubApplication	Subapplication
	CAIsPrepaid	I_CABillgDocItem	CAIsPrepaid	Prepaid
	CABillgIsPrepaidBalanceChg	I_CABillgDocItem	CABillgIsPrepaidBalanceChg	Prepaid Refill
	CABillgPartnerSettlementCat	I_CABillgDocItem	CABillgPartnerSettlementCat	Partner Settlement Category
	CABillgDocItemCrtnMethod	I_CABillgDocItem	CABillgDocItemCrtnMethod	Creation Method
	CABillgFunction	I_CABillgDocItem	CABillgFunction	Billing Funct.
	CABillgGrpgOfAdditionalItems	I_CABillgDocItem	CABillgGrpgOfAdditionalItems	Additional Item Grouping
	CABillgGrpgOfPaymentData	I_CABillgDocItem	CABillgGrpgOfPaymentData	Pmt Data Group
	CABillgGroupingSourceItems	I_CABillgDocItem	CABillgGroupingSourceItems	Source Item Grp
	CADiscBaseItmGroup	I_CABillgDocItem	CADiscBaseItmGroup	Base Item Group
	CAReasonSecurityDeposit	I_CABillgDocItem	CAReasonSecurityDeposit	Request Reason
	CABillgReqReason	I_CABillgDocItem	CABillgReqReason	Billing Request Reason
	CABllbleItmDiscountKey	I_CABillgDocItem	CABllbleItmDiscountKey	Disc./Chg. Key
	CABllbleItmDiscountVersion	I_CABillgDocItem	CABllbleItmDiscountVersion	Version No.
	CABillgQuantityBeforeDecPoint	I_CABillgDocItem	CABillgQuantityBeforeDecPoint	Qty (Pred. Pcs)
	CABillgQuantityAfterDecPoint	I_CABillgDocItem	CABillgQuantityAfterDecPoint	Qty (Dec.Plcs)
	CABillingQuantity	I_CABillgDocItem	CABillingQuantity	Billing Quantity
	CADependentItemType	I_CABillgDocItem	CADependentItemType	Dependent Item Type
	ConditionType	I_CABillgDocItem	ConditionType	Condition type
	CAInvcgAccrualPostingType	I_CABillgDocItem	CAInvcgAccrualPostingType	Accr/Defrl Postg Type
	CAAltvMDOriginalIsEnbld	I_CABillgDocItem	CAAltvMDOriginalIsEnbld	OriglMasterData
	_CABillPrntBillgDocHeader		_CABillPrntBillgDocHeader
	_CABillPrntBillgDocItem		_CABillPrntBillgDocItem

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_CABillPrntBillgDocItem.
-- 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.

CREATE VIEW I_CABillPrntBillgDocItem AS
SELECT
  _CABillgDocItem.CABillgDocument AS CABillgDocument,
  _CABillgDocItem.CABillgDocItem AS CABillgDocItem,
  _CABillgDocItem.CAIsDocItemSimulated AS CAIsDocItemSimulated,
  _CABillgDocItem.CABillgDocumentItemType AS CABillgDocumentItemType,
  _CABillgDocItem.CAContract AS CAContract,
  _CABillgDocItem.CompanyCode AS CompanyCode,
  _CABillgDocItem.CAMainTransaction AS CAMainTransaction,
  _CABillgDocItem.CASubTransaction AS CASubTransaction,
  _CABillgDocItem.CAInvcgIsItemPostingRelevant AS CAInvcgIsItemPostingRelevant,
  _CABillgDocItem.CAInvcgIsItemPrintingRelevant AS CAInvcgIsItemPrintingRelevant,
  _CABillgDocItem.CABillgDocItemAmount AS CABillgDocItemAmount,
  _CABillgDocItem.CABillgCurrency AS CABillgCurrency,
  _CABillgDocItem.CATaxIsIncluded AS CATaxIsIncluded,
  _CABillgDocItem.TaxCode AS TaxCode,
  _CABillgDocItem.UnitOfMeasure AS UnitOfMeasure,
  _CABillgDocItem.CABillgDocItemExternalNumber AS CABillgDocItemExternalNumber,
  _CABillgDocItem.CABillgDocItemIsReversal AS CAInvcgDocItemIsReversal,
  _CABillgDocItem.CAInvcgCorrectionCategory AS CAInvcgCorrectionCategory,
  _CABillgDocItem.CAInvcgIsNotBPRelevant AS CAInvcgIsNotBPRelevant,
  _CABillgDocItem.CAInvcgSubstituteGroupPrinting AS CAInvcgSubstituteGroupPrinting,
  _CABillgDocItem.CAItemPeriodStartDate AS CAItemPeriodStartDate,
  _CABillgDocItem.CAItemPeriodEndDate AS CAItemPeriodEndDate,
  _CABillgDocItem.CANetDueDate AS CANetDueDate,
  _CABillgDocItem.Division AS Division,
  _CABillgDocItem.BusinessArea AS BusinessArea,
  _CABillgDocItem.BusinessPlace AS BusinessPlace,
  _CABillgDocItem.Segment AS Segment,
  _CABillgDocItem.ProfitCenter AS ProfitCenter,
  _CABillgDocItem.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  _CABillgDocItem.CATaxDetnType AS CATaxDetnType,
  _CABillgDocItem.CATaxCountry AS CATaxCountry,
  _CABillgDocItem.CATaxDateType AS CATaxDateType,
  _CABillgDocItem.CABillgTaxGroup AS CABillgTaxGroup,
  _CABillgDocItem.CAExternalTaxDate AS CAExternalTaxDate,
  _CABillgDocItem.CATaxDeterminationCode AS CATaxDeterminationCode,
  _CABillgDocItem.CAAltvTaxDeterminationCode AS CAAltvTaxDeterminationCode,
  _CABillgDocItem.CAAltvTaxCode AS CAAltvTaxCode,
  _CABillgDocItem.CAOtherTaxCode AS CAOtherTaxCode,
  _CABillgDocItem.TaxJurisdiction AS TaxJurisdiction,
  _CABillgDocItem.WithholdingTaxCode AS WithholdingTaxCode,
  _CABillgDocItem.CAIsDownPaymentRequest AS CAIsDownPaymentRequest,
  _CABillgDocItem.CABillgDeferredRevenueCategory AS CABillgDeferredRevenueCategory,
  _CABillgDocItem.CABillgDeferredRevenueDate AS CABillgDeferredRevenueDate,
  _CABillgDocItem.CAInvcgDfrrdRevenueStatus AS CAInvcgDfrrdRevenueStatus,
  _CABillgDocItem.CAIsRevenueAccountingRelevant AS CAIsRevenueAccountingRelevant,
  _CABillgDocItem.CARevenueAccountingServiceType AS CARevenueAccountingServiceType,
  _CABillgDocItem.CABillgDocItemIsBIRelevant AS CABillgDocItemIsBIRelevant,
  _CABillgDocItem.CABillgDocItemIsFICORelevant AS CABillgDocItemIsFICORelevant,
  _CABillgDocItem.CAProviderContractItemNumber AS CAProviderContractItemNumber,
  _CABillgDocItem.CASubApplication AS CASubApplication,
  _CABillgDocItem.CAIsPrepaid AS CAIsPrepaid,
  _CABillgDocItem.CABillgIsPrepaidBalanceChg AS CABillgIsPrepaidBalanceChg,
  _CABillgDocItem.CABillgPartnerSettlementCat AS CABillgPartnerSettlementCat,
  _CABillgDocItem.CABillgDocItemCrtnMethod AS CABillgDocItemCrtnMethod,
  _CABillgDocItem.CABillgFunction AS CABillgFunction,
  _CABillgDocItem.CABillgGrpgOfAdditionalItems AS CABillgGrpgOfAdditionalItems,
  _CABillgDocItem.CABillgGrpgOfPaymentData AS CABillgGrpgOfPaymentData,
  _CABillgDocItem.CABillgGroupingSourceItems AS CABillgGroupingSourceItems,
  _CABillgDocItem.CADiscBaseItmGroup AS CADiscBaseItmGroup,
  _CABillgDocItem.CAReasonSecurityDeposit AS CAReasonSecurityDeposit,
  _CABillgDocItem.CABillgReqReason AS CABillgReqReason,
  _CABillgDocItem.CABllbleItmDiscountKey AS CABllbleItmDiscountKey,
  _CABillgDocItem.CABllbleItmDiscountVersion AS CABllbleItmDiscountVersion,
  _CABillgDocItem.CABillgQuantityBeforeDecPoint AS CABillgQuantityBeforeDecPoint,
  _CABillgDocItem.CABillgQuantityAfterDecPoint AS CABillgQuantityAfterDecPoint,
  _CABillgDocItem.CABillingQuantity AS CABillingQuantity,
  _CABillgDocItem.CADependentItemType AS CADependentItemType,
  _CABillgDocItem.ConditionType AS ConditionType,
  _CABillgDocItem.CAInvcgAccrualPostingType AS CAInvcgAccrualPostingType,
  _CABillgDocItem.CAAltvMDOriginalIsEnbld AS CAAltvMDOriginalIsEnbld
FROM I_CABillgDocItem AS _CABillgDocItem
LEFT OUTER JOIN I_CABillPrntBillgDocHeader AS _CABillPrntBillgDocHeader ON CABillgDocument = _CABillPrntBillgDocHeader.CABillgDocument  -- association [0..1]
LEFT OUTER JOIN I_CABillPrntBillgDocItem AS _CABillPrntBillgDocItem ON CABillgDocument = _CABillPrntBillgDocItem.CABillgDocument AND CABillgDocItem = _CABillPrntBillgDocItem.CABillgDocItem  -- association [0..1]
LEFT OUTER JOIN E_CABillgDocItem AS _Extension ON CABillgDocument = _Extension.CABillgDocument AND CABillgDocItem = _Extension.CABillgDocItem  -- association [0..1]
;

Depth:

I_CABillPrntBillgDocItem view_entity

I_CABillgDocItem view_entity