A_CABillgDocSource

DDL: A_CABILLGDOCSOURCE Type: view_entity CONSUMPTION
25 Fields 1 Data Sources 1 Associations

Billing Document Source Item

A_CABillgDocSource is a Consumption CDS View that provides data about "Billing Document Source Item" in SAP S/4HANA. It reads from 1 data source (R_CABillgDocSourceTP) and exposes 25 fields with key fields CABillgDocument, CABillgDocSourceItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_CABillgDocSourceTP R_CABillgDocSourceTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_CABillgDocument _CABillgDocument $projection.CABillgDocument = _CABillgDocument.CABillgDocument

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Billing Document Source Item view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name CABillgDocSource_Type view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CABillgDocument CABillgDocument Billing Doc.
KEY CABillgDocSourceItem CABillgDocSourceItem
CABillgGroupingSourceItems CABillgGroupingSourceItems Source Item Grp
CABillgRecordType CABillgRecordType
CABillgIsDocumentSimulated CABillgIsDocumentSimulated Simulation Doc.
CABillgDocCreationDate CABillgDocCreationDate Billed On
CACnsmpnItmClass CACnsmpnItmClass
CABllbleItmClass CABllbleItmClass
CABllbleItmStatus CABllbleItmStatus
CABllbleItmRecordType CABllbleItmRecordType
CABllbleItmDatabaseTable CABllbleItmDatabaseTable
CABillgGroupingBillableItem CABillgGroupingBillableItem
CABillgSubprocess CABillgSubprocess
CABllbleItmType CABllbleItmType
CABllbleItmSourceTransType CABllbleItmSourceTransType
CABillgSourceTransRefType CABillgSourceTransRefType
CABillgSourceTransRef CABillgSourceTransRef
CABllbleItmPrimary CABllbleItmPrimary
CABllbleItmPrimaryType CABllbleItmPrimaryType
CABllbleItmOriginMonth CABllbleItmOriginMonth
CABllbleItmCreationMonth CABllbleItmCreationMonth
CABllbleItmAmount CABllbleItmAmount
CABllbleItmCurrency CABllbleItmCurrency
CABllbleItmNumber CABllbleItmNumber Number of Billable Items
_CABillgDocument _CABillgDocument

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_CABillgDocSource.
-- 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_CABillgDocSource AS
SELECT
  CABillgDocument,
  CABillgDocSourceItem,
  CABillgGroupingSourceItems,
  CABillgRecordType,
  CABillgIsDocumentSimulated,
  CABillgDocCreationDate,
  CACnsmpnItmClass,
  CABllbleItmClass,
  CABllbleItmStatus,
  CABllbleItmRecordType,
  CABllbleItmDatabaseTable,
  CABillgGroupingBillableItem,
  CABillgSubprocess,
  CABllbleItmType,
  CABllbleItmSourceTransType,
  CABillgSourceTransRefType,
  CABillgSourceTransRef,
  CABllbleItmPrimary,
  CABllbleItmPrimaryType,
  CABllbleItmOriginMonth,
  CABllbleItmCreationMonth,
  CABllbleItmAmount,
  CABllbleItmCurrency,
  CABllbleItmNumber
FROM R_CABillgDocSourceTP
LEFT OUTER JOIN A_CABillgDocument AS _CABillgDocument ON CABillgDocument = _CABillgDocument.CABillgDocument  -- association [1..1]
;

Learn More