C_MassChangeSlsDocReadRequest

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_MassChangeSlsDocReadRequest.
-- 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.

CREATE VIEW C_MassChangeSlsDocReadRequest AS
SELECT
  MCCReq.SlsDocMassChangeRequestUUID AS SlsDocMassChangeRequestUUID,
  _SalesDocument.SalesGroup AS SalesGroup,
  cast( '' as boole_d ) AS UICT_SalesGroup,
  _SalesDocument._SalesGroup._Text[1:Language = $session.system_language].SalesGroupName AS SalesGroupName,
  SDDocumentCategory,
  _SalesDocument.SalesOffice AS SalesOffice,
  cast( '' as boole_d ) AS UICT_SalesOffice,
  _SalesDocument._SalesOffice._Text[1:Language = $session.system_language].SalesOfficeName AS SalesOfficeName,
  _SalesDocument.SalesDistrict AS SalesDistrict,
  cast( '' as boole_d ) AS UICT_SalesDistrict,
  _SalesDocument._SalesDistrict._Text[1:Language = $session.system_language].SalesDistrictName AS SalesDistrictName,
  _SalesDocument.RequestedDeliveryDate AS RequestedDeliveryDate,
  cast( '' as boole_d ) AS UICT_RequestedDeliveryDate,
  _SalesDocument.ShippingCondition AS ShippingCondition,
  cast( '' as boole_d ) AS UICT_ShippingCondition,
  _SalesDocument._ShippingCondition._Text[1:Language = $session.system_language].ShippingConditionName AS ShippingConditionName,
  _SalesDocument.IncotermsClassification AS IncotermsClassification,
  cast( '' as boole_d ) AS UICT_IncotermsClassification,
  _SalesDocument._IncotermsClassification._Text[1:Language = $session.system_language].IncotermsClassificationName AS IncotermsClassificationName,
  _SalesDocument.IncotermsTransferLocation AS IncotermsTransferLocation,
  cast( '' as boole_d ) AS UICT_IncotermsTransferLocation,
  _SalesDocument.IncotermsLocation1 AS IncotermsLocation1,
  cast( '' as boole_d ) AS UICT_IncotermsLocation1,
  _SalesDocument.IncotermsLocation2 AS IncotermsLocation2,
  cast( '' as boole_d ) AS UICT_IncotermsLocation2,
  _SalesDocument.IncotermsVersion AS IncotermsVersion,
  cast( '' as boole_d ) AS UICT_IncotermsVersion,
  _SalesDocument._IncotermsVersion._Text[1:Language = $session.system_language].IncotermsVersionName AS IncotermsVersionName,
  _SalesDocument.DeliveryBlockReason AS DeliveryBlockReason,
  _SalesDocument.ShippingType AS ShippingType,
  cast( '' as boole_d ) AS UICT_ShippingType,
  _SalesDocument._ShippingType._Text[1:Language = $session.system_language].ShippingTypeName AS ShippingTypeName,
  _SalesDocument.ReceivingPoint AS ReceivingPoint,
  cast( '' as boole_d ) AS UICT_ReceivingPoint,
  _SalesDocument.PricingDate AS PricingDate,
  cast( '' as boole_d ) AS UICT_PricingDate,
  _SalesDocument.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  _SalesDocument.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  cast( '' as boole_d ) AS UICT_PurchaseOrderByCustomer,
  _SalesDocument.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  _SalesDocument.TransactionCurrency AS TransactionCurrency,
  cast( '' as boole_d ) AS UICT_TransactionCurrency,
  _SalesDocument._TransactionCurrency._Text[1:Language = $session.system_language].CurrencyName AS CurrencyName,
  _SalesDocument.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  _SalesDocument.BillingDocumentDate AS BillingDocumentDate,
  cast( '' as boole_d ) AS UICT_BillingDocumentDate,
  _SalesDocument.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  _SalesDocument.SalesDocumentDate AS SalesDocumentDate,
  cast( '' as boole_d ) AS UICT_SalesDocumentDate,
  _SalesDocument.SDDocumentReason AS SDDocumentReason,
  cast( '' as boole_d ) AS UICT_SDDocumentReason,
  _SalesDocument._SDDocumentReason._Text[1:Language = $session.system_language].SDDocumentReasonText AS SDDocumentReasonText,
  _SalesDocument.CustomerPaymentTerms AS CustomerPaymentTerms,
  cast( '' as boole_d ) AS UICT_CustomerPaymentTerms,
  _SalesDocument._CustomerPaymentTerms._Text[1:Language = $session.system_language].CustomerPaymentTermsName AS CustomerPaymentTermsName,
  _SalesDocument.PaymentMethod AS PaymentMethod,
  cast( '' as boole_d ) AS UICT_PaymentMethod,
  _SalesDocumentItem.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  cast( '' as boole_d ) AS UICT_SalesDocumentItemCategory,
  _SalesDocumentItem._ItemCategory._Text[1:Language = $session.system_language].SalesDocumentItemCategoryName AS SalesDocumentItemCategoryName,
  cast (_SalesDocumentItem.Product as productnumber preserving type ) AS Product,
  cast( '' as boole_d ) AS UICT_Product,
  _SalesDocumentItem._Product._Text[1:Language = $session.system_language].ProductName AS ProductName,
  _SalesDocumentItem.SalesDocumentItemText AS SalesDocumentItemText,
  cast( '' as boole_d ) AS UICT_SalesDocumentItemText,
  _SalesDocumentItem.ProductHierarchyNode AS ProductHierarchyNode,
  cast( '' as boole_d ) AS UICT_ProductHierarchyNode,
  _SalesDocumentItem.Batch AS Batch,
  cast( '' as boole_d ) AS UICT_Batch,
  _SalesDocumentItem.Plant AS Plant,
  cast( '' as boole_d ) AS UICT_Plant,
  _SalesDocumentItem._Plant.PlantName AS PlantName,
  _SalesDocumentItem.StorageLocation AS StorageLocation,
  cast( '' as boole_d ) AS UICT_StorageLocation,
  _SalesDocumentItem._StorageLocation.StorageLocationName AS StorageLocationName,
  _SalesDocumentItem.Division AS Division,
  cast( '' as boole_d ) AS UICT_Division,
  _SalesDocumentItem._Division._Text[1:Language = $session.system_language].DivisionName AS DivisionName,
  _SalesDocumentItem.ShippingPoint AS ShippingPoint,
  cast( '' as boole_d ) AS UICT_ShippingPoint,
  _SalesDocumentItem._ShippingPoint._Text[1:Language = $session.system_language].ShippingPointName AS ShippingPointName,
  _SalesDocumentItem.DeliveryPriority AS DeliveryPriority,
  cast( '' as boole_d ) AS UICT_DeliveryPriority,
  _SalesDocumentItem._DeliveryPriority._Text[1:Language = $session.system_language].DeliveryPriorityDesc AS DeliveryPriorityDesc,
  _SalesDocumentItem.Route AS Route,
  cast( '' as boole_d ) AS UICT_Route,
  _SalesDocumentItem._Route._Text[1:Language = $session.system_language].RouteName AS RouteName,
  _SalesDocumentItem.UnloadingPointName AS UnloadingPointName,
  cast( '' as boole_d ) AS UICT_UnloadingPointName,
  _SalesDocumentItem.ItemBillingBlockReason AS ItemBillingBlockReason,
  _SalesDocumentItem.ExpdDelivQuantityChangeReason AS ExpdDelivQuantityChangeReason,
  _SalesDocumentItem.ReturnReason AS ReturnReason,
  _SalesDocumentItem.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity,
  _SalesDocumentItem.WBSElementExternalID AS WBSElementExternalID,
  _SalesDocumentItem._WBSElementExternalID.WBSDescription AS WBSDescription,
  cast( '' as boole_d ) AS UICT_WBSElementExternalID,
  _SalesDocumentItem.MaterialByCustomer AS MaterialByCustomer,
  _SalesDocumentItem.PricingType AS PricingType,
  _SalesDocumentItem.ProfitCenter AS ProfitCenter,
  cast(' ' as abap.char( 100 ) ) AS ProfitCenterName,
  cast( '' as boole_d ) AS UICT_ProfitCenter
