I_CABillPrntBillgDocSource

DDL: I_CABILLPRNTBILLGDOCSOURCE Type: view_entity COMPOSITE
26 Fields 1 Data Sources 1 Associations

Quellpositionen des Abrechnungsbelegs

I_CABillPrntBillgDocSource is a Composite CDS View that provides data about "Quellpositionen des Abrechnungsbelegs" in SAP S/4HANA. It reads from 1 data source (I_CABillgDocSource) and exposes 26 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
[1..1] I_CABillgDocHeader _CABillgHeader $projection.CABillgDocument = _CABillgHeader.CABillgDocument

Annotations (7)

NameValueLevelField
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 Quellpositionen des Abrechnungsbelegs view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CABillgDocument I_CABillgDocSource CABillgDocument Billing Doc.
KEY CABillgDocSourceItem I_CABillgDocSource CABillgDocSourceItem Source Item
CABillgRecordType I_CABillgDocSource CABillgRecordType Record Type
CACnsmpnItmClass I_CABillgDocSource CACnsmpnItmClass
CABllbleItmClass I_CABillgDocSource CABllbleItmClass Class
CABillgSubprocess I_CABillgDocSource CABillgSubprocess Subprocess
CABllbleItmType I_CABillgDocSource CABllbleItmType Bill.Item Type
CABillgDocCreationDate I_CABillgDocSource CABillgDocCreationDate Billed On
CABillgGroupingSourceItems I_CABillgDocSource CABillgGroupingSourceItems Source Item Grp
CABillgIsDocumentSimulated I_CABillgDocSource CABillgIsDocumentSimulated Simulation Doc.
CABllbleItmStatus I_CABillgDocSource CABllbleItmStatus Status
CABllbleItmRecordType I_CABillgDocSource CABllbleItmRecordType Record Type
CABllbleItmDatabaseTable I_CABillgDocSource CABllbleItmDatabaseTable
CABillgGroupingBillableItem I_CABillgDocSource CABillgGroupingBillableItem Bill.Items Grp
CABllbleItmSourceTransType I_CABillgDocSource CABllbleItmSourceTransType
CABillgSourceTransRefType I_CABillgDocSource CABillgSourceTransRefType Reference Type
CABillgSourceTransRef I_CABillgDocSource CABillgSourceTransRef
CABllbleItmPrimary I_CABillgDocSource CABllbleItmPrimary Primary Item
CABllbleItmPrimaryType I_CABillgDocSource CABllbleItmPrimaryType Rel. Type
CABllbleItmOriginMonth I_CABillgDocSource CABllbleItmOriginMonth
CABllbleItmCreationMonth I_CABillgDocSource CABllbleItmCreationMonth
CABllbleItmAmount I_CABillgDocSource CABllbleItmAmount Amount
CABllbleItmCurrency I_CABillgDocSource CABllbleItmCurrency Currency
CABllbleItmNumber I_CABillgDocSource CABllbleItmNumber Number of Billable Items
CABillgReqDocument
_CABillgHeader _CABillgHeader

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_CABillPrntBillgDocSource.
-- 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_CABillPrntBillgDocSource AS
SELECT
  _CABillgDocSource.CABillgDocument AS CABillgDocument,
  _CABillgDocSource.CABillgDocSourceItem AS CABillgDocSourceItem,
  _CABillgDocSource.CABillgRecordType AS CABillgRecordType,
  _CABillgDocSource.CACnsmpnItmClass AS CACnsmpnItmClass,
  _CABillgDocSource.CABllbleItmClass AS CABllbleItmClass,
  _CABillgDocSource.CABillgSubprocess AS CABillgSubprocess,
  _CABillgDocSource.CABllbleItmType AS CABllbleItmType,
  _CABillgDocSource.CABillgDocCreationDate AS CABillgDocCreationDate,
  _CABillgDocSource.CABillgGroupingSourceItems AS CABillgGroupingSourceItems,
  _CABillgDocSource.CABillgIsDocumentSimulated AS CABillgIsDocumentSimulated,
  _CABillgDocSource.CABllbleItmStatus AS CABllbleItmStatus,
  _CABillgDocSource.CABllbleItmRecordType AS CABllbleItmRecordType,
  _CABillgDocSource.CABllbleItmDatabaseTable AS CABllbleItmDatabaseTable,
  _CABillgDocSource.CABillgGroupingBillableItem AS CABillgGroupingBillableItem,
  _CABillgDocSource.CABllbleItmSourceTransType AS CABllbleItmSourceTransType,
  _CABillgDocSource.CABillgSourceTransRefType AS CABillgSourceTransRefType,
  _CABillgDocSource.CABillgSourceTransRef AS CABillgSourceTransRef,
  _CABillgDocSource.CABllbleItmPrimary AS CABllbleItmPrimary,
  _CABillgDocSource.CABllbleItmPrimaryType AS CABllbleItmPrimaryType,
  _CABillgDocSource.CABllbleItmOriginMonth AS CABllbleItmOriginMonth,
  _CABillgDocSource.CABllbleItmCreationMonth AS CABllbleItmCreationMonth,
  _CABillgDocSource.CABllbleItmAmount AS CABllbleItmAmount,
  _CABillgDocSource.CABllbleItmCurrency AS CABllbleItmCurrency,
  _CABillgDocSource.CABllbleItmNumber AS CABllbleItmNumber,
  replace ( _CABillgDocSource.CABillgSourceTransRef, '0000000000', '' ) AS CABillgReqDocument
FROM I_CABillgDocSource AS _CABillgDocSource
LEFT OUTER JOIN I_CABillgDocHeader AS _CABillgHeader ON CABillgDocument = _CABillgHeader.CABillgDocument  -- association [1..1]
;

Learn More