C_FrcElmntOrgRefOrgNameTP

DDL: C_FRCELMNTORGREFORGNAMETP SQL: CFEORGREFNAMETP Type: view CONSUMPTION
21 Fields 1 Data Sources 3 Associations

View of Reference Force Element Organization Names

C_FrcElmntOrgRefOrgNameTP is a Consumption CDS View that provides data about "View of Reference Force Element Organization Names" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntOrgNameTP) and exposes 21 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_FrcElmntOrgRefOrgTP _FrcElmntOrgTP _FrcElmntOrgTP.ForceElementOrgID = $projection.ForceElementOrgID
[1..1] C_FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatus = $projection.FrcElmntOrgPlngStatus
[1..*] C_DFS_TranslationLanguageVH _TranslationLanguageVH _TranslationLanguageVH.Language = $projection.FrcElmntOrgLanguage

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CFEORGREFNAMETP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK 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.updateEnabled true view
Metadata.allowExtensions true view
EndUserText.label View of Reference Force Element Organization Names view

Fields (21)

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
FrcElmntOrgValdtyStartDateFoEd I_FrcElmntOrgNameTP FrcElmntOrgValdtyStartDateFoEd Valid From
FrcElmntOrgValdtyEndDateFoEd I_FrcElmntOrgNameTP FrcElmntOrgValdtyEndDateFoEd Valid To
FrcElmntOrgLanguageFoEd I_FrcElmntOrgNameTP FrcElmntOrgLanguageFoEd Language
LanguageName _TranslationLanguageVH LanguageName Name
FrcElmntOrgPlngStsCritlty I_FrcElmntOrgNameTP FrcElmntOrgPlngStsCritlty
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_FrcElmntOrgRefOrgNameTP.
-- 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: CFEORGREFNAMETP

CREATE VIEW C_FrcElmntOrgRefOrgNameTP 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.FrcElmntOrgValdtyStartDateFoEd AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntOrgNameTP.FrcElmntOrgValdtyEndDateFoEd AS FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntOrgNameTP.FrcElmntOrgLanguageFoEd AS FrcElmntOrgLanguageFoEd,
  _TranslationLanguageVH.LanguageName AS LanguageName,
  FrcElmntOrgNameTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  _FrcElmntOrgPlngStsVH.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName
FROM I_FrcElmntOrgNameTP AS FrcElmntOrgNameTP
LEFT OUTER JOIN C_FrcElmntOrgRefOrgTP 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