I_DFS_RelocationPlanningBasic

DDL: I_DFS_RELOCATIONPLANNINGBASIC Type: view_entity BASIC
10 Fields 1 Data Sources

Basic List for Relocation Plan Head

I_DFS_RelocationPlanningBasic is a Basic CDS View that provides data about "Basic List for Relocation Plan Head" in SAP S/4HANA. It reads from 1 data source (dfs_reloc_head) and exposes 10 fields with key field DefenseRelocationPlanningUUID.

Data Sources (1)

SourceAliasJoin Type
dfs_reloc_head dfs_reloc_head from

Annotations (8)

NameValueLevelField
Analytics.technicalName IRELOCPLANBASIC view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Basic List for Relocation Plan Head view
ObjectModel.representativeKey DefenseRelocationPlanningUUID view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DefenseRelocationPlanningUUID defenserelocationplanninguuid Reloc Planning GUID
WBSElementInternalID wbselementinternalid WBS Internal ID
ForceElementOrgUUID forceelementorguuid GUID 32
DfsAssgmtUsageType dfsassgmtusagetype Usage Type
DfsRelocationStepAssgmtType dfsrelocationstepassgmttype Reloc Stp Assgmt Typ
FrcElmntOrgIsHierarchyRelevant frcelmntorgishierarchyrelevant TRUE
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_RelocationPlanningBasic.
-- 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_RelocationPlanningBasic AS
SELECT
  DefenseRelocationPlanningUUID,
  WBSElementInternalID,
  ForceElementOrgUUID,
  DfsAssgmtUsageType,
  DfsRelocationStepAssgmtType,
  FrcElmntOrgIsHierarchyRelevant,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM dfs_reloc_head
;

Learn More