Which tables does I_CommitmentItemTP use?

I_CommitmentItemTP reads from 1 data source(s): I_CommitmentItem.

How many fields does I_CommitmentItemTP have?

I_CommitmentItemTP has 39 fields. Key fields: FinancialManagementArea, FinMgmtAreaFiscalYear, CommitmentItem.

I_CommitmentItemTP

DDL: I_COMMITMENTITEMTP SQL: ICOMMITEMTP Type: view TRANSACTIONAL

Manage Commitment Item

I_CommitmentItemTP is a Transactional CDS View that provides data about "Manage Commitment Item" in SAP S/4HANA. It reads from 1 data source (I_CommitmentItem) and exposes 39 fields with key fields FinancialManagementArea, FinMgmtAreaFiscalYear, CommitmentItem. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_CommitmentItem	iComItem	from

Associations (2)

Cardinality	Target	Alias	Condition
[1]	I_CommitmentItem	_CommitmentItemVH	`$projection.FinancialManagementArea = _CommitmentItemVH.FinancialManagementArea and $projection.CommitmentItem = _CommitmentItemVH.CommitmentItem and $projection.FinMgmtAreaFiscalYear = _CommitmentItemVH.FinMgmtAreaFiscalYear`
[1..1]	E_CommitmentItem	_Extension	`$projection.FinancialManagementArea = _Extension.FinancialManagementArea and $projection.FinMgmtAreaFiscalYear = _Extension.FinMgmtAreaFiscalYear and $projection.CommitmentItem = _Extension.CommitmentItem`

Annotations (24)

Name	Value	Level
AbapCatalog.sqlViewName	ICOMMITEMTP	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Manage Commitment Item	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
ObjectModel.modelCategory	#BUSINESS_OBJECT	view
ObjectModel.createEnabled	true	view
ObjectModel.draftEnabled	true	view
ObjectModel.representativeKey	CommitmentItem	view
ObjectModel.compositionRoot	true	view
ObjectModel.transactionalProcessingEnabled	true	view
ObjectModel.updateEnabled	EXTERNAL_CALCULATION	view
ObjectModel.deleteEnabled	true	view
ObjectModel.writeDraftPersistence	FMCOMMITEM_DRAFT	view
ObjectModel.entityChangeStateId	EXTERNAL_CALCULATION	view
ObjectModel.lifecycle.draft.expiryBehavior	#RELATIVE_TO_PROCESSING_START	view
ObjectModel.lifecycle.draft.expiryInterval	P5D	view
ObjectModel.sapObjectNodeType.name	CommitmentItem	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#L	view
Consumption.semanticObject	CommitmentItem	view

Fields (39)

