C_PurgDocSuplrConfSitn

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_PurgDocSuplrConfSitn.
-- 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: CPURGDOCSITN

CREATE VIEW C_PurgDocSuplrConfSitn AS
SELECT
  cast ( PurgDocSchedline.SupplierConfirmationCategory as vdm_supplierconfirmationcatego preserving type ) AS SupplierConfirmationCategory,
  cast ( PurgDocSchedline.PurchasingDocument as ebeln_d preserving type ) AS PurchasingDocument,
  PurgDocSchedline.PurchasingDocumentItem AS PurchasingDocumentItem,
  PurgDocSchedline.ScheduleLine AS ScheduleLine,
  PurgDocSchedline.Plant AS Plant,
  PurgDocSchedline.PurchasingGroup AS PurchasingGroup,
  PurgDocSchedline.PurchasingOrganization AS PurchasingOrganization,
  PurgDocSchedline.Supplier AS Supplier,
  PurgDocSchedline.MaterialGroup AS MaterialGroup,
  PurgDocSchedline.Material AS Material,
  PurgDocSchedline.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  PurgDocSchedline.DocumentDate AS DocumentDate,
  PurgDocSchedline.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurgDocSchedline.PurchasingDocumentType AS PurchasingDocumentType,
  PurgDocSchedline.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  PurgDocSchedline.AccountAssignmentCategory AS AccountAssignmentCategory,
  PurgDocSchedline.CompanyCode AS CompanyCode,
  PurgDocSchedline.ShortText AS PurchasingDocumentItemText,
  PurgDocSchedline.DelivDateCategory AS DelivDateCategory,
  PurgDocSchedline.KeyDate AS KeyDate,
  PurgDocSchedline.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  PurgDocSchedline.ValidityStartDate AS ValidityStartDate,
  PurgDocSchedline.ValidityEndDate AS ValidityEndDate,
  _SchedgAgrmtItmDelivCalc.SchedAgrmtValidityStatus AS SchedAgrmtValidityStatus,
  PurgDocSchedline.PurchasingDocumentStatus AS PurchasingDocumentStatus,
  PurgDocSchedline.StorageLocation AS StorageLocation
FROM P_purgdocconf AS PurgDocSchedline
LEFT OUTER JOIN C_SchedgAgrmtItmDelivCalc AS _SchedgAgrmtItmDelivCalc ON PurchasingDocument = _SchedgAgrmtItmDelivCalc.SchedulingAgreement AND PurchasingDocumentItem = _SchedgAgrmtItmDelivCalc.SchedulingAgreementItem  -- association [1..1]
LEFT OUTER JOIN C_PurchasingDocTypeValueHelp AS _PurDocTypeValHelp ON _PurDocTypeValHelp.PurchasingDocumentType = PurchasingDocumentType AND _PurDocTypeValHelp.PurchasingDocumentCategory = 'F'  -- association [0..1]
;