R_DFS_AllwncPlanToFeTP

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_AllwncPlanToFeTP.
-- 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: RALLWNCPLANFETP

CREATE VIEW R_DFS_AllwncPlanToFeTP AS
SELECT
  DfsAllwncPlanUUID,
  ForceElementOrgUUID,
  DfsAllwncPlanAssignedQuantity,
  _AllwncPlanTP.DfsAllwncPlanQuantityUnit AS DfsAllwncPlanQuantityUnit,
  ForceElementOrgTargetUUID,
  ForceElementOrgID,
  DfsFrcElmntIsChangeable,
  _ParentFrcAttrib.ForceElementOrgID AS ForceElementOrgTargetID,
  DfsAllwncPlanIsFollowUpPlan,
  DfsAllwncPlanIsFllwUpPlanAllwd,
  cast( 0 as dfs_allwnc_plan_assgd_qty ) AS DfsAllwncPlanSubQuantity,
  cast('' as stext) AS FrcElmntOrgName,
  cast('' as short_d) AS FrcElmntOrgShortName,
  _FollowUpPlan.DfsAllwncPlanID AS DfsAllwncPlanFollowUpPlanID,
  _FollowUpPlan.DfsAllwncPlanUUID AS DfsAllwncPlanFollowUpPlanUUID,
  FrcElmntOrgUsageType,
  DfsAllwncPlanValdtyStrtDate,
  DfsAllwncPlanValdtyEndDate,
  Product,
  FlxblMatlPlngObjectUUID,
  FlxblMatlPlngObjVariantUUID,
  DfsAllwncPlanChangeDateTime,
  DfsAllwncReqUUID,
  cast( 0 as dfs_allwnc_req_reqd_qty ) AS DfsAllwncReqReqdSubQuantity,
  cast( 0 as dfs_allwnc_req_reqd_qty ) AS DfsAllwncReqReqdQuantity,
  cast( '' as meins ) AS DfsAllwncReqQuantityUnit,
  cast( '' as abap.sstring(1333) ) AS HierarchyNode,
  cast( '' as abap.sstring(1333) ) AS HierarchyParentNode,
  cast( 0 as abap.int4 ) AS HierarchyLevel,
  cast( 0 as abap.int4 ) AS HierarchyDescendantCount,
  cast( 0 as abap.sstring(20) ) AS DrillDownState,
  cast( 0 as abap.int4 ) AS HierarchyNodeOrdinalNumber
FROM I_DFS_AllwncPlanToFe
LEFT OUTER JOIN R_DFS_AllwncPlanTP AS _FollowUpPlan ON DfsAllwncPlanUUID = _FollowUpPlan.DfsAllwncPlanPreviousPlanUUID AND ForceElementOrgUUID = _FollowUpPlan.ForceElementOrgUUID  -- association [1..1]
LEFT OUTER JOIN I_DFS_AllwncReqBasic AS _Request ON DfsAllwncReqUUID = _Request.DfsAllwncReqUUID  -- association [0..1]
;