FROM I_SDMassChgCkptMassChgReqBsc AS MCCReq
LEFT OUTER JOIN I_SDMassChgCkptSlsDocHdrChg AS _SalesDocument ON SlsDocMassChangeRequestUUID = _SalesDocument.SlsDocMassChangeRequestUUID  -- association [0..1]
LEFT OUTER JOIN I_SDMassChgCkptSlsDocItemChg AS _SalesDocumentItem ON SlsDocMassChangeRequestUUID = _SalesDocumentItem.SlsDocMassChangeRequestUUID  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentReason AS _SDDocumentReason ON SDDocumentReason = _SDDocumentReason.SDDocumentReason  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_ShippingType AS _ShippingType ON ShippingType = _ShippingType.ShippingType  -- association [0..1]
LEFT OUTER JOIN I_ShippingCondition AS _ShippingCondition ON ShippingCondition = _ShippingCondition.ShippingCondition  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _IncotermsVersion ON IncotermsVersion = _IncotermsVersion.IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _CustomerPaymentTerms ON CustomerPaymentTerms = _CustomerPaymentTerms.CustomerPaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryBlockReason ON DeliveryBlockReason = _DeliveryBlockReason.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _HeaderBillingBlockReason ON HeaderBillingBlockReason = _HeaderBillingBlockReason.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentRjcnReason AS _SalesDocumentRjcnReason ON SalesDocumentRjcnReason = _SalesDocumentRjcnReason.SalesDocumentRjcnReason  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemCategory AS _ItemCategory ON SalesDocumentItemCategory = _ItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductHierarchyNode AS _ProductHierarchyNode ON ProductHierarchyNode = _ProductHierarchyNode.ProductHierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Plant = _Batch.Plant AND Product = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_DeliveryPriority AS _DeliveryPriority ON DeliveryPriority = _DeliveryPriority.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_Route AS _Route ON Route = _Route.Route  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _ItemBillingBlockReason ON ItemBillingBlockReason = _ItemBillingBlockReason.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_ExpdDelivQtyChangeReason AS _ExpdDelivQtyChangeReason ON ExpdDelivQuantityChangeReason = _ExpdDelivQtyChangeReason.ExpdDelivQuantityChangeReason  -- association [0..1]
LEFT OUTER JOIN I_ReturnReason AS _ReturnReason ON ReturnReason = _ReturnReason.ReturnReason  -- association [0..1]
LEFT OUTER JOIN I_RepricingPricingType AS _PricingType ON PricingType = _PricingType.PricingType  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN E_SDMassChgCkptSlsDocHdrChgBsc AS _HeaderExtension ON SlsDocMassChangeRequestUUID = _HeaderExtension.SlsDocMassChangeRequestUUID  -- association [0..1]
LEFT OUTER JOIN E_SDMassChgCkptSlsDocItmChgBsc AS _ItemExtension ON SlsDocMassChangeRequestUUID = _ItemExtension.SlsDocMassChangeRequestUUID  -- association [0..1]
;