C_RequirementTrckgSchedAgrmt

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_RequirementTrckgSchedAgrmt.
-- 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: CREQTRACKSA

CREATE VIEW C_RequirementTrckgSchedAgrmt AS
SELECT
  SchedulingAgreement,
  SchedulingAgreementItem,
  concat(SchedulingAgreement, concat('/', SchedulingAgreementItem)) AS FormattedPurchasingDocItem,
  _PurContrSchedAgrmtValdtySts.PurContrValidityStatusName AS PurContrValidityStatusName,
  _PurchasingDocument.Supplier AS Supplier,
  _PurchasingDocument.ValidityEndDate AS ValidityEndDate,
  Material,
  _PurchasingDocument.TargetAmount AS TargetAmount,
  DocumentCurrency,
  _PurchasingDocument.ValidityStartDate AS ValidityStartDate,
  _PurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingDocument.PurchasingDocumentType AS PurchasingDocumentType,
  _PurchasingDocument.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  CompanyCode,
  IncotermsClassification,
  _PurchasingDocument.PaymentTerms AS PaymentTerms,
  RequirementTracking,
  MaterialGroup,
  _PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  Plant,
  StorageLocation,
  AccountAssignmentCategory,
  _PurgDocumentItemCategory._Text[1: Language = $session.system_language].PurgDocExternalItemCategory AS PurgDocExternalItemCategory,
  I_SchedgAgrmtItm.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _PurgDocumentItemCategory._Text[1: Language = $session.system_language].PurgDocItemCategoryName AS PurgDocItemCategoryName,
  PurchasingDocumentItemText AS PurchasingText,
  _PurchasingCategoryMatlGrp._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  _PurchasingCategoryMatlGrp._PurchasingCategory.PurgCatName AS PurgCatName,
  TargetQuantity,
  OrderQuantityUnit,
  NetPriceAmount,
  NetPriceQuantity,
  OrderPriceUnit,
  FirmTradeOffZoneBindMRP,
  _SchedgAgrmtBindingOnMRP._Text[1: Language = $session.system_language].FirmTradeOffZoneBindMRPText AS FirmTradeOffZoneBindMRPText,
  SchedAgrmtCumQtyReconcileDate
FROM I_SchedgAgrmtItm
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGrp ON MaterialGroup = _PurchasingCategoryMatlGrp.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN P_PurContrSchedAgrmtValdtySts AS _PurContrSchedAgrmtValdtySts ON SchedulingAgreement = _PurContrSchedAgrmtValdtySts.SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN I_AccountAssignmentCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchasingDocumentItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_SchedgAgrmtBindingOnMRP AS _SchedgAgrmtBindingOnMRP ON FirmTradeOffZoneBindMRP = _SchedgAgrmtBindingOnMRP.FirmTradeOffZoneBindMRP  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON purchasingorganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON purchasingdocumentcategory = _PurchasingDocumentType.PurchasingDocumentCategory AND purchasingdocumenttype = _PurchasingDocumentType.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON purchasinggroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON purchasingdocumentcategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
;