C_FrcElmntOrgExerciseTP

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_FrcElmntOrgExerciseTP.
-- 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: CFEORGEXERTP

CREATE VIEW C_FrcElmntOrgExerciseTP AS
SELECT
  _FrcElmntOrgExerciseTP.ForceElementOrgID AS ForceElementOrgID,
  _FrcElmntOrgExerciseTP.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  _FrcElmntOrgExerciseTP.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  _FrcElmntOrgExerciseTP.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  _FrcElmntOrgExerciseTP.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  _FrcElmntOrgExerciseTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  _FrcElmntOrgExerciseTP.FrcElmntOrgType AS FrcElmntOrgType,
  _FrcElmntOrgExerciseTP.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  _FrcElmntOrgExerciseTP.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  _FrcElmntOrgExerciseTP.FrcElmntOrgOpExerCategory AS FrcElmntOrgOpExerCategory,
  _FrcElmntOrgExerCategoryVH.FrcElmntOrgOpExerCategoryDesc AS FrcElmntOrgOpExerCategoryDesc,
  _FrcElmntOrgExerciseTP.FrcElmntOrgOpExerSubCategory AS FrcElmntOrgOpExerSubCategory,
  _FrcElmntOrgOpExerSubCatVH.FrcElmntOrgOpExerSubCatDesc AS FrcElmntOrgOpExerSubCatDesc,
  _FrcElmntOrgExerciseTP.FrcElmntOrgOplIntensity AS FrcElmntOrgOplIntensity,
  _FrcElmntOrgOplIntensityVH.FrcElmntOrgOplIntensityDesc AS FrcElmntOrgOplIntensityDesc,
  _FrcElmntOrgExerciseTP.FrcElmntOrgOpExerValdtyStrtDte AS FrcElmntOrgOpExerValdtyStrtDte,
  _FrcElmntOrgExerciseTP.FrcElmntOrgOpExerValdtyEndDate AS FrcElmntOrgOpExerValdtyEndDate,
  _FrcElmntOrgExerciseTP.FrcElmntOrgDescRefNumber AS FrcElmntOrgDescRefNumber,
  _FrcElmntOrgExerciseTP.FrcElmntOrgValdtyStartDateFoEd AS FrcElmntOrgValdtyStartDateFoEd,
  _FrcElmntOrgExerciseTP.FrcElmntOrgValdtyEndDateFoEd AS FrcElmntOrgValdtyEndDateFoEd,
  _FrcElmntOrgClimateVH.FrcElmntOrgClimateDesc AS FrcElmntOrgClimateDesc,
  _FrcElmntOrgTerrainVH.FrcElmntOrgTerrainDesc AS FrcElmntOrgTerrainDesc,
  _FrcElmntOrgWeatherVH.FrcElmntOrgWeatherDesc AS FrcElmntOrgWeatherDesc,
  _FrcElmntOrgExerciseTP.FrcElmntOrgClimateID AS FrcElmntOrgClimateID,
  _FrcElmntOrgExerciseTP.Country AS Country,
  _FrcElmntOrgExerciseTP.FrcElmntOrgTerrainID AS FrcElmntOrgTerrainID,
  _FrcElmntOrgExerciseTP.FrcElmntOrgWeatherID AS FrcElmntOrgWeatherID,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  _SrceFrcElmntOrgTP.FrcElmntOrgName AS FrcElmntOrgName
FROM I_FrcElmntOrgExerciseTP AS _FrcElmntOrgExerciseTP
LEFT OUTER JOIN C_FrcElmntOrgTP AS _FrcElmntOrgTP ON ForceElementOrgID = _FrcElmntOrgTP.ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgVH AS _FrcElmntOrgVH ON ForceElementOrgID = _FrcElmntOrgVH.ForceElementOrgIDForEdit  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON FrcElmntOrgPlngStatus = _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgExerCategoryVH AS _FrcElmntOrgExerCategoryVH ON FrcElmntOrgOpExerCategory = _FrcElmntOrgExerCategoryVH.FrcElmntOrgOpExerCategory  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgOpExerSubCatVH AS _FrcElmntOrgOpExerSubCatVH ON FrcElmntOrgOpExerSubCategory = _FrcElmntOrgOpExerSubCatVH.FrcElmntOrgOpExerSubCategory AND FrcElmntOrgOpExerCategory = _FrcElmntOrgOpExerSubCatVH.FrcElmntOrgOpExerCategory  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgOplIntensityVH AS _FrcElmntOrgOplIntensityVH ON FrcElmntOrgOplIntensity = _FrcElmntOrgOplIntensityVH.FrcElmntOrgOplIntensity  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgClimateVH AS _FrcElmntOrgClimateVH ON FrcElmntOrgClimateID = _FrcElmntOrgClimateVH.FrcElmntOrgClimateID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgTerrainVH AS _FrcElmntOrgTerrainVH ON FrcElmntOrgTerrainID = _FrcElmntOrgTerrainVH.FrcElmntOrgTerrainID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgWeatherVH AS _FrcElmntOrgWeatherVH ON FrcElmntOrgWeatherID = _FrcElmntOrgWeatherVH.FrcElmntOrgWeatherID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntSuplmntyAttribAssgmt AS _SrceFrcElmntOrgTP ON ForceElementOrgID = _SrceFrcElmntOrgTP.ForceElementOrgID  -- association [0..1]
;