C_FrcElmntOrgDescriptionTP

DDL: C_FRCELMNTORGDESCRIPTIONTP SQL: CFEORGDESCTP Type: view CONSUMPTION
33 Fields 1 Data Sources 5 Associations

View of Description of FE Organisation

C_FrcElmntOrgDescriptionTP is a Consumption CDS View that provides data about "View of Description of FE Organisation" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntOrgDescriptionTP) and exposes 33 fields with key fields FrcElmntOrgPlanVersion, FrcElmntOrgType, ForceElementOrgID, FrcElmntOrgSubType, FrcElmntOrgPlngStatus. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntOrgDescriptionTP _FrcElmntOrgDescriptionTP from

Associations (5)

CardinalityTargetAliasCondition
[1..1] C_FrcElmntOrgTP _FrcElmntOrgTP _FrcElmntOrgTP.ForceElementOrgID = $projection.ForceElementOrgID
[1..1] C_FrcElmntOrgSubTypeVH _FrcElmntOrgSubTypeVH _FrcElmntOrgSubTypeVH.FrcElmntOrgSubTypeForEdit = $projection.FrcElmntOrgSubTypeForEdit and _FrcElmntOrgSubTypeVH.FrcElmntOrgSubType = $projection.FrcElmntOrgSubType and _FrcElmntOrgSubTypeVH.FrcElmntOrgInfoType = $projection.FrcElmntOrgInfoType
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.FrcElmntOrgPlngStatus and _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusForEdit = $projection.FrcElmntOrgPlngStatusForEdit
[1..*] C_DFS_TranslationLanguageVH _TranslationLanguageVH _TranslationLanguageVH.Language = $projection.FrcElmntOrgLanguage
[0..1] C_FrcElmntSuplmntyAttribAssgmt _SrceFrcElmntOrgTP $projection.ForceElementOrgID = _SrceFrcElmntOrgTP.ForceElementOrgID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CFEORGDESCTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE 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 EXTERNAL_CALCULATION view
Metadata.allowExtensions true view
EndUserText.label View of Description of FE Organisation view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY FrcElmntOrgPlanVersion I_FrcElmntOrgDescriptionTP FrcElmntOrgPlanVersion Plan version
KEY FrcElmntOrgType I_FrcElmntOrgDescriptionTP FrcElmntOrgType Object type
KEY ForceElementOrgID I_FrcElmntOrgDescriptionTP ForceElementOrgID Object ID Processor
KEY FrcElmntOrgSubType I_FrcElmntOrgDescriptionTP FrcElmntOrgSubType Subtype
KEY FrcElmntOrgPlngStatus I_FrcElmntOrgDescriptionTP FrcElmntOrgPlngStatus Planning Status
KEY FrcElmntOrgValdtyStartDate I_FrcElmntOrgDescriptionTP FrcElmntOrgValdtyStartDate Start Date
KEY FrcElmntOrgValdtyEndDate I_FrcElmntOrgDescriptionTP FrcElmntOrgValdtyEndDate End Date
KEY FrcElmntOrgLanguage I_FrcElmntOrgDescriptionTP FrcElmntOrgLanguage Language
KEY NumberOfForceElementOrg I_FrcElmntOrgDescriptionTP NumberOfForceElementOrg IT record no.
KEY NumberOfFrcElmntOrgDescRef I_FrcElmntOrgDescriptionTP NumberOfFrcElmntOrgDescRef
KEY FrcElmntOrgDescription I_FrcElmntOrgDescriptionTP FrcElmntOrgDescription
FrcElmntOrgInfoType I_FrcElmntOrgDescriptionTP FrcElmntOrgInfoType Infotype
FrcElmntOrgDescriptionForEdit I_FrcElmntOrgDescriptionTP FrcElmntOrgDescriptionForEdit
FrcElmntOrgPlngStsCritlty I_FrcElmntOrgDescriptionTP FrcElmntOrgPlngStsCritlty
FrcElmntOrgValdtyEndDateFoEd I_FrcElmntOrgDescriptionTP FrcElmntOrgValdtyEndDateFoEd End Date
FrcElmntOrgValdtyStartDateFoEd I_FrcElmntOrgDescriptionTP FrcElmntOrgValdtyStartDateFoEd Start date
FrcElmntOrgPlngStatusName _FrcElmntOrgPlngStsVH FrcElmntOrgPlngStatusName Planning Status
FrcElmntOrgSubTypeName _FrcElmntOrgSubTypeVH FrcElmntOrgSubTypeName
FrcElmntOrgDescRefNumber I_FrcElmntOrgDescriptionTP FrcElmntOrgDescRefNumber
FrcElmntOrgPlngStatusForEdit I_FrcElmntOrgDescriptionTP FrcElmntOrgPlngStatusForEdit Planning status
FrcElmntOrgSubTypeForEdit I_FrcElmntOrgDescriptionTP FrcElmntOrgSubTypeForEdit Subtype
FrcElmntOrgLanguageFoEd I_FrcElmntOrgDescriptionTP FrcElmntOrgLanguageFoEd Language
LanguageName _TranslationLanguageVH LanguageName Name
Language _TranslationLanguageVH Language Report Text Language
FrcElmntOrgPlanDelimitDate FrcElmntOrgPlanDelimitDate Delimit date
FrcElmntOrgDlmtdPlngStatusName FrcElmntOrgPlngStatusName Planning Status
FrcElmntOrgDlmtdPlngStsCritlty FrcElmntOrgDlmtdPlngStsCritlty
_FrcElmntOrgTP _FrcElmntOrgTP
_FrcElmntOrgSubTypeVH _FrcElmntOrgSubTypeVH
_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH
_TranslationLanguageVH _TranslationLanguageVH
FrcElmntOrgName _SrceFrcElmntOrgTP FrcElmntOrgName Object Name
_SrceFrcElmntOrgTP _SrceFrcElmntOrgTP

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_FrcElmntOrgDescriptionTP.
-- 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: CFEORGDESCTP

