C_Schedgagrmtitm

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_Schedgagrmtitm.
-- 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: CSCHEDGAGRMTITM

CREATE VIEW C_Schedgagrmtitm AS
SELECT
  I_SchedgAgrmtItmWithDraft.SchedulingAgreement AS SchedulingAgreement,
  I_SchedgAgrmtItmWithDraft.SchedulingAgreementItem AS SchedulingAgreementItem,
  I_SchedgAgrmtItmWithDraft.PurchasingDocumentType AS PurchasingDocumentType,
  I_SchedgAgrmtItmWithDraft.SchedgAgrmtItemCategory AS SchedgAgrmtItemCategory,
  I_SchedgAgrmtItmWithDraft.SchedgAgrmtExternalItmCategory AS SchedgAgrmtExternalItmCategory,
  I_SchedgAgrmtItmWithDraft.SchedgAgrmtItemCategoryName AS SchedgAgrmtItemCategoryName,
  I_SchedgAgrmtItmWithDraft.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_SchedgAgrmtItmWithDraft.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  I_SchedgAgrmtItmWithDraft.PartialInvoiceDistribution AS PartialInvoiceDistribution,
  I_SchedgAgrmtItmWithDraft.CompanyCode AS CompanyCode,
  I_SchedgAgrmtItmWithDraft.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_SchedgAgrmtItmWithDraft.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  I_SchedgAgrmtItmWithDraft.Material AS Material,
  I_SchedgAgrmtItmWithDraft.ManufacturerMaterial AS ManufacturerMaterial,
  I_SchedgAgrmtItmWithDraft.SupplierMaterialNumber AS SupplierMaterialNumber,
  I_SchedgAgrmtItmWithDraft.MaterialGroup AS MaterialGroup,
  I_SchedgAgrmtItmWithDraft.SchedgAgreementDeletionCode AS SchedgAgreementDeletionCode,
  I_SchedgAgrmtItmWithDraft.Plant AS Plant,
  I_SchedgAgrmtItmWithDraft.IncotermsClassification AS IncotermsClassification,
  I_SchedgAgrmtItmWithDraft.IncotermsLocation1 AS IncotermsLocation1,
  I_SchedgAgrmtItmWithDraft.IncotermsLocation2 AS IncotermsLocation2,
  I_SchedgAgrmtItmWithDraft.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_SchedgAgrmtItmWithDraft.IncotermsLocation1Identifier AS IncotermsLocation1Identifier,
  I_SchedgAgrmtItmWithDraft.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  I_SchedgAgrmtItmWithDraft.IncotermsLocation2Identifier AS IncotermsLocation2Identifier,
  I_SchedgAgrmtItmWithDraft.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  I_SchedgAgrmtItmWithDraft.IncotermsDvtgLocIdentifier AS IncotermsDvtgLocIdentifier,
  I_SchedgAgrmtItmWithDraft.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  I_SchedgAgrmtItmWithDraft.IncotermsDvtgLocDescription AS IncotermsDvtgLocDescription,
  I_SchedgAgrmtItmWithDraft.OrderQuantityUnit AS OrderQuantityUnit,
  I_SchedgAgrmtItmWithDraft.ItemNetWeight AS ItemNetWeight,
  I_SchedgAgrmtItmWithDraft.WeightUnit AS WeightUnit,
  I_SchedgAgrmtItmWithDraft.TargetQuantity AS TargetQuantity,
  I_SchedgAgrmtItmWithDraft.PurchaseRequisition AS PurchaseRequisition,
  I_SchedgAgrmtItmWithDraft.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  I_SchedgAgrmtItmWithDraft.SchedAgrmtAgreedCumQty AS SchedAgrmtAgreedCumQty,
  I_SchedgAgrmtItmWithDraft.SchedAgrmtCumQtyReconcileDate AS SchedAgrmtCumQtyReconcileDate,
  I_SchedgAgrmtItmWithDraft.ItemLastTransmissionDate AS ItemLastTransmissionDate,
  I_SchedgAgrmtItmWithDraft.NetPriceAmount AS NetPriceAmount,
  I_SchedgAgrmtItmWithDraft.NetPriceQuantity AS NetPriceQuantity,
  I_SchedgAgrmtItmWithDraft.OrderPriceUnit AS OrderPriceUnit,
  I_SchedgAgrmtItmWithDraft.MaterialType AS MaterialType,
  I_SchedgAgrmtItmWithDraft.StorageLocation AS StorageLocation,
  I_SchedgAgrmtItmWithDraft.DocumentCurrency AS DocumentCurrency,
  I_SchedgAgrmtItmWithDraft.IsInfoRecordUpdated AS IsInfoRecordUpdated,
  I_SchedgAgrmtItmWithDraft.PurchasingInfoRecord AS PurchasingInfoRecord,
  I_SchedgAgrmtItmWithDraft.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  I_SchedgAgrmtItmWithDraft.OrdPrcUnitToOrderUnitDnmntrUoM AS OrdPrcUnitToOrderUnitDnmntrUoM,
  I_SchedgAgrmtItmWithDraft.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  I_SchedgAgrmtItmWithDraft.OrdPrcUnitToOrderUnitNmrtrUoM AS OrdPrcUnitToOrderUnitNmrtrUoM,
  I_SchedgAgrmtItmWithDraft.NoDaysReminder1 AS NoDaysReminder1,
  I_SchedgAgrmtItmWithDraft.NoDaysReminder2 AS NoDaysReminder2,
  I_SchedgAgrmtItmWithDraft.NoDaysReminder3 AS NoDaysReminder3,
  I_SchedgAgrmtItmWithDraft.ConfirmationControl AS ConfirmationControl,
  I_SchedgAgrmtItmWithDraft.PurgDocOrderAcknNumber AS PurgDocOrderAcknNumber,
  I_SchedgAgrmtItmWithDraft.RequirementTracking AS RequirementTracking,
  I_SchedgAgrmtItmWithDraft.IsOrderAcknRqd AS IsOrderAcknRqd,
  I_SchedgAgrmtItmWithDraft.PurgDocEstimatedPrice AS PurgDocEstimatedPrice,
  I_SchedgAgrmtItmWithDraft.PriceIsToBePrinted AS PriceIsToBePrinted,
  I_SchedgAgrmtItmWithDraft.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  I_SchedgAgrmtItmWithDraft.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  I_SchedgAgrmtItmWithDraft.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  I_SchedgAgrmtItmWithDraft.ShippingInstruction AS ShippingInstruction,
  I_SchedgAgrmtItmWithDraft.StockType AS StockType,
  I_SchedgAgrmtItmWithDraft.SchedgAgrmtItmReplnmtElmntType AS SchedgAgrmtItmReplnmtElmntType,
  I_SchedgAgrmtItmWithDraft.TaxCode AS TaxCode,
  I_SchedgAgrmtItmWithDraft.TaxCountry AS TaxCountry,
  I_SchedgAgrmtItmWithDraft.TaxDeterminationDate AS TaxDeterminationDate,
  I_SchedgAgrmtItmWithDraft.TaxCodeValidFromDate AS TaxCodeValidFromDate,
  _Plant._Address._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_SchedgAgrmtItmWithDraft.IsInfoAtRegistration AS IsInfoAtRegistration,
  I_SchedgAgrmtItmWithDraft.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  I_SchedgAgrmtItmWithDraft.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated
