C_CABillgReqInvcgDocItem

DDL: C_CABILLGREQINVCGDOCITEM Type: view_entity CONSUMPTION Package: ODATA_O2C_CI_CREDDEBMEMO
32 Fields 1 Data Sources 1 Associations

Abrechnungsauftrag Positionen

C_CABillgReqInvcgDocItem is a Consumption CDS View that provides data about "Abrechnungsauftrag Positionen" in SAP S/4HANA. It reads from 1 data source (P_CAInvcgDocItem) and exposes 32 fields with key fields CAInvoicingDocument, CAInvcgDocItem. It has 1 association to related views. Part of development package ODATA_O2C_CI_CREDDEBMEMO.

Data Sources (1)

SourceAliasJoin Type
P_CAInvcgDocItem _CAInvcgDocItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CAInvcgReferenceObj _CAInvcgReferenceObj _CAInvcgReferenceObj.CAInvcgReferenceObject = 'INVDOC_I'

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Abrechnungsauftrag Positionen view
Metadata.allowExtensions true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CAInvoicingDocument P_CAInvcgDocItem CAInvoicingDocument Invoic. Doc.
KEY CAInvcgDocItem P_CAInvcgDocItem CAInvcgDocItem Item
CAIsDocItemSimulated P_CAInvcgDocItem CAIsDocItemSimulated Item Simulated
CAInvcgDocumentItemType P_CAInvcgDocItem CAInvcgDocumentItemType Item Type
CAContract P_CAInvcgDocItem CAContract Contract
CompanyCode P_CAInvcgDocItem CompanyCode Receiver Company Code
CAMainTransaction P_CAInvcgDocItem CAMainTransaction Main Trans.
CASubTransaction P_CAInvcgDocItem CASubTransaction Subtransaction
Quantity P_CAInvcgDocItem Quantity Value
UnitOfMeasure P_CAInvcgDocItem UnitOfMeasure Unit Protected Qty
TransactionCurrency P_CAInvcgDocItem TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency P_CAInvcgDocItem CAAmountInTransactionCurrency Amount
CABillgReqPrevDebitAmount
CABillgReqPrevCrdtAmount
CABillgReqItmAmount
CABillgReqItmAmountCurrency
CAInvcgReferenceObject
CAReferenceObjectID
CAInvcgReferenceObjectAux
CAReferenceObjectIDAux
CATaxIsIncluded P_CAInvcgDocItem CATaxIsIncluded Gross
CAInvcgTaxGroupingKey P_CAInvcgDocItem CAInvcgTaxGroupingKey Tax Grpng Key
TaxCode P_CAInvcgDocItem TaxCode Tax Code
CATaxRateInPercent P_CAInvcgDocItem CATaxRateInPercent Tax Percentage
CAInvcgDocItemEditionEnabled
CASubApplication P_CAInvcgDocItem CASubApplication Subapplication
CAInvcgDocItemTypeText
CompanyCodeName
CAMainTransactionName
CASubTransactionName
_CAInvcgDocHeader _CAInvcgDocHeader
_CompCode _CompCode

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_CABillgReqInvcgDocItem.
-- 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 C_CABillgReqInvcgDocItem AS
SELECT
  _CAInvcgDocItem.CAInvoicingDocument AS CAInvoicingDocument,
  _CAInvcgDocItem.CAInvcgDocItem AS CAInvcgDocItem,
  _CAInvcgDocItem.CAIsDocItemSimulated AS CAIsDocItemSimulated,
  _CAInvcgDocItem.CAInvcgDocumentItemType AS CAInvcgDocumentItemType,
  _CAInvcgDocItem.CAContract AS CAContract,
  _CAInvcgDocItem.CompanyCode AS CompanyCode,
  _CAInvcgDocItem.CAMainTransaction AS CAMainTransaction,
  _CAInvcgDocItem.CASubTransaction AS CASubTransaction,
  _CAInvcgDocItem.Quantity AS Quantity,
  _CAInvcgDocItem.UnitOfMeasure AS UnitOfMeasure,
  _CAInvcgDocItem.TransactionCurrency AS TransactionCurrency,
  _CAInvcgDocItem.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  cast( '0' as bixreq_total_amt_prev_deb_kk ) AS CABillgReqPrevDebitAmount,
  cast( '0' as bixreq_total_amt_prev_cre_kk ) AS CABillgReqPrevCrdtAmount,
  cast( '0' as bixreq_amount_kk ) AS CABillgReqItmAmount,
  cast( ' ' as bixreq_curr_kk ) AS CABillgReqItmAmountCurrency,
  cast('INVITM_COR' as bit_list_refobjname_kk ) AS CAInvcgReferenceObject,
  cast(' ' as bit_list_refobjvalue_kk ) AS CAReferenceObjectID,
  cast(_CAInvcgReferenceObj._CAInvcgReferenceObjText[1: Language=$session.system_language].CAInvcgReferenceObjText as bit_list_refobjname_kk_aux ) AS CAInvcgReferenceObjectAux,
  cast(' ' as bit_list_refobjvalue_kk_aux ) AS CAReferenceObjectIDAux,
  _CAInvcgDocItem.CATaxIsIncluded AS CATaxIsIncluded,
  _CAInvcgDocItem.CAInvcgTaxGroupingKey AS CAInvcgTaxGroupingKey,
  _CAInvcgDocItem.TaxCode AS TaxCode,
  _CAInvcgDocItem.CATaxRateInPercent AS CATaxRateInPercent,
  ' ' AS CAInvcgDocItemEditionEnabled,
  _CAInvcgDocItem.CASubApplication AS CASubApplication,
  _CAInvcgDocItemType._CAInvcgDocItemTypeText[1: Language=$session.system_language].CAInvcgDocItemTypeText AS CAInvcgDocItemTypeText,
  _CAInvcgDocItem._CompCode.CompanyCodeName AS CompanyCodeName,
  _CAMainTransaction._Text[1: Language=$session.system_language].CAMainTransactionName AS CAMainTransactionName,
  _CASubTransaction._Text[1: Language=$session.system_language].CASubTransactionName AS CASubTransactionName
FROM P_CAInvcgDocItem AS _CAInvcgDocItem
LEFT OUTER JOIN I_CAInvcgReferenceObj AS _CAInvcgReferenceObj ON _CAInvcgReferenceObj.CAInvcgReferenceObject = 'INVDOC_I'  -- association [0..1]
;

Learn More