I_FrcElmntOrgWrkCtrText

DDL: I_FRCELMNTORGWRKCTRTEXT SQL: IFEORGWRKCTRTEXT Type: view BASIC

Work Center Text View

I_FrcElmntOrgWrkCtrText is a Basic CDS View that provides data about "Work Center Text View" in SAP S/4HANA. It reads from 1 data source (crtx) and exposes 3 fields with key fields FrcElmntOrgWorkCenterObjID, Language.

Data Sources (1)

SourceAliasJoin Type
crtx WrkCtrDesc from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFEORGWRKCTRTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Work Center Text View view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY FrcElmntOrgWorkCenterObjID crtx objid Work Center
KEY Language crtx spras Off. Language
FrcElmntOrgWorkCenterDesc crtx ktext Text

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_FrcElmntOrgWrkCtrText.
-- 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: IFEORGWRKCTRTEXT

CREATE VIEW I_FrcElmntOrgWrkCtrText AS
SELECT
  WrkCtrDesc.objid AS FrcElmntOrgWorkCenterObjID,
  WrkCtrDesc.spras AS Language,
  WrkCtrDesc.ktext AS FrcElmntOrgWorkCenterDesc
FROM crtx AS WrkCtrDesc
;