CREATE VIEW C_FrcElmntOrgDescriptionTP AS
SELECT
  _FrcElmntOrgDescriptionTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgType AS FrcElmntOrgType,
  _FrcElmntOrgDescriptionTP.ForceElementOrgID AS ForceElementOrgID,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgSubType AS FrcElmntOrgSubType,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgLanguage AS FrcElmntOrgLanguage,
  _FrcElmntOrgDescriptionTP.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  _FrcElmntOrgDescriptionTP.NumberOfFrcElmntOrgDescRef AS NumberOfFrcElmntOrgDescRef,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgDescription AS FrcElmntOrgDescription,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgDescriptionForEdit AS FrcElmntOrgDescriptionForEdit,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgValdtyEndDateFoEd AS FrcElmntOrgValdtyEndDateFoEd,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgValdtyStartDateFoEd AS FrcElmntOrgValdtyStartDateFoEd,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  _FrcElmntOrgSubTypeVH.FrcElmntOrgSubTypeName AS FrcElmntOrgSubTypeName,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgDescRefNumber AS FrcElmntOrgDescRefNumber,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgPlngStatusForEdit AS FrcElmntOrgPlngStatusForEdit,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgSubTypeForEdit AS FrcElmntOrgSubTypeForEdit,
  _FrcElmntOrgDescriptionTP.FrcElmntOrgLanguageFoEd AS FrcElmntOrgLanguageFoEd,
  _TranslationLanguageVH.LanguageName AS LanguageName,
  _TranslationLanguageVH.Language AS Language,
  FrcElmntOrgPlanDelimitDate,
  FrcElmntOrgPlngStatusName AS FrcElmntOrgDlmtdPlngStatusName,
  FrcElmntOrgDlmtdPlngStsCritlty,
  _SrceFrcElmntOrgTP.FrcElmntOrgName AS FrcElmntOrgName
FROM I_FrcElmntOrgDescriptionTP AS _FrcElmntOrgDescriptionTP
LEFT OUTER JOIN C_FrcElmntOrgTP AS _FrcElmntOrgTP ON _FrcElmntOrgTP.ForceElementOrgID = ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgSubTypeVH AS _FrcElmntOrgSubTypeVH ON _FrcElmntOrgSubTypeVH.FrcElmntOrgSubTypeForEdit = FrcElmntOrgSubTypeForEdit AND _FrcElmntOrgSubTypeVH.FrcElmntOrgSubType = FrcElmntOrgSubType AND _FrcElmntOrgSubTypeVH.FrcElmntOrgInfoType = FrcElmntOrgInfoType  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = FrcElmntOrgPlngStatus AND _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusForEdit = FrcElmntOrgPlngStatusForEdit  -- association [1..1]
LEFT OUTER JOIN C_DFS_TranslationLanguageVH AS _TranslationLanguageVH ON _TranslationLanguageVH.Language = FrcElmntOrgLanguage  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntSuplmntyAttribAssgmt AS _SrceFrcElmntOrgTP ON ForceElementOrgID = _SrceFrcElmntOrgTP.ForceElementOrgID  -- association [0..1]
;

Learn More