R_DFS_RelocationStepPlanningTP

DDL: R_DFS_RELOCATIONSTEPPLANNINGTP Type: view_entity TRANSACTIONAL
69 Fields 1 Data Sources 7 Associations

List for Relocation Step Planning

R_DFS_RelocationStepPlanningTP is a Transactional CDS View that provides data about "List for Relocation Step Planning" in SAP S/4HANA. It reads from 1 data source (I_DFS_RelocationStepPlanning) and exposes 69 fields with key field DefenseRelocationStepPlngUUID. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DFS_RelocationStepPlanning _RelocationStepPlanning from

Associations (7)

CardinalityTargetAliasCondition
[0..*] R_DFS_RelocationProdPlanningTP _ModelsOfFMPOVariant $projection.DefenseRelocationPlanningUUID = _ModelsOfFMPOVariant.DefenseRelocationPlanningUUID and $projection.FlxblMatlPlngObjectID = _ModelsOfFMPOVariant.FlxblMatlPlngObjectID and $projection.FlxblMatlPlngObjVariantID = _ModelsOfFMPOVariant.FlxblMatlPlngObjVariantID
[0..*] R_DFS_RelocAccogPrtProdPlngTP _ACPModelsOfFMPOVariant $projection.DefenseRelocationPlanningUUID = _ACPModelsOfFMPOVariant.DefenseRelocationPlanningUUID and $projection.FlxblMatlPlngObjectID = _ACPModelsOfFMPOVariant.FlxMtPlObjVarAccogPrtRefObjID and $projection.FlxblMatlPlngObjVariantID = _ACPModelsOfFMPOVariant.FlxMtPlObjVarAccogPrtRefVarID
[0..*] R_DFS_RelocAccogProductPlngTP _AccogProdsOfFlxMtPlObjVar $projection.DefenseRelocationPlanningUUID = _AccogProdsOfFlxMtPlObjVar.DefenseRelocationPlanningUUID and $projection.FlxblMatlPlngObjectID = _AccogProdsOfFlxMtPlObjVar.FlxblMatlPlngObjectID and $projection.FlxblMatlPlngObjVariantID = _AccogProdsOfFlxMtPlObjVar.FlxblMatlPlngObjVariantID
[0..1] E_DFS_RelocationStepPlanning _Extension $projection.DefenseRelocationStepPlngUUID = _Extension.DefenseRelocationStepPlngUUID
[0..*] R_DFS_RelocationProdPlanningTP _RelocationProdPlanningTP
[0..*] R_DFS_RelocAccogPrtProdPlngTP _RelocAccogPrtProdPlngTP
[0..*] R_DFS_RelocAccogProductPlngTP _RelocAccogProductPlngTP

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label List for Relocation Step Planning view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey DefenseRelocationStepPlngUUID view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY DefenseRelocationStepPlngUUID DefenseRelocationStepPlngUUID Reloc Step Plng GUID
DefenseRelocationPlanningUUID DefenseRelocationPlanningUUID Reloc Planning GUID
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID _WBSElement WBSElementExternalID WBS Element External ID
DfsRelocationNmbrOfAssgdMatl DfsRelocationNmbrOfAssgdMatl Relocation Quantity
ForceElementOrgID _RelocationPlanningTP ForceElementOrgID Object ID Processor
WBSElementParentInternalID _RelocationPlanningTP WBSElementInternalID WBS Internal ID
FlxblMatlPlngObjectUUID FlxblMatlPlngObjectUUID FMPO UUID
FlxblMatlPlngObjVariantUUID FlxblMatlPlngObjVariantUUID Variant UUID
FlxblMatlPlngObjectID FlxblMatlPlngObjectID FMPO ID
FlxblMatlPlngObjVariantID FlxblMatlPlngObjVariantID Variant ID
DfsAssgmtUUID DfsAssgmtUUID Assigment GUID
DfsAssgmtSubUUID DfsAssgmtSubUUID Assigment GUID
DfsRelocationIsAssgmtInactive DfsRelocationIsAssgmtInactive TRUE
DfsRelocationIsAssgmtDeleted DfsRelocationIsAssgmtDeleted TRUE
DfsAssgmtIsSubAssignment DfsAssgmtIsSubAssignment
DfsAssgmtNmbrOfAssgdMatl
DfsAssgmtMinNmbrOfAssgdMatl
DfsAssgmtMaxNmbrOfAssgdMatl
AdjustedAuthzdNmbrOfAssgdMatl
DfsAssgmtMaterialIndicatorCode DfsAssgmtMaterialIndicatorCode Material Indicator
DfsRelocationWBSElementExtID DfsRelocationWBSElementExtID WBS Element External ID
StdWBSDescription StdWBSDescription WBS Element Name
Product Product Product Sold
MaterialGroup MaterialGroup Product Group
PurchaseRequisition PurchaseRequisition Requisition
DfsRelocationDocumentType DfsRelocationDocumentType Reloc. Doc. Type
DfsRelocationWBSElementIntID DfsRelocationWBSElementIntID WBS Internal ID
MaterialBaseUnit MaterialBaseUnit Valuation Unit
ForceElementOrgSrceID ForceElementOrgSrceID Object ID
ForceElementOrgSrceUUID ForceElementOrgSrceUUID GUID 32
FrcElmntOrgStockPlant FrcElmntOrgStockPlant Plant
FrcElmntOrgStockStorageLoc FrcElmntOrgStockStorageLoc Location
FrcElmntOrgMRPStockArea FrcElmntOrgMRPStockArea MRP Stock Area
Batch Batch Lot No.
DfsLogisticsRqmtUrgency DfsLogisticsRqmtUrgency Reqmt Urgency
DefenseLogisticsAdvice DefenseLogisticsAdvice Advice Code
DfsPurchaseRequisitionStatus DfsPurchaseRequisitionStatus StatusCode
ForceElementOrgTargetUUID ForceElementOrgTargetUUID GUID 32
ForceElementOrgTargetID ForceElementOrgTargetID Object ID
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
MRPController MRPController MRP Controller
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_RelocationPlanningTP _RelocationPlanningTP
_RelocationProdPlanningTP _RelocationProdPlanningTP
_UniversalAssignment _UniversalAssignment
_WBSElement _WBSElement
_FlxMtPlObjDescription _FlxMtPlObjDescription
_FlxMtPlObjVarDescription _FlxMtPlObjVarDescription
_ModelsOfFMPOVariant _ModelsOfFMPOVariant
_RelocAccogPrtProdPlngTP _RelocAccogPrtProdPlngTP
_ACPModelsOfFMPOVariant _ACPModelsOfFMPOVariant
_RelocationDocumentType _RelocationDocumentType
_CostElementData _CostElementData
_MaterialIndicator _MaterialIndicator
_StkOnPlntStorLocBatLvl _StkOnPlntStorLocBatLvl
_PurOrdOnPlntStorLocLvl _PurOrdOnPlntStorLocLvl
_PurReqnOnPlntStorLocLvl _PurReqnOnPlntStorLocLvl
_PurchaseRequisitionStsT _PurchaseRequisitionStsT
_LogisticsAdviceText _LogisticsAdviceText
_MRPController _MRPController
_LogisticsRqmtUrgencyText _LogisticsRqmtUrgencyText
_Product _Product
_RelocAccogProductPlngTP _RelocAccogProductPlngTP
_AccogProdsOfFlxMtPlObjVar _AccogProdsOfFlxMtPlObjVar

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 R_DFS_RelocationStepPlanningTP.
-- 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 R_DFS_RelocationStepPlanningTP AS
SELECT
  DefenseRelocationStepPlngUUID,
  DefenseRelocationPlanningUUID,
  WBSElementInternalID,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  DfsRelocationNmbrOfAssgdMatl,
  _RelocationPlanningTP.ForceElementOrgID AS ForceElementOrgID,
  _RelocationPlanningTP.WBSElementInternalID AS WBSElementParentInternalID,
  FlxblMatlPlngObjectUUID,
  FlxblMatlPlngObjVariantUUID,
  FlxblMatlPlngObjectID,
  FlxblMatlPlngObjVariantID,
  DfsAssgmtUUID,
  DfsAssgmtSubUUID,
  DfsRelocationIsAssgmtInactive,
  DfsRelocationIsAssgmtDeleted,
  DfsAssgmtIsSubAssignment,
  cast(_UniversalAssignment.DfsAssgmtNmbrOfAssgdMatl as abap.dec(8,0)) AS DfsAssgmtNmbrOfAssgdMatl,
  cast(_UniversalAssignment.DfsAssgmtMinNmbrOfAssgdMatl as abap.dec(8,0)) AS DfsAssgmtMinNmbrOfAssgdMatl,
  cast(_UniversalAssignment.DfsAssgmtMaxNmbrOfAssgdMatl as abap.dec(8,0)) AS DfsAssgmtMaxNmbrOfAssgdMatl,
  cast(_UniversalAssignment.DfsAssgmtCorrectionValue + cast(_UniversalAssignment.DfsAssgmtNmbrOfAssgdMatl as abap.int8) as abap.int4) AS AdjustedAuthzdNmbrOfAssgdMatl,
  DfsAssgmtMaterialIndicatorCode,
  DfsRelocationWBSElementExtID,
  StdWBSDescription,
  Product,
  MaterialGroup,
  PurchaseRequisition,
  DfsRelocationDocumentType,
  DfsRelocationWBSElementIntID,
  MaterialBaseUnit,
  ForceElementOrgSrceID,
  ForceElementOrgSrceUUID,
  FrcElmntOrgStockPlant,
  FrcElmntOrgStockStorageLoc,
  FrcElmntOrgMRPStockArea,
  Batch,
  DfsLogisticsRqmtUrgency,
  DefenseLogisticsAdvice,
  DfsPurchaseRequisitionStatus,
  ForceElementOrgTargetUUID,
  ForceElementOrgTargetID,
  Plant,
  StorageLocation,
  MRPController,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_DFS_RelocationStepPlanning AS _RelocationStepPlanning