Key	Field	Source Table	Source Field
KEY	FinancialManagementArea	I_CommitmentItem	FinancialManagementArea
KEY	FinMgmtAreaFiscalYear	I_CommitmentItem	FinMgmtAreaFiscalYear
KEY	CommitmentItem	I_CommitmentItem	CommitmentItem
	FinancialManagementAreaForEdit	I_CommitmentItem	FinancialManagementArea
	CommitmentItemForEdit	I_CommitmentItem	CommitmentItem
	FinMgmtAreaFiscalYearForEdit	I_CommitmentItem	FinMgmtAreaFiscalYear
	CommitmentItemInternalId	I_CommitmentItem	CommitmentItemInternalId
	CommitmentItemShortID	I_CommitmentItem	CommitmentItemShortID
	CommitmentItemInternalName		CommitmentItemShortID
	CommitmentItemIsPostingEnabled	I_CommitmentItem	CommitmentItemIsPostingEnabled
	CmtmtItmFinancialTransaction
	CommitmentItemCategory
	CommitmentItemType	I_CommitmentItem	CommitmentItemType
	ParentCommitmentItem
	FundsCenter	I_CommitmentItem	FundsCenter
	CmtmtItmDefaultFundsCenter	I_CommitmentItem	CmtmtItmDefaultFundsCenter
	CmtmtItmCarryFwdItmCategory	I_CommitmentItem	CmtmtItmCarryFwdItmCategory
	CommitmentItemIsStatistical	I_CommitmentItem	CommitmentItemIsStatistical
	CommitmentItemRequestType
	CommitmentItemAuthznGrp	I_CommitmentItem	CommitmentItemAuthznGrp
	CmtmtItemFinMgmtAreaForAuthzn	I_CommitmentItem	CmtmtItemFinMgmtAreaForAuthzn
	ValidityEndDate	I_CommitmentItem	ValidityEndDate
	ValidityStartDate	I_CommitmentItem	ValidityStartDate
	CommitmentItemValidityPeriod
	CommitmentItemExpirationDate	I_CommitmentItem	CommitmentItemExpirationDate
	CommitmentItemName
	CommitmentItemDescription
	CommitmentItemDescription2
	CommitmentItemDescription3
	CreationDate
	CreatedByUser
	_FinMgmtArea		_FinMgmtArea
	_FiscalYearForFinMgmtArea		_FiscalYearForFinMgmtArea
	_Text		_Text
	_FinancialTransaction		_FinancialTransaction
	_CommitmentItemCategory		_CommitmentItemCategory
	_CommitmentItemHierarchy		_CommitmentItemHierarchy
	_CommitmentItemVH		_CommitmentItemVH
	_CommitmentItemParent		_CommitmentItemParent

@AbapCatalog.sqlViewName: 'ICOMMITEMTP'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Manage Commitment Item'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel: {
     modelCategory: #BUSINESS_OBJECT,
     createEnabled: true,
     draftEnabled: true,
     representativeKey: 'CommitmentItem',
     semanticKey:  [ 'FinancialManagementArea', 'CommitmentItem', 'FinMgmtAreaFiscalYear' ],
     compositionRoot: true,
     transactionalProcessingEnabled: true,
     updateEnabled: 'EXTERNAL_CALCULATION',
     deleteEnabled: true,
     writeDraftPersistence: 'FMCOMMITEM_DRAFT',
     entityChangeStateId: 'EXTERNAL_CALCULATION',
     lifecycle.draft.expiryBehavior: #RELATIVE_TO_PROCESSING_START,
     lifecycle.draft.expiryInterval: 'P5D',
     sapObjectNodeType.name: 'CommitmentItem',
     usageType: {
        dataClass: #MASTER,
        serviceQuality: #B, 
        sizeCategory: #L
     }
}
@Consumption.semanticObject: 'CommitmentItem'
define view I_CommitmentItemTP
  as select from I_CommitmentItem as iComItem

  // ValueHelp

  association [1] to I_CommitmentItem as _CommitmentItemVH on  $projection.FinancialManagementArea = _CommitmentItemVH.FinancialManagementArea
                                                           and $projection.CommitmentItem          = _CommitmentItemVH.CommitmentItem
                                                           and $projection.FinMgmtAreaFiscalYear   = _CommitmentItemVH.FinMgmtAreaFiscalYear

  association [1..1] to E_CommitmentItem as _Extension  //do not expose this association in the projection list of the view 

       on  $projection.FinancialManagementArea = _Extension.FinancialManagementArea
       and $projection.FinMgmtAreaFiscalYear   = _Extension.FinMgmtAreaFiscalYear
       and $projection.CommitmentItem          = _Extension.CommitmentItem
                                                           
