I_FrcElmntOrgNameTP

DDL: I_FRCELMNTORGNAMETP SQL: IFEORGNAMETP Type: view TRANSACTIONAL
18 Fields 1 Data Sources 1 Associations

Transactional View of Force Element Organization Names

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

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntOrgName FrcElmntOrgNameTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_FrcElmntOrgTP _FrcElmntOrgTP $projection.ForceElementOrgID = _FrcElmntOrgTP.ForceElementOrgID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IFEORGNAMETP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.writeDraftPersistence DFS_FE_NAME_D view
EndUserText.label Transactional View of Force Element Organization Names view

Fields (18)

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

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 I_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: IFEORGNAMETP

CREATE VIEW I_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,
  FrcElmntOrgLanguage AS FrcElmntOrgLanguageFoEd,
  FrcElmntOrgNameTP.FrcElmntOrgInfoType AS FrcElmntOrgInfoType,
  FrcElmntOrgNameTP.FrcElmntOrgShortName AS FrcElmntOrgShortName,
  FrcElmntOrgNameTP.FrcElmntOrgName AS FrcElmntOrgName,
  FrcElmntOrgNameTP.FrcElmntOrgDelimitDate AS FrcElmntOrgDelimitDate,
  FrcElmntOrgNameTP.FrcElmntOrgValdtyStartDate AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntOrgNameTP.FrcElmntOrgValdtyEndDate AS FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntOrgNameTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  _FrcElmntOrgTP.ForceElementOrgUUID AS ForceElementOrgUUID
FROM I_FrcElmntOrgName AS FrcElmntOrgNameTP
LEFT OUTER JOIN I_FrcElmntOrgTP AS _FrcElmntOrgTP ON ForceElementOrgID = _FrcElmntOrgTP.ForceElementOrgID  -- association [1..1]
;

Learn More