C_FrcElmntOrgCharcsTP

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 C_FrcElmntOrgCharcsTP.
-- 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: CFEORGCHARCSTP

CREATE VIEW C_FrcElmntOrgCharcsTP AS
SELECT
  FrcElmntOrgCharcsTP.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntOrgCharcsTP.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgCharcsTP.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgCharcsTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntOrgCharcsTP.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntOrgCharcsTP.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntOrgCharcsTP.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntOrgCharcsTP.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntOrgCharcsTP.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  _FrcElmntOrgActyVH.FrcElmntOrgActivityDesc AS FrcElmntOrgActivityDesc,
  _FrcElmntOrgSrvcTypeVH.FrcElmntOrgServiceTypeDesc AS FrcElmntOrgServiceTypeDesc,
  FrcElmntOrgCharcsTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  _FrcElmntOrgStrucTypeVH.FrcElmntOrgStrucLevelDesc AS FrcElmntOrgStrucLevelDesc,
  cast ( ' ' as abap.char(35) ) AS FrcElmntOrgStrucTypeDesc,
  _FrcElmntOrgCntryVH.FrcElmntOrgCountryName AS FrcElmntOrgCountryName,
  FrcElmntOrgCharcsTP.FrcElmntOrgCountry AS FrcElmntOrgCountry,
  FrcElmntOrgCharcsTP.FrcElmntOrgArea AS FrcElmntOrgArea,
  _FrcElmntOrgAreaVH.FrcElmntOrgAreaDesc AS FrcElmntOrgAreaDesc,
  _FrcElmntOrgBrnchAdditionVH.FrcElmntOrgBranchAdditionDesc AS FrcElmntOrgBranchAdditionDesc,
  _FrcElmntOrgBrnchVH.FrcElmntOrgBranchName AS FrcElmntOrgBranchName,
  _FrcElmntOrgAreaTypeVH.FrcElmntOrgAreaTypeName AS FrcElmntOrgAreaTypeName,
  FrcElmntOrgCharcsTP.FrcElmntOrgStrucType AS FrcElmntOrgStrucType,
  FrcElmntOrgCharcsTP.FrcElmntOrgStrucLevel AS FrcElmntOrgStrucLevel,
  FrcElmntOrgCharcsTP.FrcElmntOrgStrucLevelForEdit AS FrcElmntOrgStrucLevelForEdit,
  FrcElmntOrgCharcsTP.FrcElmntOrgBranch AS FrcElmntOrgBranch,
  FrcElmntOrgCharcsTP.FrcElmntOrgUsageType AS FrcElmntOrgUsageType,
  FrcElmntOrgCharcsTP.FrcElmntOrgIsAgency AS FrcElmntOrgIsAgency,
  FrcElmntOrgCharcsTP.FrcElmntOrgAreaType AS FrcElmntOrgAreaType,
  FrcElmntOrgCharcsTP.FrcElmntOrgBranchAddition AS FrcElmntOrgBranchAddition,
  FrcElmntOrgCharcsTP.FrcElmntOrgSymbol AS FrcElmntOrgSymbol,
  FrcElmntOrgCharcsTP.FrcElmntOrgUIC AS FrcElmntOrgUIC,
  FrcElmntOrgCharcsTP.FrcElmntOrgReferenceID AS FrcElmntOrgReferenceID,
  FrcElmntOrgCharcsTP.FrcElmntOrgActivity AS FrcElmntOrgActivity,
  FrcElmntOrgCharcsTP.FrcElmntOrgServiceType AS FrcElmntOrgServiceType,
  FrcElmntOrgCharcsTP.FrcElmntOrgUICParagraph AS FrcElmntOrgUICParagraph,
  cast ( ' ' as abap.char(3) ) AS FrcElmntOrgCnctntdOrgAreaText,
  FrcElmntOrgCharcsTP.FrcElmntOrgValdtyStartDateFoEd AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntOrgCharcsTP.FrcElmntOrgValdtyEndDateFoEd AS FrcElmntOrgValdtyEndDateFoEd,
  cast ( ' ' as abap.char(35) ) AS FrcElmntStrucLevelDesc,
  _FrcElmntOrgStrucParentVH.FrcElmntOrgName AS FrcElmntOrgName