{

      @ObjectModel.readOnly: true
      @ObjectModel.foreignKey.association: '_FinMgmtArea'
  key iComItem.FinancialManagementArea,
      @ObjectModel.readOnly: true
      @ObjectModel.foreignKey.association: '_CommitmentItemVH'
  key iComItem.FinMgmtAreaFiscalYear,
      @ObjectModel.readOnly: true
      @ObjectModel.foreignKey.association: '_CommitmentItemVH'
  key iComItem.CommitmentItem,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.FinancialManagementArea                                                          as FinancialManagementAreaForEdit,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.CommitmentItem                                                                   as CommitmentItemForEdit,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.FinMgmtAreaFiscalYear                                                            as FinMgmtAreaFiscalYearForEdit,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.CommitmentItemInternalId,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.CommitmentItemShortID,
      //obsolete field cannot be deleted from DRAFT table, we have to keep it 

      CommitmentItemShortID as CommitmentItemInternalName,    
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.CommitmentItemIsPostingEnabled,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      cast( iComItem.CmtmtItmFinancialTransaction as fmci_financial_transaction preserving type ) as CmtmtItmFinancialTransaction,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      cast( iComItem.CommitmentItemCategory as fmci_commitment_item_category preserving type ) as CommitmentItemCategory,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.CommitmentItemType,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'      
      cast (iComItem.ParentCommitmentItem as fmci_superior_commitment_item preserving type ) as ParentCommitmentItem,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'CmtmtItmDefaultFundsCenter'
      iComItem.FundsCenter,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.CmtmtItmDefaultFundsCenter,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.CmtmtItmCarryFwdItmCategory,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.CommitmentItemIsStatistical,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      cast( iComItem.CommitmentItemRequestType as fmci_request_type preserving type ) as CommitmentItemRequestType,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.CommitmentItemAuthznGrp,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.CmtmtItemFinMgmtAreaForAuthzn,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.ValidityEndDate,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.ValidityStartDate,
      //virtual field "Valid From - Valid To"

      @ObjectModel.readOnly: true      
      cast( concat(iComItem.ValidityStartDate, concat('-',iComItem.ValidityEndDate)) as commitmentitemvalidityperiod )        as CommitmentItemValidityPeriod,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem.CommitmentItemExpirationDate,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem._Text[1:Language = $session.system_language].CommitmentItemName                  as CommitmentItemName,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem._Text[1:Language = $session.system_language].CommitmentItemDescription           as CommitmentItemDescription,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem._Text[1:Language = $session.system_language].CommitmentItemDescription2          as CommitmentItemDescription2,
      @ObjectModel.enabled:   'EXTERNAL_CALCULATION'
      @ObjectModel.readOnly:  'EXTERNAL_CALCULATION'
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      iComItem._Text[1:Language = $session.system_language].CommitmentItemDescription3          as CommitmentItemDescription3,
      @ObjectModel.enabled:   true
      @ObjectModel.readOnly:  true
      @ObjectModel.mandatory: false
      iComItem._CommitmentItemHierarchy[1:CommitmentItemHierarchyVariant = '000'].CreationDate  as CreationDate,
      @ObjectModel.enabled:   true
      @ObjectModel.readOnly:  true
      @ObjectModel.mandatory: false
      iComItem._CommitmentItemHierarchy[1:CommitmentItemHierarchyVariant = '000'].CreatedByUser as CreatedByUser,

      _FinMgmtArea,
      _FiscalYearForFinMgmtArea,
      _Text,
      _FinancialTransaction,
      _CommitmentItemCategory,
      _CommitmentItemHierarchy,
      _CommitmentItemVH,
      _CommitmentItemParent

};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMMITMENTITEM",
"I_COMMITMENTITEMHIERARCHY",
"I_COMMITMENTITEMTEXT"
],
"ASSOCIATED":
[
"E_COMMITMENTITEM",
"I_CMTMTITMFINANCIALTRANSACTION",
"I_COMMITMENTITEM",
"I_COMMITMENTITEMCATEGORY",
"I_COMMITMENTITEMHIERARCHY",
"I_COMMITMENTITEMTEXT",
"I_FINANCIALMANAGEMENTAREA",
"I_FISCALYEARFORFINMGMTAREA"
],
"BASE":
[
"I_COMMITMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_CommitmentItemTP view

I_CommitmentItem view

C_CommitmentItemTP view