C_SchedgAgrmtItmObjPg

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_SchedgAgrmtItmObjPg.
-- 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: CSCHITMFS

CREATE VIEW C_SchedgAgrmtItmObjPg AS
SELECT
  I_SchedgAgrmtItm.SchedulingAgreement AS SchedulingAgreement,
  I_SchedgAgrmtItm.SchedulingAgreementItem AS SchedulingAgreementItem,
  _SchedgAgrmtHdrObjPg.PurchasingDocumentType AS PurchasingDocumentType,
  I_SchedgAgrmtItm.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  I_SchedgAgrmtItm.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_SchedgAgrmtItm.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  I_SchedgAgrmtItm.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  I_SchedgAgrmtItm.CompanyCode AS CompanyCode,
  I_SchedgAgrmtItm.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_SchedgAgrmtItm.MaterialType AS MaterialType,
  I_SchedgAgrmtItm.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  I_SchedgAgrmtItm.Material AS Material,
  _Material.MaterialName AS MaterialName,
  I_SchedgAgrmtItm.ManufacturerMaterial AS ManufacturerMaterial,
  I_SchedgAgrmtItm.SupplierMaterialNumber AS SupplierMaterialNumber,
  I_SchedgAgrmtItm.MaterialGroup AS MaterialGroup,
  _MaterialGroup.MaterialGroupName AS MaterialGroupName,
  I_SchedgAgrmtItm.Plant AS Plant,
  _Plant.PlantName AS PlantName,
  I_SchedgAgrmtItm.PurchasingInfoRecordUpdateCode AS PurchasingInfoRecordUpdateCode,
  I_SchedgAgrmtItm.OrderQuantityUnit AS OrderQuantityUnit,
  I_SchedgAgrmtItm.ItemNetWeight AS ItemNetWeight,
  I_SchedgAgrmtItm.WeightUnit AS WeightUnit,
  I_SchedgAgrmtItm.TargetQuantity AS TargetQuantity,
  I_SchedgAgrmtItm.NetPriceAmount AS NetPriceAmount,
  I_SchedgAgrmtItm.NetPriceQuantity AS NetPriceQuantity,
  I_SchedgAgrmtItm.OrderPriceUnit AS OrderPriceUnit,
  I_SchedgAgrmtItm.StorageLocation AS StorageLocation,
  I_SchedgAgrmtItm.DocumentCurrency AS DocumentCurrency,
  _SchedgAgrmtHdrObjPg.PurchasingOrganization AS PurchasingOrganization,
  I_SchedgAgrmtItm.NoDaysReminder1 AS NoDaysReminder1,
  I_SchedgAgrmtItm.NoDaysReminder2 AS NoDaysReminder2,
  I_SchedgAgrmtItm.NoDaysReminder3 AS NoDaysReminder3,
  I_SchedgAgrmtItm.SupplierConfirmationControlKey AS SupplierConfirmationControlKey,
  I_SchedgAgrmtItm.PurgDocOrderAcknNumber AS PurgDocOrderAcknNumber,
  I_SchedgAgrmtItm.RequirementTracking AS RequirementTracking,
  I_SchedgAgrmtItm.IsOrderAcknRqd AS IsOrderAcknRqd,
  I_SchedgAgrmtItm.PurchasingPriceIsEstimated AS PurchasingPriceIsEstimated,
  I_SchedgAgrmtItm.PriceIsToBePrinted AS PriceIsToBePrinted,
  I_SchedgAgrmtItm.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  I_SchedgAgrmtItm.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  I_SchedgAgrmtItm.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  I_SchedgAgrmtItm.TaxCode AS TaxCode,
  I_SchedgAgrmtItm.TaxCountry AS TaxCountry,
  I_SchedgAgrmtItm.TaxDeterminationDate AS TaxDeterminationDate,
  I_SchedgAgrmtItm.IsInfoAtRegistration AS IsInfoAtRegistration,
  I_SchedgAgrmtItm.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  I_SchedgAgrmtItm.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  I_SchedgAgrmtItm.InvoiceIsExpected AS InvoiceIsExpected,
  I_SchedgAgrmtItm.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  I_SchedgAgrmtItm.EvaldRcptSettlmtIsAllowed AS EvaldRcptSettlmtIsAllowed,
  I_SchedgAgrmtItm.IsToBeAcceptedAtOrigin AS IsToBeAcceptedAtOrigin,
  I_SchedgAgrmtItm.MinRemainingShelfLife AS MinRemainingShelfLife,
  I_SchedgAgrmtItm.QualityMgmtCtrlKey AS QualityMgmtCtrlKey,
  I_SchedgAgrmtItm.QualityCertificateType AS QualityCertificateType,
  I_SchedgAgrmtItm.ShippingInstruction AS ShippingInstruction,
  I_SchedgAgrmtItm.SchedgAgrmtItmReplnmtElmntType AS SchedgAgrmtItmReplnmtElmntType,
  _Schedgagrmthdr.IncotermsVersion AS IncotermsVersion,
  I_SchedgAgrmtItm.IncotermsClassification AS IncotermsClassification,
  I_SchedgAgrmtItm.IncotermsLocation1 AS IncotermsLocation1,
  I_SchedgAgrmtItm.IncotermsLocation2 AS IncotermsLocation2,
  I_SchedgAgrmtItm.IncotermsLocation1Identifier AS IncotermsLocation1Identifier,
  I_SchedgAgrmtItm.IncotermsLocation2Identifier AS IncotermsLocation2Identifier,
  I_SchedgAgrmtItm.IncotermsDvtgLocIdentifier AS IncotermsDvtgLocIdentifier,
  I_SchedgAgrmtItm.IncotermsDvtgLocDescription AS IncotermsDvtgLocDescription
FROM I_SchedgAgrmtItm
LEFT OUTER JOIN C_SchedgAgrmtHdrObjPg AS _SchedgAgrmtHdrObjPg ON _SchedgAgrmtHdrObjPg.SchedulingAgreement = SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _Material ON _Material.Material = Material AND _Material.Plant = Plant  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _Text ON Material = _Text.Material  -- association [0..*]
LEFT OUTER JOIN C_MM_MaterialGroupValueHelp AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderUnitValueHelp ON OrderPriceUnit = _OrderUnitValueHelp.UnitOfMeasure AND OrderQuantityUnit = _OrderUnitValueHelp.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN C_MM_StorLocValueHelp AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND Plant = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN C_MM_AccountAssignCatValueHelp AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN C_MltplAcctAssgmtDistrVH AS _MltplAcctAssgmtDistrVH ON MultipleAcctAssgmtDistribution = _MltplAcctAssgmtDistrVH.MultipleAcctAssgmtDistribution  -- association [0..1]
LEFT OUTER JOIN C_PartialGoodsReceiptIndVH AS _PartialGoodsReceiptIndVH ON PartialInvoiceDistribution = _PartialGoodsReceiptIndVH.PartialInvoiceDistribution  -- association [0..1]
LEFT OUTER JOIN C_SchedgAgrmtFactSheetItemText AS _SchedgAgrmtFactSheetItemText ON SchedulingAgreement = _SchedgAgrmtFactSheetItemText.SchedulingAgreement AND SchedulingAgreementItem = _SchedgAgrmtFactSheetItemText.SchedulingAgreementItem  -- association [0..*]
;