What is A_CABillgPlnItem in SAP S/4HANA?

A_CABillgPlnItem is a consumption CDS view in SAP S/4HANA. Billing Plan Item It contains 62 fields.

Which tables does A_CABillgPlnItem read from?

A_CABillgPlnItem reads data from: R_CABillgPlnItemTP.

What VDM layer is A_CABillgPlnItem?

A_CABillgPlnItem is classified as a Consumption view optimized for specific business scenarios and reporting.

A_CABillgPlnItem

DDL: A_CABILLGPLNITEM Type: view_entity CONSUMPTION

62 Fields 1 Data Sources 1 OData Services

Billing Plan Item

A_CABillgPlnItem is a Consumption CDS View that provides data about "Billing Plan Item" in SAP S/4HANA. It reads from 1 data source (R_CABillgPlnItemTP) and exposes 62 fields with key fields CABillgPlnNumber, CABillgPlnItem. It is exposed through 1 OData service (API_CABILLINGPLAN).

Data Sources (1)

Source	Alias	Join Type
R_CABillgPlnItemTP	R_CABillgPlnItemTP	projection

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Billing Plan Item	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
VDM.viewType	#CONSUMPTION	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
OData.entityType.name	CABillgPlnItem_Type	view

OData Services (1)

Service	Binding	Version	Contract	Release
API_CABILLINGPLAN	API_CABILLINGPLAN	V4	C2	C1

Fields (62)

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

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 A_CABillgPlnItem.
-- 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 A_CABillgPlnItem AS
SELECT
  CABillgPlnNumber,
  CABillgPlnItem,
  CABillgPlnItmCat,
  CABillgPlnItmType,
  CABillgPlnItmTxt,
  CABillgPlnItemExtRef,
  CABillgPlnItemAmount,
  TransactionCurrency,
  CATaxIsIncluded,
  CABillgPlnItemQuantity,
  CABillgPlnItemQuantityUnit,
  _UnitOfMeasure.UnitOfMeasureISOCode AS CABillgPlnItemQtyUnitISOCode,
  CATaxDeterminationCode,
  TaxCode,
  CABillgPlnItemStartDate,
  CABillgPlnItmEndDate,
  CABillgPlnItemTermStartDate,
  CABillgPlnItemTermEndDate,
  CABillgPlnItemRecurring,
  CABillgCycle,
  CAConditionType,
  CABillgPlnItemAmountDetnType,
  CABillgPlnItemAmountDateType,
  CABillgPlnItemPriceDateType,
  CAContract,
  CAProviderContractItemNumber,
  CASubApplication,
  CAProviderContractItemUUID,
  Division,
  CompanyCode,
  BusinessArea,
  Segment,
  CAMainTransaction,
  CASubTransaction,
  CABillgPlnItemServiceType,
  CADependentItemType,
  Material,
  SalesOrganization,
  DistributionChannel,
  CAAccountDeterminationCode,
  CAInvcgOffsettingAction,
  CAInvcgOffsettingCategory,
  CAInvcgOffsettingProcedure,
  CAInvcgOffsettingReferenceKey,
  CABillgPlnItemReqDteLast,
  CABillgPlnItemReqDteNext,
  CABillgPlnItemRequestedToDte,
  CABillgPlnItemCanceled,
  CABillgPlnSubItmExist,
  CABillgPlnItemMain,
  CABillgPlnItmExcptnReason,
  CABillgPlnItemChildExist,
  CABillgPlnItemParent,
  CABillgPlnItemStatus,
  CABillgPlnItemNrOfBllbleItm,
  CAIsRevnAcctgTransfRecordRlvt,
  ConditionType,
  ConditionIsForStatistics,
  CANetDueDate,
  CABillgPlnItmIsNotToBeReqd,
  CABllbleItmCostType,
  CABllbleItmCostSubType
FROM R_CABillgPlnItemTP
;

Depth:

A_CABillgPlnItem view_entity

R_CABillgPlnItemTP view_entity