A_CFinRpldBillingDocumentItem

DDL: A_CFINRPLDBILLINGDOCUMENTITEM Type: view_entity CONSUMPTION
28 Fields 1 Data Sources 1 Associations

CFin Rpld Billing Document Item (API)

A_CFinRpldBillingDocumentItem is a Consumption CDS View that provides data about "CFin Rpld Billing Document Item (API)" in SAP S/4HANA. It reads from 1 data source (cfin_avci_iteme) and exposes 28 fields with key fields SourceSystemLogicalSystem, CFinReplicatedBillingDocument, CFinRpldBillingDocumentItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
cfin_avci_iteme cfin_avci_iteme from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_CFinRpldBillingDocumentItem _Extension $projection.CFinReplicatedBillingDocument = _Extension.CFinReplicatedBillingDocument and $projection.SourceSystemLogicalSystem = _Extension.SourceSystemLogicalSystem and $projection.CFinRpldBillingDocumentItem = _Extension.CFinRpldBillingDocumentItem

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label CFin Rpld Billing Document Item (API) view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.query.implementedBy ABAP:CL_FINS_CFIN_AV_EX_QRY_NO_IMPL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY SourceSystemLogicalSystem cfin_avci_iteme sourcesystemlogicalsystem Sender Log Sys.
KEY CFinReplicatedBillingDocument cfin_avci_iteme cfinreplicatedbillingdocument Central Finance Repl. Billing Document
KEY CFinRpldBillingDocumentItem cfin_avci_iteme cfinrpldbillingdocumentitem Central Finance Repl. Billing Doc. Item
Material cfin_avci_iteme material Vehicle Model
Plant cfin_avci_iteme plant Valuation Area
TransactionCurrency cfin_avci_iteme transactioncurrency Transaction Currency
NetAmount cfin_avci_iteme netamount Stated Amount
ReturnItemProcessingType cfin_avci_iteme returnitemprocessingtype Returns
BillingQuantity cfin_avci_iteme billingquantity Invoiced Qty
BillingQuantityUnit cfin_avci_iteme billingquantityunit Sales Unit
ReferenceSDDocumentCategory cfin_avci_iteme referencesddocumentcategory Prec.Doc.Categ.
BillingQuantityInBaseUnit cfin_avci_iteme billingquantityinbaseunit Bill.Qty in SKU
BaseUnit cfin_avci_iteme baseunit Unit of Measure
SalesDocument cfin_avci_iteme salesdocument SD Document
SalesDocumentItem cfin_avci_iteme salesdocumentitem Sales Document Item
ZeroVATRsn cfin_avci_iteme zerovatrsn Reason for Zero VAT
ReferenceSDDocument cfin_avci_iteme referencesddocument Reference Doc.
WBSElementExternalID cfin_avci_iteme wbselementexternalid WBS Element External ID
LastChangeDateTime cfin_avci_iteme lastchangedatetime Timestamp
BillingDocumentItemText cfin_avci_iteme billingdocumentitemtext Item Descr.
TaxCode cfin_avci_iteme taxcode Tax Code
CostCenter cfin_avci_iteme costcenter Cost Center
ProfitCenter cfin_avci_iteme profitcenter Profit Center
DepartureCountry cfin_avci_iteme departurecountry Departure Country / Region
TaxJurisdiction cfin_avci_iteme taxjurisdiction Tax Jurisdiction
CompanyCode cfin_avci_iteme companycode Receiver Company Code
TaxAmount cfin_avci_iteme taxamount Tax Amt in Rptg Crcy
_CFinRpldBillingDocument _CFinRpldBillingDocument

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 A_CFinRpldBillingDocumentItem.
-- 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 A_CFinRpldBillingDocumentItem AS
SELECT
  cfin_avci_iteme.sourcesystemlogicalsystem AS SourceSystemLogicalSystem,
  cfin_avci_iteme.cfinreplicatedbillingdocument AS CFinReplicatedBillingDocument,
  cfin_avci_iteme.cfinrpldbillingdocumentitem AS CFinRpldBillingDocumentItem,
  cfin_avci_iteme.material AS Material,
  cfin_avci_iteme.plant AS Plant,
  cfin_avci_iteme.transactioncurrency AS TransactionCurrency,
  cfin_avci_iteme.netamount AS NetAmount,
  cfin_avci_iteme.returnitemprocessingtype AS ReturnItemProcessingType,
  cfin_avci_iteme.billingquantity AS BillingQuantity,
  cfin_avci_iteme.billingquantityunit AS BillingQuantityUnit,
  cfin_avci_iteme.referencesddocumentcategory AS ReferenceSDDocumentCategory,
  cfin_avci_iteme.billingquantityinbaseunit AS BillingQuantityInBaseUnit,
  cfin_avci_iteme.baseunit AS BaseUnit,
  cfin_avci_iteme.salesdocument AS SalesDocument,
  cfin_avci_iteme.salesdocumentitem AS SalesDocumentItem,
  cfin_avci_iteme.zerovatrsn AS ZeroVATRsn,
  cfin_avci_iteme.referencesddocument AS ReferenceSDDocument,
  cfin_avci_iteme.wbselementexternalid AS WBSElementExternalID,
  cfin_avci_iteme.lastchangedatetime AS LastChangeDateTime,
  cfin_avci_iteme.billingdocumentitemtext AS BillingDocumentItemText,
  cfin_avci_iteme.taxcode AS TaxCode,
  cfin_avci_iteme.costcenter AS CostCenter,
  cfin_avci_iteme.profitcenter AS ProfitCenter,
  cfin_avci_iteme.departurecountry AS DepartureCountry,
  cfin_avci_iteme.taxjurisdiction AS TaxJurisdiction,
  cfin_avci_iteme.companycode AS CompanyCode,
  cfin_avci_iteme.taxamount AS TaxAmount
FROM cfin_avci_iteme
LEFT OUTER JOIN E_CFinRpldBillingDocumentItem AS _Extension ON CFinReplicatedBillingDocument = _Extension.CFinReplicatedBillingDocument AND SourceSystemLogicalSystem = _Extension.SourceSystemLogicalSystem AND CFinRpldBillingDocumentItem = _Extension.CFinRpldBillingDocumentItem  -- association [1..1]
;

Learn More