I_CABillgDocAdditional

DDL: I_CABILLGDOCADDITIONAL Type: view_entity BASIC Package: FKKINV_VDM_BILL
8 Fields 1 Data Sources 1 Associations

Zusatzpositionen des Abrechnungsbelegs

I_CABillgDocAdditional is a Basic CDS View that provides data about "Zusatzpositionen des Abrechnungsbelegs" in SAP S/4HANA. It reads from 1 data source (dfkkinvbill_a) and exposes 8 fields with key fields CABillgDocument, CABillgDocAdditionalItem. It has 1 association to related views. Part of development package FKKINV_VDM_BILL.

Data Sources (1)

SourceAliasJoin Type
dfkkinvbill_a invbill_a from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CABillgDocHeader _CABillgDocHeader $projection.CABillgDocument = _CABillgDocHeader.CABillgDocument

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Zusatzpositionen des Abrechnungsbelegs view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CABillgDocument billdocno Billing Doc.
KEY CABillgDocAdditionalItem billdocadditem Additional Item
CABillgGrpgOfAdditionalItems Add. Item Grpg
CABillgDocAdditionalItemType additemtype Add.Item Type
CABillgDocAdditionalItemID additemid Add.Item ID
CABillgDocAddlItemExtSyst Ext. Add. Item
CAInvcgDocItemIsReversal reversalitem Reversal Item
_CABillgDocHeader _CABillgDocHeader

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_CABillgDocAdditional.
-- 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_CABillgDocAdditional AS
SELECT
  billdocno AS CABillgDocument,
  billdocadditem AS CABillgDocAdditionalItem,
  cast(add_group as add_group_gfn_kk preserving type) AS CABillgGrpgOfAdditionalItems,
  additemtype AS CABillgDocAdditionalItemType,
  additemid AS CABillgDocAdditionalItemID,
  cast(refadditem as refadditem_gfn_kk preserving type) AS CABillgDocAddlItemExtSyst,
  reversalitem AS CAInvcgDocItemIsReversal
FROM dfkkinvbill_a AS invbill_a
LEFT OUTER JOIN I_CABillgDocHeader AS _CABillgDocHeader ON CABillgDocument = _CABillgDocHeader.CABillgDocument  -- association [1..1]
;

Learn More