C_FrcElmntOrgRefOrgReadinessTP

DDL: C_FRCELMNTORGREFORGREADINESSTP SQL: CFEORGREFRDNSSTP Type: view CONSUMPTION
31 Fields 1 Data Sources 6 Associations

View of Reference Force Element Organization Readiness

C_FrcElmntOrgRefOrgReadinessTP is a Consumption CDS View that provides data about "View of Reference Force Element Organization Readiness" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntOrgReadinessTP) and exposes 31 fields with key fields ForceElementOrgID, FrcElmntOrgValdtyStartDate, FrcElmntOrgValdtyEndDate, FrcElmntOrgPlanVersion, FrcElmntOrgType. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntOrgReadinessTP FrcElmntOrgReadinessTP from

Associations (6)

CardinalityTargetAliasCondition
[1..1] C_FrcElmntOrgRefOrgTP _FrcElmntOrgTP _FrcElmntOrgTP.ForceElementOrgID = $projection.ForceElementOrgID
[1..1] C_FrcElmntOrgClassfctnVH _FrcElmntOrgClassfctnVH _FrcElmntOrgClassfctnVH.FrcElmntOrgArmedFrcClsfctn = $projection.FrcElmntOrgArmedFrcClsfctn
[1..1] C_FrcElmntOrgRdnssVH _FrcElmntOrgRdnssVH _FrcElmntOrgRdnssVH.FrcElmntOrgReadiness = $projection.FrcElmntOrgReadiness
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.FrcElmntOrgPlngStatus
[1..1] C_FrcElmntOrgActyStsVH _FrcElmntOrgActyStsVH _FrcElmntOrgActyStsVH.FrcElmntOrgActivitySts = $projection.FrcElmntOrgActivitySts
[1..1] C_FrcElmntOrgActyCmpltdVH _FrcElmntOrgActyCmpltdVH _FrcElmntOrgActyCmpltdVH.FrcElmntOrgActyCmpltd = $projection.FrcElmntOrgActyCmpltd

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CFEORGREFRDNSSTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label View of Reference Force Element Organization Readiness view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
Metadata.allowExtensions true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ForceElementOrgID I_FrcElmntOrgReadinessTP ForceElementOrgID Object ID Processor
KEY FrcElmntOrgValdtyStartDate I_FrcElmntOrgReadinessTP FrcElmntOrgValdtyStartDate Start date
KEY FrcElmntOrgValdtyEndDate I_FrcElmntOrgReadinessTP FrcElmntOrgValdtyEndDate End Date
KEY FrcElmntOrgPlanVersion I_FrcElmntOrgReadinessTP FrcElmntOrgPlanVersion Plan version
KEY FrcElmntOrgType I_FrcElmntOrgReadinessTP FrcElmntOrgType Object type
KEY FrcElmntOrgSubType I_FrcElmntOrgReadinessTP FrcElmntOrgSubType Subtype
KEY FrcElmntOrgPlngStatus I_FrcElmntOrgReadinessTP FrcElmntOrgPlngStatus Planning status
KEY NumberOfForceElementOrg I_FrcElmntOrgReadinessTP NumberOfForceElementOrg IT record no.
FrcElmntOrgInfoType I_FrcElmntOrgReadinessTP FrcElmntOrgInfoType Infotype
FrcElmntOrgArmedFrcClsfctnDesc _FrcElmntOrgClassfctnVH FrcElmntOrgArmedFrcClsfctnDesc
FrcElmntOrgReadinessDesc _FrcElmntOrgRdnssVH FrcElmntOrgReadinessDesc
FrcElmntOrgPlngStatusName _FrcElmntOrgPlngStsVH FrcElmntOrgPlngStatusName Planning Status
FrcElmntOrgActivityStsDesc _FrcElmntOrgActyStsVH FrcElmntOrgActivityStsDesc
FrcElmntOrgActyCmpltdDesc _FrcElmntOrgActyCmpltdVH FrcElmntOrgActyCmpltdDesc
FrcElmntOrgArmedFrcClsfctn I_FrcElmntOrgReadinessTP FrcElmntOrgArmedFrcClsfctn
FrcElmntOrgActivitySts I_FrcElmntOrgReadinessTP FrcElmntOrgActivitySts
FrcElmntOrgActyCmpltd I_FrcElmntOrgReadinessTP FrcElmntOrgActyCmpltd
FrcElmntOrgActyCmpltdDate I_FrcElmntOrgReadinessTP FrcElmntOrgActyCmpltdDate
FrcElmntOrgReadiness I_FrcElmntOrgReadinessTP FrcElmntOrgReadiness
FrcElmntOrgMatlRdnssPct _FrcElmntOrgTP FrcElmntOrgMatlRdnssPct Readiness (Material)
FrcElmntOrgPrsnlRdnssPct _FrcElmntOrgTP FrcElmntOrgPrsnlRdnssPct Readiness (Prsnl)
FrcElmntOrgTrngRdnssPct _FrcElmntOrgTP FrcElmntOrgTrngRdnssPct Readiness (Training)
FrcElmntOrgValdtyStartDateFoEd FrcElmntOrgValdtyStartDateFoEd Start date
FrcElmntOrgValdtyEndDateFoEd FrcElmntOrgValdtyEndDateFoEd End Date
FrcElmntOrgPlngStsCritlty I_FrcElmntOrgReadinessTP FrcElmntOrgPlngStsCritlty
_FrcElmntOrgTP _FrcElmntOrgTP
_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH
_FrcElmntOrgRdnssVH _FrcElmntOrgRdnssVH
_FrcElmntOrgClassfctnVH _FrcElmntOrgClassfctnVH
_FrcElmntOrgActyStsVH _FrcElmntOrgActyStsVH
_FrcElmntOrgActyCmpltdVH _FrcElmntOrgActyCmpltdVH

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_FrcElmntOrgRefOrgReadinessTP.
-- 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: CFEORGREFRDNSSTP

