ESH_N_COMMIT_ITM

DDL: ESH_N_COMMIT_ITM SQL: ESH_L_COMMIT_ITM Type: view

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

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_COMMITMENTITEM I_COMMITMENTITEM from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (3)

CardinalityTargetAliasCondition
[0..*] dd07t _FINANCIALTRANSACTION $projection.CmtmtItmFinancialTransaction=_FINANCIALTRANSACTION.domvalue_l and _FINANCIALTRANSACTION.domname='FM_FIVOR' and _FINANCIALTRANSACTION.as4local='A'
[0..*] dd07t _CMTMTITMISPOSTINGENABLED ( $projection.CommitmentItemIsPostingEnabled=_CMTMTITMISPOSTINGENABLED.domvalue_l AND _CMTMTITMISPOSTINGENABLED.domname='FM_KATEG' AND _CMTMTITMISPOSTINGENABLED.as4local='A' )
[0..*] dd07t _COMMITMENTITEMCATEGORY ( $projection.CommitmentItemCategory=_COMMITMENTITEMCATEGORY.domvalue_l AND _COMMITMENTITEMCATEGORY.domname='FM_POTYP' AND _COMMITMENTITEMCATEGORY.as4local='A' )

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ESH_L_COMMIT_ITM view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY COMMITMENTITEM COMMITMENTITEM
KEY FINANCIALMANAGEMENTAREA FINANCIALMANAGEMENTAREA
KEY FINMGMTAREAFISCALYEAR FINMGMTAREAFISCALYEAR
CMTMTITMDEFAULTFUNDSCENTER CMTMTITMDEFAULTFUNDSCENTER
CMTMTITMFINANCIALTRANSACTION CMTMTITMFINANCIALTRANSACTION
CMTMTITMFINTRANSACTIONTEXT
CMTMTITMISPOSTINGENABLEDNAME
COMMITMENTITEMAUTHZNGRP COMMITMENTITEMAUTHZNGRP
COMMITMENTITEMCATEGORY COMMITMENTITEMCATEGORY
COMMITMENTITEMCATEGORYNAME
COMMITMENTITEMEXPIRATIONDATE COMMITMENTITEMEXPIRATIONDATE
COMMITMENTITEMISPOSTINGENABLED COMMITMENTITEMISPOSTINGENABLED
COMMITMENTITEMISSTATISTICAL COMMITMENTITEMISSTATISTICAL
COMMITMENTITEMNAME
COMMITMENTITEMTYPE COMMITMENTITEMTYPE
CREATEDBYUSER CREATEDBYUSER
CREATIONDATE CREATIONDATE
VALIDITYENDDATE VALIDITYENDDATE
VALIDITYSTARTDATE VALIDITYSTARTDATE 
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #P
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'ESH_L_COMMIT_ITM'
define view ESH_N_COMMIT_ITM
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from I_COMMITMENTITEM
association [0..*] to dd07t as _FINANCIALTRANSACTION on  $projection.CmtmtItmFinancialTransaction=_FINANCIALTRANSACTION.domvalue_l and  _FINANCIALTRANSACTION.domname='FM_FIVOR' and  _FINANCIALTRANSACTION.as4local='A' association [0..*] to dd07t as _CMTMTITMISPOSTINGENABLED on ( $projection.CommitmentItemIsPostingEnabled=_CMTMTITMISPOSTINGENABLED.domvalue_l AND  _CMTMTITMISPOSTINGENABLED.domname='FM_KATEG' AND  _CMTMTITMISPOSTINGENABLED.as4local='A' )association [0..*] to dd07t as _COMMITMENTITEMCATEGORY on ( $projection.CommitmentItemCategory=_COMMITMENTITEMCATEGORY.domvalue_l AND  _COMMITMENTITEMCATEGORY.domname='FM_POTYP' AND  _COMMITMENTITEMCATEGORY.as4local='A' ) {

key COMMITMENTITEM,

key FINANCIALMANAGEMENTAREA,

key FINMGMTAREAFISCALYEAR,

CMTMTITMDEFAULTFUNDSCENTER,

CMTMTITMFINANCIALTRANSACTION,

_FINANCIALTRANSACTION[1: ddlanguage = $parameters. P_Language].ddtext as CMTMTITMFINTRANSACTIONTEXT,

_CMTMTITMISPOSTINGENABLED[1: ddlanguage = $parameters. P_Language].ddtext as CMTMTITMISPOSTINGENABLEDNAME,

COMMITMENTITEMAUTHZNGRP,

COMMITMENTITEMCATEGORY,

_COMMITMENTITEMCATEGORY[1: ddlanguage = $parameters. P_Language].ddtext as COMMITMENTITEMCATEGORYNAME,

COMMITMENTITEMEXPIRATIONDATE,

COMMITMENTITEMISPOSTINGENABLED,

COMMITMENTITEMISSTATISTICAL,

_TEXT[1: LANGUAGE = $parameters. P_Language].COMMITMENTITEMNAME,

COMMITMENTITEMTYPE,

CREATEDBYUSER,

CREATIONDATE,

VALIDITYENDDATE,

VALIDITYSTARTDATE
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMMITMENTITEM",
"I_COMMITMENTITEMTEXT",
"DD07T"
],
"ASSOCIATED":
[
"DD07T"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More