FROM I_SchedgAgrmtItmWithDraft
LEFT OUTER JOIN C_Schedgagrmthdr AS _SchedgagrmthdrWithDraft ON _SchedgagrmthdrWithDraft.SchedulingAgreement = SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN C_Schedgline AS _SchedglineWithDraft ON _SchedglineWithDraft.SchedulingAgreementItem = SchedulingAgreementItem AND _SchedglineWithDraft.SchedulingAgreement = SchedulingAgreement  -- association [0..*]
LEFT OUTER JOIN C_Schedgagrmntitmcnd AS _Schedgagrmtitmcndwithdraft ON _Schedgagrmtitmcndwithdraft.SchedulingAgreementItem = SchedulingAgreementItem AND _Schedgagrmtitmcndwithdraft.SchedulingAgreement = SchedulingAgreement  -- association [0..*]
LEFT OUTER JOIN C_Schedagrmtacct AS _SchedagrmtacctWithDraft ON _SchedagrmtacctWithDraft.SchedulingAgreement = SchedulingAgreement AND _SchedagrmtacctWithDraft.SchedulingAgreementItem = SchedulingAgreementItem  -- association [0..*]
LEFT OUTER JOIN C_Schagmtdelivaddress AS _Schedgagrmtdeliveryaddresswd ON _Schedgagrmtdeliveryaddresswd.SchedulingAgreementItem = SchedulingAgreementItem AND _Schedgagrmtdeliveryaddresswd.SchedulingAgreement = SchedulingAgreement  -- association [0..1]
LEFT OUTER JOIN I_Saconfirmationcontrol AS _Saconfirmationcontrol ON ConfirmationControl = _Saconfirmationcontrol.SupplierConfirmationControlKey  -- 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  -- 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_SchedgAgrmtAcctAssgmtCatVH AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurCtrStockType AS _PurCtrStockType ON StockType = _PurCtrStockType.StockType  -- association [1..1]
LEFT OUTER JOIN C_MM_TaxCodeValueHelp AS _TaxCode ON _TaxCode.TaxCode = TaxCode AND _TaxCode.TaxCalculationProcedure = TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN I_TaxCalculationProcedure AS _TaxCalculationProcedure ON _TaxCalculationProcedure.TaxCalculationProcedure = TaxCalculationProcedure  -- association [0..1]
LEFT OUTER JOIN I_SchedgAgrmtCumltvQtyCtrl AS _SchedgAgrmtCumltvQtyCtrl ON SchedAgrmtCumulativeQtyControl = _SchedgAgrmtCumltvQtyCtrl.SchedAgrmtCumulativeQtyControl  -- association [0..1]
LEFT OUTER JOIN I_SchedgAgrmtBindingOnMRP AS _SchedgAgrmtBindingOnMRP ON FirmTradeOffZoneBindMRP = _SchedgAgrmtBindingOnMRP.FirmTradeOffZoneBindMRP  -- association [1..1]
LEFT OUTER JOIN I_SchedgAgrmtJITIndicator AS _SchedgAgrmtJITIndicator ON IsRelevantForJITDelivSchedule = _SchedgAgrmtJITIndicator.IsRelevantForJITDelivSchedule  -- association [0..1]
LEFT OUTER JOIN I_QualityMgmtCtrlKey AS _QualityMgmtCtrlKey ON QualityMgmtCtrlKey = _QualityMgmtCtrlKey.QualityMgmtCtrlKey  -- association [0..1]
LEFT OUTER JOIN C_Mm_Releasecrtnprofilevh AS _Releasecrtnprofilevh ON SchedgAgrmtRelCreationProfile = _Releasecrtnprofilevh.SchedgAgrmtRelCreationProfile AND Plant = _Releasecrtnprofilevh.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON _OrderQuantityUnit.UnitOfMeasure = OrderQuantityUnit  -- association [0..1]
LEFT OUTER JOIN C_Mm_Shipinstructionvaluehelp AS _Shipinstructionvaluehelp ON _Shipinstructionvaluehelp.ShippingInstruction = ShippingInstruction  -- association [0..1]
LEFT OUTER JOIN C_Schinfoupdatetype AS _Schinfoupdatetype ON _Schinfoupdatetype.DomainValue = IsInfoRecordUpdated  -- association [0..1]
LEFT OUTER JOIN C_Schedgagrmtreleasedoc AS _Schedgagrmtreleasedoc ON _Schedgagrmtreleasedoc.SchedulingAgreement = SchedulingAgreement AND _Schedgagrmtreleasedoc.SchedulingAgreementItem = SchedulingAgreementItem  -- association [0..*]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN C_MultiAcctgDistrIndValueAdjVH 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_SchedgAgrmtItemNotesTP AS _SchedgAgrmtItemNotesTP ON _SchedgAgrmtItemNotesTP.SchedulingAgreement = SchedulingAgreement AND _SchedgAgrmtItemNotesTP.SchedulingAgreementItem = SchedulingAgreementItem  -- association [0..*]
LEFT OUTER JOIN C_SchedgAgrmtItmReplnmtElmntVH AS _SchedgAgrmtItmReplnmtElmntVH ON SchedgAgrmtItmReplnmtElmntType = _SchedgAgrmtItmReplnmtElmntVH.Kanban  -- association [0..1]
LEFT OUTER JOIN C_MM_IncotermValueHelp AS _IncotermsValueHelp ON _IncotermsValueHelp.IncotermsClassification = IncotermsClassification AND _IncotermsValueHelp.IncotermsVersion = IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_TranspLoadingPointVH AS _LoadingPointValueHelp ON _LoadingPointValueHelp.Location = LoadingPointForDelivery  -- association [0..1]
LEFT OUTER JOIN I_SchedgAgrmtIncoVersion AS _SchedAgrmtIncotermsVersion ON IncotermsVersion = _SchedAgrmtIncotermsVersion.IncotermsVersion  -- association [1..1]
LEFT OUTER JOIN C_SchedgAgrmtItmCatValHelp AS _SchedgAgrmtItmCatValHelp ON _SchedgAgrmtItmCatValHelp.PurchasingDocumentItemCategory = SchedgAgrmtItemCategory  -- association [0..1]
LEFT OUTER JOIN I_TransportationLocationVH AS _TransportationLocation1VH ON IncotermsLocation1Identifier = _TransportationLocation1VH.Location  -- association [0..*]
LEFT OUTER JOIN I_TransportationLocationVH AS _TransportationLocation2VH ON IncotermsLocation2Identifier = _TransportationLocation2VH.Location  -- association [0..*]
LEFT OUTER JOIN I_TransportationLocationVH AS _TransportationLocation3VH ON IncotermsDvtgLocIdentifier = _TransportationLocation3VH.Location  -- association [0..*]
LEFT OUTER JOIN I_PurgProdCmplncSupplierStsT AS _PurgProdCmplncSupplierStsT ON PurgProdCmplncSupplierStatus = _PurgProdCmplncSupplierStsT.PurgProdCmplncSupplierStatus AND _PurgProdCmplncSupplierStsT.Language = $session.system_language  -- association [0..1]
;