FROM I_FrcElmntOrgCharcsTP AS FrcElmntOrgCharcsTP
LEFT OUTER JOIN C_FrcElmntOrgTP AS _FrcElmntOrgTP ON _FrcElmntOrgTP.ForceElementOrgID = ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgStrucTypeVH AS _FrcElmntOrgStrucTypeVH ON _FrcElmntOrgStrucTypeVH.FrcElmntOrgStrucType = FrcElmntOrgStrucType AND _FrcElmntOrgStrucTypeVH.FrcElmntOrgCountry = FrcElmntOrgCountry AND _FrcElmntOrgStrucTypeVH.FrcElmntOrgArea = FrcElmntOrgArea AND _FrcElmntOrgStrucTypeVH.FrcElmntOrgStrucLevel = FrcElmntOrgStrucLevelForEdit AND _FrcElmntOrgStrucTypeVH.FrcElmntOrgAreaType = FrcElmntOrgAreaType  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgBrnchAdditionVH AS _FrcElmntOrgBrnchAdditionVH ON _FrcElmntOrgBrnchAdditionVH.FrcElmntOrgBranchAddition = FrcElmntOrgBranchAddition AND _FrcElmntOrgBrnchAdditionVH.FrcElmntOrgCountry = FrcElmntOrgCountry AND _FrcElmntOrgBrnchAdditionVH.FrcElmntOrgBranch = FrcElmntOrgBranch AND _FrcElmntOrgBrnchAdditionVH.FrcElmntOrgArea = FrcElmntOrgArea  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgBrnchVH AS _FrcElmntOrgBrnchVH ON _FrcElmntOrgBrnchVH.FrcElmntOrgBranch = FrcElmntOrgBranch AND _FrcElmntOrgBrnchVH.FrcElmntOrgCountry = FrcElmntOrgCountry AND _FrcElmntOrgBrnchVH.FrcElmntOrgArea = FrcElmntOrgArea  -- association [0..1]
LEFT OUTER JOIN C_FrcElmntOrgAreaVH AS _FrcElmntOrgAreaVH ON _FrcElmntOrgAreaVH.FrcElmntOrgArea = FrcElmntOrgArea AND _FrcElmntOrgAreaVH.FrcElmntOrgCountry = FrcElmntOrgCountry  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgAreaVH AS _FrcElmntOrgAreaTypeVH ON _FrcElmntOrgAreaTypeVH.FrcElmntOrgArea = FrcElmntOrgArea AND _FrcElmntOrgAreaTypeVH.FrcElmntOrgCountry = FrcElmntOrgCountry AND _FrcElmntOrgAreaTypeVH.FrcElmntOrgAreaType = FrcElmntOrgAreaType  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgCntryVH AS _FrcElmntOrgCntryVH ON _FrcElmntOrgCntryVH.FrcElmntOrgCountry = FrcElmntOrgCountry  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgActyVH AS _FrcElmntOrgActyVH ON _FrcElmntOrgActyVH.FrcElmntOrgActivity = FrcElmntOrgActivity AND _FrcElmntOrgActyVH.FrcElmntOrgArea = FrcElmntOrgArea  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgSrvcTypeVH AS _FrcElmntOrgSrvcTypeVH ON _FrcElmntOrgSrvcTypeVH.FrcElmntOrgServiceType = FrcElmntOrgServiceType AND _FrcElmntOrgSrvcTypeVH.FrcElmntOrgArea = FrcElmntOrgArea  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgNodeInfo AS _FrcElmntOrgStrucParentVH ON _FrcElmntOrgStrucParentVH.ForceElementOrgID = ForceElementOrgID  -- association [1..1]
;