ESH_S_COMMIT_ITM

DDL: ESH_S_COMMIT_ITM SQL: ESH_U_COMMIT_ITM Type: view
19 Fields 1 Data Sources 1 Associations

ESH_S_COMMIT_ITM is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_COMMIT_ITM) and exposes 19 fields with key fields COMMITMENTITEM, FINANCIALMANAGEMENTAREA, FINMGMTAREAFISCALYEAR. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
ESH_N_COMMIT_ITM ESH_N_COMMIT_ITM from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_COMMITMENTITEM _EXTENSION ( $projection.FINANCIALMANAGEMENTAREA = _EXTENSION.FINANCIALMANAGEMENTAREA AND $projection.FINMGMTAREAFISCALYEAR = _EXTENSION.FINMGMTAREAFISCALYEAR AND $projection.COMMITMENTITEM = _EXTENSION.COMMITMENTITEM )

Annotations (19)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name CommitmentItem view
UI.headerInfo.typeName Commitment Item view
UI.headerInfo.typeNamePlural Commitment Items view
Consumption.semanticObject CommitmentItem view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value COMMITMENTITEM view
UI.headerInfo.description.type #AS_CONNECTED_FIELDS view
UI.headerInfo.description.valueQualifier Group4 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_COMMIT_ITM view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY COMMITMENTITEM COMMITMENTITEM Commitment item
KEY FINANCIALMANAGEMENTAREA FINANCIALMANAGEMENTAREA FM Area
KEY FINMGMTAREAFISCALYEAR FINMGMTAREAFISCALYEAR FM Area Fiscal Year
CMTMTITMDEFAULTFUNDSCENTER CMTMTITMDEFAULTFUNDSCENTER Default Funds Center
CMTMTITMFINANCIALTRANSACTION CMTMTITMFINANCIALTRANSACTION Financial Transaction
CMTMTITMFINTRANSACTIONTEXT CMTMTITMFINTRANSACTIONTEXT Financial Transaction Description
CMTMTITMISPOSTINGENABLEDNAME CMTMTITMISPOSTINGENABLEDNAME Directly Postable Description
COMMITMENTITEMAUTHZNGRP COMMITMENTITEMAUTHZNGRP Authorization Group
COMMITMENTITEMCATEGORY COMMITMENTITEMCATEGORY Commitment Item Category
COMMITMENTITEMCATEGORYNAME COMMITMENTITEMCATEGORYNAME Commitment Item Category Description
COMMITMENTITEMEXPIRATIONDATE COMMITMENTITEMEXPIRATIONDATE
COMMITMENTITEMISPOSTINGENABLED COMMITMENTITEMISPOSTINGENABLED Directly Postable
COMMITMENTITEMISSTATISTICAL COMMITMENTITEMISSTATISTICAL Statistical Commitment Item
COMMITMENTITEMNAME COMMITMENTITEMNAME Long Text
COMMITMENTITEMTYPE COMMITMENTITEMTYPE
CREATEDBYUSER CREATEDBYUSER Created by
CREATIONDATE CREATIONDATE Creation Date
VALIDITYENDDATE VALIDITYENDDATE ValidTo
VALIDITYSTARTDATE VALIDITYSTARTDATE Validity Start Date

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 ESH_S_COMMIT_ITM.
-- 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: ESH_U_COMMIT_ITM
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_COMMIT_ITM AS
SELECT
  COMMITMENTITEM,
  FINANCIALMANAGEMENTAREA,
  FINMGMTAREAFISCALYEAR,
  CMTMTITMDEFAULTFUNDSCENTER,
  CMTMTITMFINANCIALTRANSACTION,
  CMTMTITMFINTRANSACTIONTEXT,
  CMTMTITMISPOSTINGENABLEDNAME,
  COMMITMENTITEMAUTHZNGRP,
  COMMITMENTITEMCATEGORY,
  COMMITMENTITEMCATEGORYNAME,
  COMMITMENTITEMEXPIRATIONDATE,
  COMMITMENTITEMISPOSTINGENABLED,
  COMMITMENTITEMISSTATISTICAL,
  COMMITMENTITEMNAME,
  COMMITMENTITEMTYPE,
  CREATEDBYUSER,
  CREATIONDATE,
  VALIDITYENDDATE,
  VALIDITYSTARTDATE
FROM ESH_N_COMMIT_ITM
LEFT OUTER JOIN E_COMMITMENTITEM AS _EXTENSION ON ( FINANCIALMANAGEMENTAREA = _EXTENSION.FINANCIALMANAGEMENTAREA AND FINMGMTAREAFISCALYEAR = _EXTENSION.FINMGMTAREAFISCALYEAR AND COMMITMENTITEM = _EXTENSION.COMMITMENTITEM )  -- association [0..1]
;

Learn More