P_HUPSchedgAgrmt

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_HUPSchedgAgrmt.
-- 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 P_HUPSchedgAgrmt AS
SELECT
  _SalesDocumentItem.vbeln AS SalesSchedulingAgreement,
  _SalesDocumentItem.posnr AS SalesSchedulingAgreementItem,
  _SalesDocumentItem.auart_ana AS SalesDocumentType,
  _SalesDocumentItem.spart_ana AS OrganizationDivision,
  _SalesDocumentItem.vkorg_ana AS SalesOrganization,
  _SalesDocumentItem.vtweg_ana AS DistributionChannel,
  _SalesDocumentItem.werks AS Plant,
  _SalesDocumentItem.lgort AS StorageLocation,
  _SalesDocumentItem.kunwe_ana AS ShipToParty,
  cast (_SalesDocumentItem.matnr as productnumber preserving type) AS Product,
  _SalesDocumentItem.kwmeng AS OrderQuantity,
  _SalesDocumentItem.vrkme AS OrderQuantityUnit,
  _SalesDocumentItem.audat_ana AS SalesDocumentDate,
  _SalesDocumentItem.vbtyp_ana AS SDDocumentCategory
FROM vbap AS _SalesDocumentItem
INNER JOIN vbak AS _SalesDocumentHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_HUPProduct AS _Product ON Product = _Product.Product AND Plant = _Product.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
;