C_FrcElmntOrgNameTP

DDL: C_FRCELMNTORGNAMETP SQL: CFEORGNAMETP Type: view CONSUMPTION
22 Fields 1 Data Sources 3 Associations

View of Force Element Organization Names

C_FrcElmntOrgNameTP is a Consumption CDS View that provides data about "View of Force Element Organization Names" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntOrgNameTP) and exposes 22 fields with key fields ForceElementOrgID, FrcElmntOrgValdtyStartDate, FrcElmntOrgValdtyEndDate, FrcElmntOrgPlanVersion, FrcElmntOrgPlngStatus. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntOrgNameTP FrcElmntOrgNameTP from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_FrcElmntOrgTP _FrcElmntOrgTP _FrcElmntOrgTP.ForceElementOrgID = $projection.ForceElementOrgID
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.FrcElmntOrgPlngStatus
[1..*] C_DFS_TranslationLanguageVH _TranslationLanguageVH _TranslationLanguageVH.Language = $projection.FrcElmntOrgLanguage

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CFEORGNAMETP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label View of Force Element Organization Names view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE 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.deleteEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
Metadata.allowExtensions true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ForceElementOrgID I_FrcElmntOrgNameTP ForceElementOrgID Object ID Processor
KEY FrcElmntOrgValdtyStartDate I_FrcElmntOrgNameTP FrcElmntOrgValdtyStartDate Start Date
KEY FrcElmntOrgValdtyEndDate I_FrcElmntOrgNameTP FrcElmntOrgValdtyEndDate End Date
KEY FrcElmntOrgPlanVersion I_FrcElmntOrgNameTP FrcElmntOrgPlanVersion Plan version
KEY FrcElmntOrgPlngStatus I_FrcElmntOrgNameTP FrcElmntOrgPlngStatus Planning status
KEY FrcElmntOrgLanguage I_FrcElmntOrgNameTP FrcElmntOrgLanguage Language
KEY NumberOfForceElementOrg I_FrcElmntOrgNameTP NumberOfForceElementOrg IT record no.
KEY FrcElmntOrgType I_FrcElmntOrgNameTP FrcElmntOrgType Object type
FrcElmntOrgInfoType I_FrcElmntOrgNameTP FrcElmntOrgInfoType Infotype
FrcElmntOrgShortName I_FrcElmntOrgNameTP FrcElmntOrgShortName Object abbr.
FrcElmntOrgName I_FrcElmntOrgNameTP FrcElmntOrgName Name
FrcElmntOrgDelimitDate I_FrcElmntOrgNameTP FrcElmntOrgDelimitDate Delimitation Date
FrcElmntOrgPlngStsCritlty I_FrcElmntOrgNameTP FrcElmntOrgPlngStsCritlty
FrcElmntOrgValdtyStartDateFoEd I_FrcElmntOrgNameTP FrcElmntOrgValdtyStartDateFoEd Start Date
FrcElmntOrgValdtyEndDateFoEd I_FrcElmntOrgNameTP FrcElmntOrgValdtyEndDateFoEd End Date
FrcElmntOrgLanguageFoEd I_FrcElmntOrgNameTP FrcElmntOrgLanguageFoEd Language
LanguageName _TranslationLanguageVH LanguageName Name
ForceElementOrgUUID I_FrcElmntOrgNameTP ForceElementOrgUUID GUID 32
FrcElmntOrgPlngStatusName _FrcElmntOrgPlngStsVH FrcElmntOrgPlngStatusName Planning Status Name
_FrcElmntOrgTP _FrcElmntOrgTP
_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH
_TranslationLanguageVH _TranslationLanguageVH

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_FrcElmntOrgNameTP.
-- 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: CFEORGNAMETP

CREATE VIEW C_FrcElmntOrgNameTP AS
SELECT
  FrcElmntOrgNameTP.ForceElementOrgID AS ForceElementOrgID,
  FrcElmntOrgNameTP.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDate,
  FrcElmntOrgNameTP.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDate,
  FrcElmntOrgNameTP.FrcElmntOrgPlanVersion AS FrcElmntOrgPlanVersion,
  FrcElmntOrgNameTP.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  FrcElmntOrgNameTP.FrcElmntOrgLanguage AS FrcElmntOrgLanguage,
  FrcElmntOrgNameTP.NumberOfForceElementOrg AS NumberOfForceElementOrg,
  FrcElmntOrgNameTP.FrcElmntOrgType AS FrcElmntOrgType,
  FrcElmntOrgNameTP.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntOrgNameTP.FrcElmntOrgShortName AS FrcElmntOrgShortName,
  FrcElmntOrgNameTP.FrcElmntOrgName AS FrcElmntOrgName,
  FrcElmntOrgNameTP.FrcElmntOrgDelimitDate AS FrcElmntOrgDelimitDate,
  FrcElmntOrgNameTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  FrcElmntOrgNameTP.FrcElmntOrgValdtyStartDateFoEd AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntOrgNameTP.FrcElmntOrgValdtyEndDateFoEd AS FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntOrgNameTP.FrcElmntOrgLanguageFoEd AS FrcElmntOrgLanguageFoEd,
  _TranslationLanguageVH.LanguageName AS LanguageName,
  FrcElmntOrgNameTP.ForceElementOrgUUID AS ForceElementOrgUUID,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName
FROM I_FrcElmntOrgNameTP AS FrcElmntOrgNameTP
LEFT OUTER JOIN C_FrcElmntOrgTP AS _FrcElmntOrgTP ON _FrcElmntOrgTP.ForceElementOrgID = ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgPlngStsVH AS _FrcElmntOrgPlngStsVH ON _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = FrcElmntOrgPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_DFS_TranslationLanguageVH AS _TranslationLanguageVH ON _TranslationLanguageVH.Language = FrcElmntOrgLanguage  -- association [1..*]
;

Learn More