P_ACMTrdgContrToInvcLink

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 P_ACMTrdgContrToInvcLink.
-- 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: PCONTRINVLINKDET

CREATE VIEW P_ACMTrdgContrToInvcLink AS
SELECT
  StlUnitHead.stl_header_guid AS SettlementUnitUUID,
  StlUnitHead.tkonn AS TradingContractNumber,
  StlUnitHead.tposn AS TradingContractItem,
  StlUnitHead.appl_guid AS ContractApplicationUUID,
  StlUnitHead.appl_version AS ContractApplicationVersion,
  cast( StlUnitHead.created_on as timestamp preserving type ) AS ACMSettlementCreationDateTime,
  StlUnitHead.settl_cat AS SettlmtCat,
  concat('XS', concat(StlUnitHead.settl_doc, StlUnitHead.settl_yr) ) AS SettlementStatusObject,
  StlUnitHead.appldoc AS ContractApplicationDocument,
  StlUnitHead.appldoc_item AS ApplicationDocumentItem,
  StlUnitHead.settl_doc AS SettlmtDoc,
  StlUnitHead.settl_scenario AS SettlementScenario,
  StlUnitHead.settl_type AS CndnContrSettlmtType,
  StlUnitHead.settl_yr AS SettlmtDocYear,
  StlUnitHead.side AS Side,
  _StlGroupHeader.guid AS SettlementDocGroupUUID,
  _StlGroupHeader.group_id AS SettlementGroupId,
  _StlUnitItem.unit_quantity AS SettlmtQuantity,
  _StlUnitItem.unit_uom AS SettlmtQuantityUnit,
  _StlInv.invoice_doc AS SettlementDocInvoiceNumber,
  _StlInv.invoice_doc_yr AS SettlementDocInvoiceYear
FROM /accgo/t_stlhead AS StlUnitHead
INNER JOIN /accgo/t_stlitem AS _StlUnitItem ON /* join condition not captured in parsed metadata */
INNER JOIN /accgo/t_stlctnr AS _StlDocContainer ON /* join condition not captured in parsed metadata */
INNER JOIN /accgo/t_grp_hdr AS _StlGroupHeader ON /* join condition not captured in parsed metadata */
INNER JOIN /accgo/t_stlinv AS _StlInv ON /* join condition not captured in parsed metadata */
;