P_SlsDocItemPrdtvTrngData

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 P_SlsDocItemPrdtvTrngData.
-- 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: PSLSDOCITEMPTD

CREATE VIEW P_SlsDocItemPrdtvTrngData AS
SELECT
  Item.SalesDocument AS SalesDocument,
  Item.SalesDocumentItem AS SalesDocumentItem,
  cast( dats_days_between(Item._SlsDocItemEnhancedFields._DeliveryCreationDate.DeliveryCreationDate , DelivCrtnDate.DelivDocItemCreationDate) as deliverycreationdelay ) AS DeliveryDelayInDays,
  Item.SDDocumentCategory AS SDDocumentCategory,
  Item.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  Item.SalesDocumentItemType AS SalesDocumentItemType,
  Item.CompletionRule AS CompletionRule,
  SalesDocument.SalesDocumentType AS SalesDocumentType,
  SalesDocument.SalesDocumentProcessingType AS SalesDocumentProcessingType,
  Item.CreatedByUser AS ItemCreatedByUser,
  Item.CreationDate AS ItemCreationDate,
  Item.CreationTime AS ItemCreationTime,
  Item.LastChangeDate AS ItemLastChangeDate,
  SalesDocument.CreatedByUser AS CreatedByUser,
  SalesDocument.LastChangedByUser AS LastChangedByUser,
  SalesDocument.CreationDate AS CreationDate,
  SalesDocument.CreationTime AS CreationTime,
  SalesDocument.LastChangeDate AS LastChangeDate,
  SalesDocument.LastChangeDateTime AS LastChangeDateTime,
  cast (CalendarDate.CalendarYear as creation_date_year) AS ItemCreationDateYear,
  cast (CalendarDate.CalendarMonth as creation_date_month) AS ItemCreationCalendarMonth,
  cast (CalendarDate.CalendarWeek as creation_date_week) AS ItemCreationCalendarWeek,
  Item.Division AS Division,
  SalesDocument.SalesOrganization AS SalesOrganization,
  SalesDocument.DistributionChannel AS DistributionChannel,
  cast (SalesDocument.OrganizationDivision as organization_division) AS OrganizationDivision,
  SalesDocument.SalesGroup AS SalesGroup,
  SalesDocument.SalesOffice AS SalesOffice,
  Item.Material AS Material,
  Item.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  Item.MaterialByCustomer AS MaterialByCustomer,
  Item.InternationalArticleNumber AS InternationalArticleNumber,
  Item.Batch AS Batch,
  Item.ProductHierarchyNode AS ProductHierarchyNode,
  Item.ProductCatalog AS ProductCatalog,
  Item.MaterialSubstitutionReason AS MaterialSubstitutionReason,
  Item.MaterialGroup AS MaterialGroup,
  Item.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  Item.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  Item.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  Item.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  Item.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  Item.ProductConfiguration AS ProductConfiguration,
  Item.MRPArea AS MRPArea,
  Item.BillOfMaterial AS BillOfMaterial,
  Item.ProdAvailabilityCheckGroup AS ProdAvailabilityCheckGroup,
  SalesDocument.SoldToParty AS SoldToParty,
  cast( coalesce(ItemShipToParty.Customer, HeaderShipToParty.Customer)as kunwe) AS ShipToParty,
  Item.SalesDocumentItemText AS SalesDocumentItemText,
  Item.OrderQuantity AS OrderQuantity,
  Item.OrderQuantityUnit AS OrderQuantityUnit,
  Item.ConfdDelivQtyInOrderQtyUnit AS ConfdDelivQtyInOrderQtyUnit,
  Item.TargetDelivQtyInOrderQtyUnit AS TargetDelivQtyInOrderQtyUnit,
  Item.ConfdDeliveryQtyInBaseUnit AS ConfdDeliveryQtyInBaseUnit,
  Item.BaseUnit AS BaseUnit,
  Item.RequestedQuantity AS RequestedQuantity,
  Item.RequestedQuantityUnit AS RequestedQuantityUnit,
  Item.RequestedQuantityInBaseUnit AS RequestedQuantityInBaseUnit,
  Item.ItemGrossWeight AS ItemGrossWeight,
  Item.ItemNetWeight AS ItemNetWeight,
  Item.ItemWeightUnit AS ItemWeightUnit,
  Item.ItemVolume AS ItemVolume,
  Item.ItemVolumeUnit AS ItemVolumeUnit,
  Item.SalesDistrict AS SalesDistrict,
  Item.SalesDeal AS SalesDeal,
  cast (Item.SalesPromotion as sales_promotion) AS SalesPromotion,
  cast (Item.RetailPromotion as retail_promotion) AS RetailPromotion,
  Item.CustomerGroup AS CustomerGroup,
  Item.RequirementSegment AS RequirementSegment,
  Item.QuantityIsFixed AS QuantityIsFixed,
  SalesDocument.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  SalesDocument.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  SalesDocument.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  SalesDocument.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  SalesDocument.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  SalesDocument.CreditControlArea AS CreditControlArea,
  SalesDocument.SalesDocumentDate AS SalesDocumentDate,
  SalesDocument.SDDocumentReason AS SDDocumentReason,
  SalesDocument.SDDocumentCollectiveNumber AS SDDocumentCollectiveNumber,
  SalesDocument.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  SalesDocument.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  SalesDocument.CustomerPurchaseOrderSuplmnt AS CustomerPurchaseOrderSuplmnt,
  Item.NetAmount AS NetAmount,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.MaterialPricingGroup AS MaterialPricingGroup,
  Item.NetPriceAmount AS NetPriceAmount,
  Item.NetPriceQuantity AS NetPriceQuantity,
  Item.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  Item.TaxAmount AS TaxAmount,
  Item.CostAmount AS CostAmount,
  Item.Subtotal1Amount AS Subtotal1Amount,
  Item.Subtotal2Amount AS Subtotal2Amount,
  Item.Subtotal3Amount AS Subtotal3Amount,
  Item.Subtotal4Amount AS Subtotal4Amount,
  Item.Subtotal5Amount AS Subtotal5Amount,
  Item.Subtotal6Amount AS Subtotal6Amount,
  Item.SalesDocumentCondition AS SalesDocumentCondition,
  SalesDocument.TotalNetAmount AS TotalNetAmount,
  Item.ShippingPoint AS ShippingPoint,
  Item.ShippingType AS ShippingType,
  Item.InventorySpecialStockType AS InventorySpecialStockType,
  Item.DeliveryPriority AS DeliveryPriority,
  Item.Plant AS Plant,
  Item.StorageLocation AS StorageLocation,
  Item.Route AS Route,
  Item.DeliveryGroup AS DeliveryGroup,
  Item.DeliveryDateQuantityIsFixed AS DeliveryDateQuantityIsFixed,
  Item.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  Item.MaxNmbrOfPartialDelivery AS MaxNmbrOfPartialDelivery,
  Item.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  Item.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  Item.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  Item.MinDeliveryQtyInBaseUnit AS MinDeliveryQtyInBaseUnit,
  Item.OpenDeliveryLeadingUnitCode AS OpenDeliveryLeadingUnitCode,
  SalesDocument.ShippingCondition AS ShippingCondition,
  SalesDocument.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  Item.ProductSeasonYear AS ProductSeasonYear,
  Item.ProductSeason AS ProductSeason,
  Item.ProductCollection AS ProductCollection,
  Item.ProductTheme AS ProductTheme,
  Item.FashionCancelDate AS FashionCancelDate,
  Item.ProductCharacteristic1 AS ProductCharacteristic1,
  Item.ProductCharacteristic2 AS ProductCharacteristic2,
  Item.ProductCharacteristic3 AS ProductCharacteristic3,
  Item.ShippingGroupNumber AS ShippingGroupNumber,
  Item.ShippingGroupRule AS ShippingGroupRule,
  SalesDocument.BillingCompanyCode AS BillingCompanyCode,
  Item.IncotermsVersion AS IncotermsVersion,
  Item.IncotermsClassification AS IncotermsClassification,
  Item.IncotermsTransferLocation AS IncotermsTransferLocation,
  Item.IncotermsLocation1 AS IncotermsLocation1,
  Item.IncotermsLocation2 AS IncotermsLocation2,
  Item.CustomerPaymentTerms AS CustomerPaymentTerms,
  Item.PaymentMethod AS PaymentMethod,
  Item.BusinessArea AS BusinessArea,
  Item.ProfitCenter AS ProfitCenter,
  Item.WBSElement AS WBSElement,
  Item.WBSElementInternalID AS WBSElementInternalID,
  Item.OrderID AS OrderID,
  Item.ProfitabilitySegment_2 AS ProfitabilitySegment,
  cast (SalesDocument.CostCenterBusinessArea as business_area_cost_center) AS CostCenterBusinessArea,
  SalesDocument.CostCenter AS CostCenter,
  SalesDocument.ControllingArea AS ControllingArea,
  Item.HigherLevelItem AS HigherLevelItem,
  Item.ValueContract AS ValueContract,
  Item.ValueContractItem AS ValueContractItem
FROM I_SalesDocumentItem AS Item
INNER JOIN P_SlsDocItemPrdtvTrngData1 AS DelivCrtnDate ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocument AS SalesDocument ON /* join condition not captured in parsed metadata */
;