C_CABillgDocSource

DDL: C_CABILLGDOCSOURCE SQL: CCAINVBILL_S Type: view CONSUMPTION
45 Fields 1 Data Sources 1 Associations

Quellpositionen des Abrechnungsbelegs

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

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCAINVBILL_S view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Quellpositionen des Abrechnungsbelegs view
UI.headerInfo.typeName Quellposition view
UI.headerInfo.typeNamePlural Quellpositionen view
UI.presentationVariant.sortOrder.by CABillgDocSourceItem view
UI.presentationVariant.sortOrder.direction #ASC view

Fields (45)

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
CACnsmpnItmClassText
CABllbleItmClassText
CABllbleItmTypeText
CABllbleItmSrceTransTypeText
CABillgSubprocessText
CABillgRecordTypeText
CABllbleItmStatusText
CABllbleItmRecordTypeText
CABillgSourceTransRefTypText
CABllbleItmPrimaryTypeText
_CABillgHeader _CABillgHeader
_CACnsmpnItmClass _CACnsmpnItmClass
_CABllbleItmClass _CABllbleItmClass
_CABllbleItmType _CABllbleItmType
_CABllbleItmSrceTransType _CABllbleItmSrceTransType
_CABillgSubprocess _CABillgSubprocess
_CABillgRecordType _CABillgRecordType
_CABllbleItmStatus _CABllbleItmStatus
_CABllbleItmRecordType _CABllbleItmRecordType
_CABillgSourceTransRefTyp _CABillgSourceTransRefTyp
_CABllbleItmPrimaryType _CABllbleItmPrimaryType

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 C_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.
-- SQL view name: CCAINVBILL_S

CREATE VIEW C_CABillgDocSource 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,
  _CACnsmpnItmClass._CACnsmpnItmClassText[1: Language=$session.system_language].CACnsmpnItmClassText AS CACnsmpnItmClassText,
  _CABllbleItmClass._CABllbleItmClassText[1: Language=$session.system_language].CABllbleItmClassText AS CABllbleItmClassText,
  _CABllbleItmType._CABllbleItmTypeText[1: Language=$session.system_language].CABllbleItmTypeText AS CABllbleItmTypeText,
  _CABllbleItmSrceTransType._CABllbleItmSrceTransTypeText[1: Language=$session.system_language].CABllbleItmSrceTransTypeText AS CABllbleItmSrceTransTypeText,
  _CABillgSubprocess._CABillgSubprocessText[1: Language=$session.system_language].CABillgSubprocessText AS CABillgSubprocessText,
  _CABillgRecordType._CABillgRecordTypeText[1: Language=$session.system_language].CABillgRecordTypeText AS CABillgRecordTypeText,
  _CABllbleItmStatus._CABllbleItmStatusText[1: Language=$session.system_language].CABllbleItmStatusText AS CABllbleItmStatusText,
  _CABllbleItmRecordType._CABllbleItmRecordTypeText[1: Language=$session.system_language].CABllbleItmRecordTypeText AS CABllbleItmRecordTypeText,
  _CABillgSourceTransRefTyp._CABillgSourceTransRefTypText[1: Language=$session.system_language].CABillgSourceTransRefTypText AS CABillgSourceTransRefTypText,
  _CABllbleItmPrimaryType._CABllbleItmPrimaryTypeText[1: Language=$session.system_language].CABllbleItmPrimaryTypeText AS CABllbleItmPrimaryTypeText
FROM I_CABillgDocSource AS _CABillgDocSource
LEFT OUTER JOIN C_CABillgDocHeader AS _CABillgHeader ON CABillgDocument = _CABillgHeader.CABillgDocument  -- association [1..1]
;

Learn More