I_RFM_PrvsnlSlsContrDocItm

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 I_RFM_PrvsnlSlsContrDocItm.
-- 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: IRFMPRVSNLDOCITM

CREATE VIEW I_RFM_PrvsnlSlsContrDocItm AS
SELECT
  item.SalesDocument AS SalesContract,
  item.SalesDocumentItem AS SalesContractItem,
  item.SalesDocument AS SalesDocument,
  item.SalesDocumentItem AS SalesDocumentItem,
  cast(concat(concat(item.SalesDocument, '/'), item.SalesDocumentItem) as rfm_formattedsalesdocitm preserving type) AS FormattedSalesDocumentItem,
  item.SalesOrganization AS SalesOrganization,
  item.DistributionChannel AS DistributionChannel,
  item.OrganizationDivision AS OrganizationDivision,
  item.SoldToParty AS SoldToParty,
  item.CreatedByUser AS CreatedByUser,
  item.SDDocumentCategory AS SDDocumentCategory,
  item.OverallSDProcessStatus AS OverallSDProcessStatus,
  item.OverallTotalDeliveryStatus AS OverallTotalDeliveryStatus,
  item.InventorySpecialStockType AS InventorySpecialStockType,
  item.TotalBlockStatus AS TotalBlockStatus,
  item.SalesDocumentType AS SalesDocumentType,
  item.SalesGroup AS SalesGroup,
  item.SalesOffice AS SalesOffice,
  item.ShippingCondition AS ShippingCondition,
  item.CreationDate AS CreationDate,
  item.SDDocumentReason AS SDDocumentReason,
  item.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  item.SalesDocumentDate AS SalesDocumentDate,
  item.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  item.HdrGeneralIncompletionStatus AS HdrGeneralIncompletionStatus,
  item.OvrlItmGeneralIncompletionSts AS OvrlItmGeneralIncompletionSts,
  item.TotalCreditCheckStatus AS TotalCreditCheckStatus,
  item.DeliveryBlockReason AS DeliveryBlockReason,
  item.HeaderBillgIncompletionStatus AS HeaderBillgIncompletionStatus,
  item.OvrlItmBillingIncompletionSts AS OvrlItmBillingIncompletionSts,
  item.OverallPricingIncompletionSts AS OverallPricingIncompletionSts,
  item.HeaderDelivIncompletionStatus AS HeaderDelivIncompletionStatus,
  item.OvrlItmDelivIncompletionSts AS OvrlItmDelivIncompletionSts,
  item.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  item.CustomerConditionGroup1 AS CustomerConditionGroup1,
  item.CustomerConditionGroup2 AS CustomerConditionGroup2,
  item.CustomerConditionGroup3 AS CustomerConditionGroup3,
  item.CustomerConditionGroup4 AS CustomerConditionGroup4,
  item.CustomerConditionGroup5 AS CustomerConditionGroup5,
  item.DepartmentClassificationByCust AS DepartmentClassificationByCust,
  item.BillingDocumentDate AS BillingDocumentDate,
  item.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  item.AgrmtValdtyStartDate AS AgrmtValdtyStartDate,
  item.AgrmtValdtyEndDate AS AgrmtValdtyEndDate,
  item.Material AS Material,
  item.RequirementSegment AS RequirementSegment,
  item.Plant AS Plant,
  item._Plant.PlantName AS PlantName,
  item.StorageLocation AS StorageLocation,
  item.ShippingPoint AS ShippingPoint,
  item.DeliveryPriority AS DeliveryPriority,
  item.ShippingType AS ShippingType,
  item.CustomerPaymentTerms AS CustomerPaymentTerms,
  item.IncotermsClassification AS IncotermsClassification,
  item.IncotermsLocation1 AS IncotermsLocation1,
  item.ProductCharacteristic1 AS ProductCharacteristic1,
  item.ProductCharacteristic2 AS ProductCharacteristic2,
  item.ProductCharacteristic3 AS ProductCharacteristic3,
  item.ProductSeasonYear AS ProductSeasonYear,
  item.ProductSeason AS ProductSeason,
  item.ProductCollection AS ProductCollection,
  item.ProductTheme AS ProductTheme,
  item.ShippingGroupRule AS ShippingGroupRule,
  item.ShippingGroupNumber AS ShippingGroupNumber,
  item.Batch AS Batch,
  item.FashionCancelDate AS FashionCancelDate,
  item.OrderQuantity AS OrderQuantity,
  item.OrderQuantityUnit AS OrderQuantityUnit,
  item.ConfdDelivQtyInOrderQtyUnit AS ConfdDelivQtyInOrderQtyUnit,
  item.OrderToBaseQuantityDnmntr AS OrderToBaseQuantityDnmntr,
  item.OrderToBaseQuantityNmrtr AS OrderToBaseQuantityNmrtr,
  item.BaseUnit AS BaseUnit,
  item.RequestedDeliveryDate AS RequestedDeliveryDate,
  cast ( case when item.OrderToBaseQuantityDnmntr > 0 then coalesce(item.OrderQuantity,0) * division(item.OrderToBaseQuantityNmrtr,item.OrderToBaseQuantityDnmntr,2) else coalesce(item.OrderQuantity,0) end as abap.quan(15,3)) as RequestedQuantityInBaseUnit AS quan153asRequestedQuantityInBaseUnit,
  cast ( case when item.OrderToBaseQuantityDnmntr > 0 then coalesce(item.ConfdDelivQtyInOrderQtyUnit,0) * division(item.OrderToBaseQuantityNmrtr,item.OrderToBaseQuantityDnmntr,2) else coalesce(item.ConfdDelivQtyInOrderQtyUnit,0) end as abap.quan(15,3)) as ConfirmedRqmtQtyInBaseUnit AS quan153asConfirmedRqmtQtyInBaseUnit,
  item.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  item.CustomerGroup AS CustomerGroup,
  item.SalesDistrict AS SalesDistrict,
  item.ProductGroup AS ProductGroup,
  item.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  item.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  item.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  item.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  item.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  item.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  item.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  item.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  item.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  item.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  item.RetailAdditionalCustomerGrp6 AS RetailAdditionalCustomerGrp6,
  item.RetailAdditionalCustomerGrp7 AS RetailAdditionalCustomerGrp7,
  item.RetailAdditionalCustomerGrp8 AS RetailAdditionalCustomerGrp8,
  item.RetailAdditionalCustomerGrp9 AS RetailAdditionalCustomerGrp9,
  item.RetailAdditionalCustomerGrp10 AS RetailAdditionalCustomerGrp10,
  item.HigherLevelItem AS HigherLevelItem,
  item.SeasonCompletenessStatus AS SeasonCompletenessStatus,
  item.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus,
  item.ItemBillingIncompletionStatus AS ItemBillingIncompletionStatus,
  item.PricingIncompletionStatus AS PricingIncompletionStatus,
  item.ItemDeliveryIncompletionStatus AS ItemDeliveryIncompletionStatus,
  item.NetAmount AS NetAmount,
  item.TransactionCurrency AS TransactionCurrency,
  item.PricingDate AS PricingDate,
  item.CustomerPriceGroup AS CustomerPriceGroup,
  item.DeliveryStatus AS DeliveryStatus,
  item.ItemHasValueAddedService AS ItemHasValueAddedService,
  item.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  cast(item._Product.ProdCharc1InternalNumber as atinn_no_conv preserving type ) AS ProdCharc1InternalNumber,
  cast(item._Product.ProdCharc2InternalNumber as atinn_no_conv preserving type ) AS ProdCharc2InternalNumber,
  cast(item._Product.ProdCharc3InternalNumber as atinn_no_conv preserving type ) AS ProdCharc3InternalNumber,
  item.MaterialPricingGroup AS MaterialPricingGroup,
  item.Route AS Route,
  item.MaterialByCustomer AS MaterialByCustomer,
  item._SalesDocument AS _SalesDocument,
  item._Product AS _Product,
  item._BaseUnit AS _BaseUnit,
  item._Batch AS _Batch,
  item._OrderQuantityUnit AS _OrderQuantityUnit,
  item._SalesDistrict AS _SalesDistrict,
  item._CustomerGroup AS _CustomerGroup,
  item._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason,
  item._ShippingPoint AS _ShippingPoint,
  item._DeliveryPriority AS _DeliveryPriority,
  item._SoldToParty AS _SoldToParty,
  item._Plant AS _Plant,
  item._StorageLocation AS _StorageLocation,
  item._CustomerPaymentTerms AS _CustomerPaymentTerms,
  item._IncotermsClassification AS _IncotermsClassification,
  item._ItemGeneralIncompletionStatus AS _ItemGeneralIncompletionStatus,
  item._ItemBillingIncompletionStatus AS _ItemBillingIncompletionStatus,
  item._PricingIncompletionStatus AS _PricingIncompletionStatus,
  item._ItemDelivIncompletionSts AS _ItemDelivIncompletionSts,
  item._MaterialText AS _MaterialText,
  item._ShippingPointText AS _ShippingPointText,
  item._ProductGroup AS _ProductGroup,
  item._AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1,
  item._AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2,
  item._AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3,
  item._AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4,
  item._AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5,
  item._TransactionCurrency AS _TransactionCurrency,
  item._CustomerPriceGroup AS _CustomerPriceGroup,
  item._ShippingType AS _ShippingType,
  item._ItemCategory AS _ItemCategory,
  item._CustomerPurchaseOrderType AS _CustomerPurchaseOrderType,
  item._ContactPersonStdDepartment AS _ContactPersonStdDepartment,
  item._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
  item._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
  item._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
  item._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
  item._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
  item._RetailAddlCustGrp6 AS _RetailAddlCustGrp6,
  item._RetailAddlCustGrp7 AS _RetailAddlCustGrp7,
  item._RetailAddlCustGrp8 AS _RetailAddlCustGrp8,
  item._RetailAddlCustGrp9 AS _RetailAddlCustGrp9,
  item._RetailAddlCustGrp10 AS _RetailAddlCustGrp10,
  item._MaterialPricingGroup AS _MaterialPricingGroup,
  item._Route AS _Route,
  item._DeliveryBlockReason AS _DeliveryBlockReason,
  item._SalesGroup AS _SalesGroup,
  item._SalesOffice AS _SalesOffice,
  item._ShippingCondition AS _ShippingCondition,
  item._HeaderBillingBlockReason AS _HeaderBillingBlockReason,
  item._SDDocumentReason AS _SDDocumentReason