CREATE VIEW C_FrcElmntOrgRefOrgReadinessTP AS
SELECT
  FrcElmntOrgReadinessTP.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntOrgReadinessTP.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgReadinessTP.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgReadinessTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntOrgReadinessTP.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntOrgReadinessTP.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  FrcElmntOrgReadinessTP.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntOrgReadinessTP.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntOrgReadinessTP.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  _FrcElmntOrgClassfctnVH.FrcElmntOrgArmedFrcClsfctnDesc AS FrcElmntOrgArmedFrcClsfctnDesc,
  _FrcElmntOrgRdnssVH.FrcElmntOrgReadinessDesc AS FrcElmntOrgReadinessDesc,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  _FrcElmntOrgActyStsVH.FrcElmntOrgActivityStsDesc AS FrcElmntOrgActivityStsDesc,
  _FrcElmntOrgActyCmpltdVH.FrcElmntOrgActyCmpltdDesc AS FrcElmntOrgActyCmpltdDesc,
  FrcElmntOrgReadinessTP.FrcElmntOrgArmedFrcClsfctn AS FrcElmntOrgArmedFrcClsfctn,
  FrcElmntOrgReadinessTP.FrcElmntOrgActivitySts AS FrcElmntOrgActivitySts,
  FrcElmntOrgReadinessTP.FrcElmntOrgActyCmpltd AS FrcElmntOrgActyCmpltd,
  FrcElmntOrgReadinessTP.FrcElmntOrgActyCmpltdDate AS FrcElmntOrgActyCmpltdDate,
  FrcElmntOrgReadinessTP.FrcElmntOrgReadiness AS FrcElmntOrgReadiness,
  _FrcElmntOrgTP.FrcElmntOrgMatlRdnssPct AS FrcElmntOrgMatlRdnssPct,
  _FrcElmntOrgTP.FrcElmntOrgPrsnlRdnssPct AS FrcElmntOrgPrsnlRdnssPct,
  _FrcElmntOrgTP.FrcElmntOrgTrngRdnssPct AS FrcElmntOrgTrngRdnssPct,
  FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntOrgReadinessTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty
FROM I_FrcElmntOrgReadinessTP AS FrcElmntOrgReadinessTP
LEFT OUTER JOIN C_FrcElmntOrgRefOrgTP AS _FrcElmntOrgTP ON _FrcElmntOrgTP.ForceElementOrgID = ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgClassfctnVH AS _FrcElmntOrgClassfctnVH ON _FrcElmntOrgClassfctnVH.FrcElmntOrgArmedFrcClsfctn = FrcElmntOrgArmedFrcClsfctn  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgRdnssVH AS _FrcElmntOrgRdnssVH ON _FrcElmntOrgRdnssVH.FrcElmntOrgReadiness = FrcElmntOrgReadiness  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgActyStsVH AS _FrcElmntOrgActyStsVH ON _FrcElmntOrgActyStsVH.FrcElmntOrgActivitySts = FrcElmntOrgActivitySts  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgActyCmpltdVH AS _FrcElmntOrgActyCmpltdVH ON _FrcElmntOrgActyCmpltdVH.FrcElmntOrgActyCmpltd = FrcElmntOrgActyCmpltd  -- association [1..1]
;

Learn More