R_CFinRpldBillingDocumentItem

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 R_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 R_CFinRpldBillingDocumentItem AS
SELECT
  cfin_av_ci_item.av_dbkey AS CFinRpldBillingDocItemUUID,
  cfin_av_ci_item.av_parentkey AS CFinRpldBillgDocItmParUUID,
  cfin_av_ci_item.av_rootkey AS CFinRpldBillingDocumentUUID,
  cfin_av_ci_item.fins_logsys AS SourceSystemLogicalSystem,
  cast( cfin_av_ci_item.vbeln as fins_cfin_av_rpld_billing_doc preserving type ) AS CFinReplicatedBillingDocument,
  cast( cfin_av_ci_item.posnr as fins_cfin_av_rpld_bill_doc_itm preserving type ) AS CFinRpldBillingDocumentItem,
  cfin_av_ci_item.matnr AS Material,
  cfin_av_ci_item.netwr AS NetAmount,
  _CFinRpldBillingDocument.TransactionCurrency AS TransactionCurrency,
  cfin_av_ci_item.shkzg AS ReturnItemProcessingType,
  cfin_av_ci_item.fkimg AS BillingQuantity,
  cfin_av_ci_item.vrkme AS BillingQuantityUnit,
  cfin_av_ci_item.werks AS Plant,
  cfin_av_ci_item.vgtyp AS ReferenceSDDocumentCategory,
  cfin_av_ci_item.fareg AS BillingPlanRule,
  cfin_av_ci_item.fklmg AS BillingQuantityInBaseUnit,
  cfin_av_ci_item.meins AS BaseUnit,
  cfin_av_ci_item.aubel AS CFinReplicatedSalesDocument,
  cfin_av_ci_item.aupos AS CFinRpldSalesDocumentItem,
  cfin_av_ci_item.j_1arfz AS ZeroVATRsn,
  cfin_av_ci_item.vgbel AS ReferenceSDDocument,
  cast( cfin_av_ci_item.ps_psp_pnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  cfin_av_ci_item.kokrs AS ControllingArea,
  cfin_av_ci_item.kostl AS CostCenter,
  cfin_av_ci_item.prctr AS ProfitCenter,
  cfin_av_ci_item.aland AS DepartureCountry,
  cfin_av_ci_item.txjcd AS TaxJurisdiction,
  cfin_av_ci_item.arktx AS BillingDocumentItemText,
  cfin_av_ci_item.mwsk1 AS TaxCode,
  cfin_av_ci_item.txdat_from AS TaxRateValidityStartDate,
  cfin_av_ci_item.mwsbp AS TaxAmount,
  cfin_av_ci_item.kzwi1 AS Subtotal1Amount,
  cfin_av_ci_item.kzwi2 AS Subtotal2Amount,
  cfin_av_ci_item.kzwi3 AS Subtotal3Amount,
  cfin_av_ci_item.kzwi4 AS Subtotal4Amount,
  cfin_av_ci_item.kzwi5 AS Subtotal5Amount,
  cfin_av_ci_item.kzwi6 AS Subtotal6Amount
FROM cfin_av_ci_item
LEFT OUTER JOIN R_CFinRpldBillingDocument AS _CFinRpldBillingDocument ON CFinRpldBillingDocumentUUID = _CFinRpldBillingDocument.CFinRpldBillingDocumentUUID  -- association [1..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON SourceSystemLogicalSystem = _LogicalSystem.LogicalSystem  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BillingQuantityUnit ON BillingQuantityUnit = _BillingQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _ReferenceSDDocumentCategory ON ReferenceSDDocumentCategory = _ReferenceSDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_BillingPlanRule AS _BillingPlanRule ON BillingPlanRule = _BillingPlanRule.BillingPlanRule  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
;