R_CABillgDocSourceTP

DDL: R_CABILLGDOCSOURCETP Type: view_entity TRANSACTIONAL
35 Fields 1 Data Sources 1 Associations

Billing Document Source Item - TP

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

Data Sources (1)

SourceAliasJoin Type
I_CABillgDocSource _CABillgDocSource from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_CABillgDocumentTP _CABillgDocument $projection.CABillgDocument = _CABillgDocument.CABillgDocument

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Billing Document Source Item - TP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey CABillgDocSourceItem view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY CABillgDocument CABillgDocument Billing Doc.
KEY CABillgDocSourceItem CABillgDocSourceItem Source Item
CABillgGroupingSourceItems CABillgGroupingSourceItems Source Item Grp
CABillgRecordType CABillgRecordType Record Type
CABillgIsDocumentSimulated CABillgIsDocumentSimulated Simulation Doc.
CABillgDocCreationDate CABillgDocCreationDate Billed On
CACnsmpnItmClass CACnsmpnItmClass
CABllbleItmClass CABllbleItmClass Class
CABllbleItmStatus CABllbleItmStatus Status
CABllbleItmRecordType CABllbleItmRecordType Record Type
CABllbleItmDatabaseTable CABllbleItmDatabaseTable
CABillgGroupingBillableItem CABillgGroupingBillableItem Bill.Items Grp
CABillgSubprocess CABillgSubprocess Subprocess
CABllbleItmType CABllbleItmType Bill.Item Type
CABllbleItmSourceTransType CABllbleItmSourceTransType
CABillgSourceTransRefType CABillgSourceTransRefType Reference Type
CABillgSourceTransRef CABillgSourceTransRef
CABllbleItmPrimary CABllbleItmPrimary Primary Item
CABllbleItmPrimaryType CABllbleItmPrimaryType Rel. Type
CABllbleItmOriginMonth CABllbleItmOriginMonth
CABllbleItmCreationMonth CABllbleItmCreationMonth
CABllbleItmAmount CABllbleItmAmount Amount
CABllbleItmCurrency CABllbleItmCurrency Currency
CABllbleItmNumber CABllbleItmNumber Number of Billable Items
_CACnsmpnItmClass _CACnsmpnItmClass
_CABllbleItmClass _CABllbleItmClass
_CABllbleItmType _CABllbleItmType
_CABllbleItmSrceTransType _CABllbleItmSrceTransType
_CABillgSubprocess _CABillgSubprocess
_CABillgRecordType _CABillgRecordType
_CABllbleItmStatus _CABllbleItmStatus
_CABllbleItmRecordType _CABllbleItmRecordType
_CABillgSourceTransRefType _CABillgSourceTransRefType
_CABllbleItmPrimaryType _CABllbleItmPrimaryType
_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 R_CABillgDocSourceTP.
-- 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 R_CABillgDocSourceTP 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 I_CABillgDocSource AS _CABillgDocSource
LEFT OUTER JOIN R_CABillgDocumentTP AS _CABillgDocument ON CABillgDocument = _CABillgDocument.CABillgDocument  -- association [0..1]
;

Learn More