C_SalesDocumentSchedLineDEX_1

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_SalesDocumentSchedLineDEX_1.
-- 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: CSDSDOCSCHDLNDX1

CREATE VIEW C_SalesDocumentSchedLineDEX_1 AS
SELECT
  ScheduleLine.SalesDocument AS SalesDocument,
  ScheduleLine.SalesDocumentItem AS SalesDocumentItem,
  ScheduleLine.ScheduleLine AS ScheduleLine,
  SalesDocumentItem.CreationDate AS CreationDate,
  SalesDocumentItem.CreationTime AS CreationTime,
  SalesDocumentItem.LastChangeDate AS LastChangeDate,
  SalesDocument.SDDocumentCategory AS SDDocumentCategory,
  SalesDocument.SalesDocumentType AS SalesDocumentType,
  SalesDocumentItem.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  ScheduleLine.ScheduleLineCategory AS ScheduleLineCategory,
  SalesDocument.SalesOrganization AS SalesOrganization,
  SalesDocument.DistributionChannel AS DistributionChannel,
  SalesDocumentItem.Division AS Division,
  SalesDocument.SalesGroup AS SalesGroup,
  SalesDocument.SalesOffice AS SalesOffice,
  SalesDocument.PricingDate AS PricingDate,
  SalesDocumentItem.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  SalesDocumentItem.NetPriceQuantity AS NetPriceQuantity,
  SalesDocumentItem.NetPriceAmount AS NetPriceAmount,
  SalesDocument.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  SalesDocumentItem.Material AS Material,
  SalesDocumentItem.MaterialGroup AS MaterialGroup,
  SalesDocumentItem.ProductGroup AS ProductGroup,
  SalesDocumentItem.Product AS Product,
  SalesDocumentItem.ProductHierarchyNode AS ProductHierarchyNode,
  ScheduleLine.ProductAvailabilityDate AS ProductAvailabilityDate,
  SalesDocumentItem.InternationalArticleNumber AS InternationalArticleNumber,
  SalesDocumentItem.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  SalesDocumentItem.MaterialSubstitutionReason AS MaterialSubstitutionReason,
  SalesDocumentItem.Batch AS Batch,
  SalesDocumentItem.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  SalesDocumentItem.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  SalesDocumentItem.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  SalesDocumentItem.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  SalesDocumentItem.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  SalesDocument.SoldToParty AS SoldToParty,
  SalesDocument.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  SalesDocument.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  SalesDocument.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  SalesDocument.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  SalesDocument.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  SalesDocument.CustomerGroup AS CustomerGroup,
  SalesDocument.SDDocumentReason AS SDDocumentReason,
  ScheduleLine.IsConfirmedDelivSchedLine AS IsConfirmedDelivSchedLine,
  ScheduleLine.IsRequestedDelivSchedLine AS IsRequestedDelivSchedLine,
  SalesDocumentItem.TargetQuantityUnit AS TargetQuantityUnit,
  ScheduleLine.CorrectedQtyInOrderQtyUnit AS CorrectedQtyInOrderQtyUnit,
  ScheduleLine.OrderQuantityUnit AS OrderQuantityUnit,
  ScheduleLine.ConfdOrderQtyByMatlAvailCheck AS ConfdOrderQtyByMatlAvailCheck,
  ScheduleLine.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  SalesDocumentItem.TargetToBaseQuantityDnmntr AS TargetToBaseQuantityDnmntr,
  SalesDocumentItem.TargetToBaseQuantityNmrtr AS TargetToBaseQuantityNmrtr,
  SalesDocumentItem.OrderToBaseQuantityDnmntr AS OrderToBaseQuantityDnmntr,
  SalesDocumentItem.OrderToBaseQuantityNmrtr AS OrderToBaseQuantityNmrtr,
  SalesDocumentItem.BaseUnit AS BaseUnit,
  SalesDocumentItem.ItemVolumeUnit AS ItemVolumeUnit,
  SalesDocumentItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  SalesDocumentItem.ItemWeightUnit AS ItemWeightUnit,
  SalesDocument.SalesDistrict AS SalesDistrict,
  ScheduleLine.DeliveryDate AS DeliveryDate,
  SalesDocument.RequestedDeliveryDate AS RequestedDeliveryDate,
  SalesDocument.ServicesRenderedDate AS ServicesRenderedDate,
  SalesDocument.StatisticsCurrency AS StatisticsCurrency,
  SalesDocumentItem.ShipToParty AS ShipToParty,
  SalesDocumentItem.PayerParty AS PayerParty,
  SalesDocumentItem.BillToParty AS BillToParty,
  SalesDocumentItem.Route AS Route,
  SalesDocumentItem.Plant AS Plant,
  SalesDocumentItem.StorageLocation AS StorageLocation,
  SalesDocumentItem.ShippingPoint AS ShippingPoint,
  SalesDocument.IncotermsClassification AS IncotermsClassification,
  SalesDocument.IncotermsTransferLocation AS IncotermsTransferLocation,
  SalesDocument.IncotermsVersion AS IncotermsVersion,
  SalesDocument.DeliveryBlockReason AS DeliveryBlockReason,
  ScheduleLine.ConfdSchedLineReqdDelivDate AS ConfdSchedLineReqdDelivDate,
  ScheduleLine.ConfirmedDeliveryDate AS ConfirmedDeliveryDate,
  ScheduleLine.MRPRequiredQuantityInBaseUnit AS MRPRequiredQuantityInBaseUnit,
  ScheduleLine.DelivBlockReasonForSchedLine AS DelivBlockReasonForSchedLine,
  ScheduleLine.LoadingDate AS LoadingDate,
  ScheduleLine.TransportationPlanningDate AS TransportationPlanningDate,
  ScheduleLine.GoodsIssueDate AS GoodsIssueDate,
  SalesDocumentItem.ItemOrderProbabilityInPercent AS ItemOrderProbabilityInPercent,
  SalesDocument.BindingPeriodValidityStartDate AS BindingPeriodValidityStartDate,
  SalesDocument.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  SalesDocument.BillingCompanyCode AS BillingCompanyCode,
  SalesDocument.BillingDocumentDate AS BillingDocumentDate,
  SalesDocumentItem.ItemBillingBlockReason AS ItemBillingBlockReason,
  SalesDocument.ExchangeRateType AS ExchangeRateType,
  SalesDocument.ExchangeRateDate AS ExchangeRateDate,
  CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  SalesDocumentItem.TransactionCurrency AS TransactionCurrency,
  SalesDocument.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  SalesDocumentItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  SalesDocumentItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  SalesDocumentItem.ItemDeliveryIncompletionStatus AS ItemDeliveryIncompletionStatus,
  SalesDocumentItem.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus,
  SalesDocumentItem.ItemBillingIncompletionStatus AS ItemBillingIncompletionStatus,
  SalesDocumentItem.PricingIncompletionStatus AS PricingIncompletionStatus
FROM I_SalesDocumentScheduleLine AS ScheduleLine
INNER JOIN I_SalesDocumentItem AS SalesDocumentItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocument AS SalesDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _ExtensionItem ON SalesDocument = _ExtensionItem.SalesDocument AND SalesDocumentItem = _ExtensionItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _ExtensionHeader ON SalesDocument = _ExtensionHeader.SalesDocument  -- association [0..1]
;