I_DFS_RelocationStepPlngBsc

DDL: I_DFS_RELOCATIONSTEPPLNGBSC Type: view_entity BASIC
36 Fields 1 Data Sources

Basic List for Relocation Step Plan

I_DFS_RelocationStepPlngBsc is a Basic CDS View that provides data about "Basic List for Relocation Step Plan" in SAP S/4HANA. It reads from 1 data source (dfs_reloc_step) and exposes 36 fields with key field DefenseRelocationStepPlngUUID.

Data Sources (1)

SourceAliasJoin Type
dfs_reloc_step dfs_reloc_step from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Basic List for Relocation Step Plan view
ObjectModel.representativeKey DefenseRelocationStepPlngUUID view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY DefenseRelocationStepPlngUUID defenserelocationstepplnguuid Reloc Step Plng GUID
DefenseRelocationPlanningUUID defenserelocationplanninguuid Reloc Planning GUID
WBSElementInternalID wbselementinternalid WBS Internal ID
DfsRelocationNmbrOfAssgdMatl dfsrelocationnmbrofassgdmatl Relocation Quantity
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
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
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
Batch batch Lot No.
DfsLogisticsRqmtUrgency dfslogisticsrqmturgency Reqmt Urgency
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name

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_DFS_RelocationStepPlngBsc.
-- 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 I_DFS_RelocationStepPlngBsc AS
SELECT
  DefenseRelocationStepPlngUUID,
  DefenseRelocationPlanningUUID,
  WBSElementInternalID,
  DfsRelocationNmbrOfAssgdMatl,
  FlxblMatlPlngObjectUUID,
  FlxblMatlPlngObjVariantUUID,
  FlxblMatlPlngObjectID,
  FlxblMatlPlngObjVariantID,
  DfsAssgmtUUID,
  DfsAssgmtSubUUID,
  DfsRelocationIsAssgmtInactive,
  DfsRelocationIsAssgmtDeleted,
  Product,
  MaterialGroup,
  PurchaseRequisition,
  DfsRelocationDocumentType,
  DfsRelocationWBSElementIntID,
  MaterialBaseUnit,
  ForceElementOrgSrceID,
  ForceElementOrgSrceUUID,
  FrcElmntOrgStockPlant,
  FrcElmntOrgStockStorageLoc,
  FrcElmntOrgMRPStockArea,
  DefenseLogisticsAdvice,
  DfsPurchaseRequisitionStatus,
  ForceElementOrgTargetUUID,
  ForceElementOrgTargetID,
  Plant,
  StorageLocation,
  MRPController,
  Batch,
  DfsLogisticsRqmtUrgency,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM dfs_reloc_step
;

Learn More