What is A_SubscrpnContrItmBillgReqItem in SAP S/4HANA?

A_SubscrpnContrItmBillgReqItem is a composite CDS view in SAP S/4HANA. Subscription Contract Item Billing request item It contains 14 fields.

Which tables does A_SubscrpnContrItmBillgReqItem read from?

A_SubscrpnContrItmBillgReqItem reads data from: I_SubscrpnContrItmBillgReqItm.

What VDM layer is A_SubscrpnContrItmBillgReqItem?

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

A_SubscrpnContrItmBillgReqItem

DDL: A_SUBSCRPNCONTRITMBILLGREQITEM Type: view_entity COMPOSITE

14 Fields 1 Data Sources 2 Associations 1 OData Services

Subscription Contract Item Billing request item

A_SubscrpnContrItmBillgReqItem is a Composite CDS View that provides data about "Subscription Contract Item Billing request item" in SAP S/4HANA. It reads from 1 data source (I_SubscrpnContrItmBillgReqItm) and exposes 14 fields with key fields SubscriptionContract, SubscriptionContractItem, BillingRequestItem. It has 2 associations to related views. It is exposed through 1 OData service (API_SUBSCRIPTIONCONTRACT).

Data Sources (1)

Source	Alias	Join Type
I_SubscrpnContrItmBillgReqItm	I_SubscrpnContrItmBillgReqItm	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	A_SbsConItmBlgReqItmPrcElm	_SbsConItmItmBlgReqItmPrcElm	`$projection.SubscriptionContract = _SbsConItmItmBlgReqItmPrcElm.SubscriptionContract and $projection.SubscriptionContractItem = _SbsConItmItmBlgReqItmPrcElm.SubscriptionContractItem and $projection.BillingRequestItem = _SbsConItmItmBlgReqItmPrcElm.BillingRequestItem`
[1..1]	A_SubscriptionContract	_SubscriptionContract	`$projection.SubscriptionContract = _SubscriptionContract.SubscriptionContract`

Annotations (12)

Name	Value	Level
EndUserText.label	Subscription Contract Item Billing request item	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.createEnabled	false	view
ObjectModel.updateEnabled	false	view
ObjectModel.deleteEnabled	false	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
Metadata.ignorePropagatedAnnotations	true	view
OData.entityType.name	SubscrpnContrItmBillingReqItem_Type	view

OData Services (1)

Service	Binding	Version	Contract	Release
API_SUBSCRIPTIONCONTRACT	API_SUBSCRIPTIONCONTRACT	V2	C2	C1

Fields (14)

Key	Field	Source Field	Description
KEY	SubscriptionContract	SubscriptionContract	Transaction ID
KEY	SubscriptionContractItem	SubscriptionContractItem	Item Number in Doc.
KEY	BillingRequestItem	BillingRequestItem
	BillgReqItemDescription	BillgReqItemDescription
	ServiceObjectType	ServiceObjectType	Object Type
	BillgReqItemBillingDateTime	BillgReqItemBillingDateTime
	BillgReqItemBillingStatus	BillgReqItemBillingStatus
	SettlementStartDateTime	SettlementStartDateTime
	SettlementEndDateTime	SettlementEndDateTime
	BillingPlanTimeZone	BillingPlanTimeZone
	TransactionCurrency	TransactionCurrency	Transaction Currency
	BillgReqItemNetAmount	BillgReqItemNetAmount
	_SbsConItmItmBlgReqItmPrcElm	_SbsConItmItmBlgReqItmPrcElm
	_SubscriptionContract	_SubscriptionContract

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_SubscrpnContrItmBillgReqItem.
-- 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_SubscrpnContrItmBillgReqItem AS
SELECT
  SubscriptionContract,
  SubscriptionContractItem,
  BillingRequestItem,
  BillgReqItemDescription,
  ServiceObjectType,
  BillgReqItemBillingDateTime,
  BillgReqItemBillingStatus,
  SettlementStartDateTime,
  SettlementEndDateTime,
  BillingPlanTimeZone,
  TransactionCurrency,
  BillgReqItemNetAmount
FROM I_SubscrpnContrItmBillgReqItm
LEFT OUTER JOIN A_SbsConItmBlgReqItmPrcElm AS _SbsConItmItmBlgReqItmPrcElm ON SubscriptionContract = _SbsConItmItmBlgReqItmPrcElm.SubscriptionContract AND SubscriptionContractItem = _SbsConItmItmBlgReqItmPrcElm.SubscriptionContractItem AND BillingRequestItem = _SbsConItmItmBlgReqItmPrcElm.BillingRequestItem  -- association [0..*]
LEFT OUTER JOIN A_SubscriptionContract AS _SubscriptionContract ON SubscriptionContract = _SubscriptionContract.SubscriptionContract  -- association [1..1]
;

Depth:

A_SubscrpnContrItmBillgReqItem view_entity

I_SubscrpnContrItmBillgReqItm view_entity