C_DFS_RelocStockStepPlngTP

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_DFS_RelocStockStepPlngTP.
-- 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_DFS_RelocStockStepPlngTP AS
SELECT
  DefenseRelocationStepPlngUUID,
  DefenseRelocationPlanningUUID,
  WBSElementInternalID,
  _RelocationPlanningTP.WBSElementInternalID AS WBSElementParentInternalID,
  WBSElementExternalID,
  _WBSElement.WBSDescription AS WBSDescription,
  _WBSElement.BasicStartDate AS BasicStartDate,
  _WBSElement.BasicEndDate AS BasicEndDate,
  ForceElementOrgID,
  virtual FrcElmntOrgName : stext AS virtualFrcElmntOrgNamestext,
  DfsRelocationNmbrOfAssgdMatl,
  Product,
  _Product._Text.MaterialName as ProductName : localized AS MaterialNameasProductNamelocalized,
  MaterialGroup,
  PurchaseRequisition,
  DfsRelocationDocumentType,
  _RelocationDocumentType._Text.DfsRelocationDocumentTypeName : localized AS DfsRelocationDocumentTypeNamelocalized,
  DfsRelocationWBSElementExtID,
  DfsRelocationWBSElementIntID,
  StdWBSDescription,
  MaterialBaseUnit,
  ForceElementOrgSrceID,
  ForceElementOrgSrceUUID,
  FrcElmntOrgStockPlant,
  FrcElmntOrgStockStorageLoc,
  FrcElmntOrgMRPStockArea,
  _StkOnPlntStorLocBatLvl[1:InventoryStockType='01'].MatlWrhsStkQtyInMatlBaseUnit AS UnrestrictedStkInStkUnit,
  _StkOnPlntStorLocBatLvl[1:InventoryStockType='02'].MatlWrhsStkQtyInMatlBaseUnit AS QualityInspectionStockQuantity,
  _StkOnPlntStorLocBatLvl[1:InventoryStockType='06'].MatlWrhsStkQtyInMatlBaseUnit AS StockInTransitQuantity,
  _StkOnPlntStorLocBatLvl[1:InventoryStockType='07'].MatlWrhsStkQtyInMatlBaseUnit AS BlockedStockQuantity,
  _StkOnPlntStorLocBatLvl[1:InventoryStockType='08'].MatlWrhsStkQtyInMatlBaseUnit AS RestrictedStockQuantity,
  _PurOrdOnPlntStorLocLvl.OrderQuantity AS OrderQuantity,
  _PurReqnOnPlntStorLocLvl.RequestedQuantity AS RequestedQuantity,
  DefenseLogisticsAdvice,
  _LogisticsAdviceText[1:Language = $session.system_language].DefenseLogisticsAdviceText AS DefenseLogisticsAdviceText,
  DfsPurchaseRequisitionStatus,
  _PurchaseRequisitionStsT[1:Language = $session.system_language].DfsPurchaseRequisitionStsTxt AS DfsPurchaseRequisitionStsTxt,
  ForceElementOrgTargetUUID,
  ForceElementOrgTargetID,
  Plant,
  StorageLocation,
  MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  Batch,
  DfsLogisticsRqmtUrgency,
  _LogisticsRqmtUrgencyText[1:Language = $session.system_language].DfsLogisticsRqmtUrgencyText AS DfsLogisticsRqmtUrgencyText,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM R_DFS_RelocationStepPlanningTP
;