FROM I_RFM_SalesDocumentItem AS item
INNER JOIN I_RFMSalesDocumentType AS salesDocumentType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ARunSalesDocItmAssgdQty AS _AssignedSalesItem ON SalesContract = _AssignedSalesItem.RequirementDocumentNumber AND SalesContractItem = _AssignedSalesItem.RequirementDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _SDDocumentCategory ON SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _CharValTexts1 ON ProductCharacteristic1 = _CharValTexts1.RetailCharacteristicValue AND ProdCharc1InternalNumber = _CharValTexts1.CharacteristicInternalID AND _CharValTexts1.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _CharValTexts2 ON ProductCharacteristic2 = _CharValTexts2.RetailCharacteristicValue AND ProdCharc2InternalNumber = _CharValTexts2.CharacteristicInternalID AND _CharValTexts2.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _CharValTexts3 ON ProductCharacteristic3 = _CharValTexts3.RetailCharacteristicValue AND ProdCharc3InternalNumber = _CharValTexts3.CharacteristicInternalID AND _CharValTexts3.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_HdrBillgIncompletionStatus AS _HeaderBillgIncompletionStatus ON HeaderBillgIncompletionStatus = _HeaderBillgIncompletionStatus.HeaderBillgIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_OvrlItmGenIncompletionSts AS _OvrlItmGeneralIncompletionSts ON OvrlItmGeneralIncompletionSts = _OvrlItmGeneralIncompletionSts.OvrlItmGeneralIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_OvrlItmBillgIncompltnSts AS _OvrlItmBillingIncompletionSts ON OvrlItmBillingIncompletionSts = _OvrlItmBillingIncompletionSts.OvrlItmBillingIncompletionSts  -- association [0..1]
;