I_DFS_AllwncPlanToFeBasic

DDL: I_DFS_ALLWNCPLANTOFEBASIC SQL: IDFSALLWNCPLANFB Type: view BASIC

Basic Intf. View Allow. Plan to Fe

I_DFS_AllwncPlanToFeBasic is a Basic CDS View that provides data about "Basic Intf. View Allow. Plan to Fe" in SAP S/4HANA. It reads from 1 data source (dfs_allwnc_pl_fe) and exposes 7 fields with key fields DfsAllwncPlanUUID, ForceElementOrgUUID.

Data Sources (1)

SourceAliasJoin Type
dfs_allwnc_pl_fe dfs_allwnc_pl_fe from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IDFSALLWNCPLANFB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Basic Intf. View Allow. Plan to Fe view
VDM.viewType #BASIC view
ObjectModel.representativeKey DfsAllwncPlanUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY DfsAllwncPlanUUID dfsallwncplanuuid Allowance Plan UUID
KEY ForceElementOrgUUID forceelementorguuid GUID 32
DfsAllwncPlanAssignedQuantity dfsallwncplanassignedquantity Assigned Quantity
ForceElementOrgTargetUUID forceelementorgtargetuuid GUID 32
DfsAllwncPlanIsFollowUpPlan dfsallwncplanisfollowupplan Follow-Up Plan
DfsAllwncPlanIsFllwUpPlanAllwd dfsallwncplanisfllwupplanallwd FUp Allowed
DfsAllwncPlanChangeDateTime dfsallwncplanchangedatetime Time Stamp

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_AllwncPlanToFeBasic.
-- 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.
-- SQL view name: IDFSALLWNCPLANFB

CREATE VIEW I_DFS_AllwncPlanToFeBasic AS
SELECT
  DfsAllwncPlanUUID,
  ForceElementOrgUUID,
  DfsAllwncPlanAssignedQuantity,
  ForceElementOrgTargetUUID,
  DfsAllwncPlanIsFollowUpPlan,
  DfsAllwncPlanIsFllwUpPlanAllwd,
  DfsAllwncPlanChangeDateTime
FROM dfs_allwnc_pl_fe
;