LEFT OUTER JOIN R_DFS_RelocationProdPlanningTP AS _ModelsOfFMPOVariant ON DefenseRelocationPlanningUUID = _ModelsOfFMPOVariant.DefenseRelocationPlanningUUID AND FlxblMatlPlngObjectID = _ModelsOfFMPOVariant.FlxblMatlPlngObjectID AND FlxblMatlPlngObjVariantID = _ModelsOfFMPOVariant.FlxblMatlPlngObjVariantID  -- association [0..*]
LEFT OUTER JOIN R_DFS_RelocAccogPrtProdPlngTP AS _ACPModelsOfFMPOVariant ON DefenseRelocationPlanningUUID = _ACPModelsOfFMPOVariant.DefenseRelocationPlanningUUID AND FlxblMatlPlngObjectID = _ACPModelsOfFMPOVariant.FlxMtPlObjVarAccogPrtRefObjID AND FlxblMatlPlngObjVariantID = _ACPModelsOfFMPOVariant.FlxMtPlObjVarAccogPrtRefVarID  -- association [0..*]
LEFT OUTER JOIN R_DFS_RelocAccogProductPlngTP AS _AccogProdsOfFlxMtPlObjVar ON DefenseRelocationPlanningUUID = _AccogProdsOfFlxMtPlObjVar.DefenseRelocationPlanningUUID AND FlxblMatlPlngObjectID = _AccogProdsOfFlxMtPlObjVar.FlxblMatlPlngObjectID AND FlxblMatlPlngObjVariantID = _AccogProdsOfFlxMtPlObjVar.FlxblMatlPlngObjVariantID  -- association [0..*]
LEFT OUTER JOIN E_DFS_RelocationStepPlanning AS _Extension ON DefenseRelocationStepPlngUUID = _Extension.DefenseRelocationStepPlngUUID  -- association [0..1]
LEFT OUTER JOIN R_DFS_RelocationProdPlanningTP AS _RelocationProdPlanningTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_DFS_RelocAccogPrtProdPlngTP AS _RelocAccogPrtProdPlngTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_DFS_RelocAccogProductPlngTP AS _RelocAccogProductPlngTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More