I_OrderConfMatlDocItemAssgmt

DDL: I_ORDERCONFMATLDOCITEMASSGMT Type: view_entity BASIC

Assignment Order Confirmation to Material Document Item

I_OrderConfMatlDocItemAssgmt is a Basic CDS View (Fact) that provides data about "Assignment Order Confirmation to Material Document Item" in SAP S/4HANA. It reads from 1 data source (afwi) and exposes 10 fields with key fields ConfirmationGroup, ConfirmationCount, MaterialDocument, MaterialDocumentYear, MaterialDocumentItem. It has 5 associations to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
afwi afwi from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_ConfirmationGroup _ConfirmationGroup $projection.ConfirmationGroup = _ConfirmationGroup.ConfirmationGroup
[1..1] I_ConfirmationCount _ConfirmationCount $projection.ConfirmationGroup = _ConfirmationCount.ConfirmationGroup and $projection.ConfirmationCount = _ConfirmationCount.ConfirmationCount
[1..1] I_MaterialDocumentYear _MaterialDocumentYear $projection.MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear
[1..1] I_MaterialDocumentHeader_2 _MaterialDocumentHeader $projection.MaterialDocument = _MaterialDocumentHeader.MaterialDocument and $projection.MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear
[1..1] I_MaterialDocumentItem_2 _MaterialDocumentItem $projection.MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear and $projection.MaterialDocument = _MaterialDocumentItem.MaterialDocument and $projection.MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #FACT view
Analytics.technicalName IORDCONFMATLDOC view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label Assignment Order Confirmation to Material Document Item view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ConfirmationGroup rueck
KEY ConfirmationCount rmzhl
KEY MaterialDocument mblnr
KEY MaterialDocumentYear mjahr
KEY MaterialDocumentItem mblpo
_ConfirmationGroup _ConfirmationGroup
_ConfirmationCount _ConfirmationCount
_MaterialDocumentHeader _MaterialDocumentHeader
_MaterialDocumentItem _MaterialDocumentItem
_MaterialDocumentYear _MaterialDocumentYear 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataCategory: #FACT
@Analytics.technicalName: 'IORDCONFMATLDOC'
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Assignment Order Confirmation to Material Document Item'

define view entity I_OrderConfMatlDocItemAssgmt
  as select from afwi

  association [1..1] to I_ConfirmationGroup        as _ConfirmationGroup      on  $projection.ConfirmationGroup    = _ConfirmationGroup.ConfirmationGroup
  association [1..1] to I_ConfirmationCount        as _ConfirmationCount      on  $projection.ConfirmationGroup    = _ConfirmationCount.ConfirmationGroup
                                                                              and $projection.ConfirmationCount    = _ConfirmationCount.ConfirmationCount
  association [1..1] to I_MaterialDocumentYear     as _MaterialDocumentYear   on  $projection.MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear
  association [1..1] to I_MaterialDocumentHeader_2 as _MaterialDocumentHeader on  $projection.MaterialDocument     = _MaterialDocumentHeader.MaterialDocument
                                                                              and $projection.MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear
  association [1..1] to I_MaterialDocumentItem_2   as _MaterialDocumentItem   on  $projection.MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear 
                                                                              and $projection.MaterialDocument     = _MaterialDocumentItem.MaterialDocument
                                                                              and $projection.MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem
{
      // Key

      @ObjectModel.foreignKey.association: '_ConfirmationGroup'
  key rueck as ConfirmationGroup,
      @ObjectModel.foreignKey.association: '_ConfirmationCount'
  key rmzhl as ConfirmationCount,
      @ObjectModel.foreignKey.association: '_MaterialDocumentHeader'  
  key mblnr as MaterialDocument,
      @ObjectModel.foreignKey.association: '_MaterialDocumentYear'
  key mjahr as MaterialDocumentYear, 
      @ObjectModel.foreignKey.association: '_MaterialDocumentItem'
  key mblpo as MaterialDocumentItem,
      
      // Associations

      _ConfirmationGroup,
      _ConfirmationCount,
      _MaterialDocumentHeader,
      _MaterialDocumentItem,
      _MaterialDocumentYear
}
  where mjahr != '0000';   // only material documents

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AFWI"
],
"ASSOCIATED":
[
"I_CONFIRMATIONCOUNT",
"I_CONFIRMATIONGROUP",
"I_MATERIALDOCUMENTHEADER_2",
"I_MATERIALDOCUMENTITEM_2",
"I_MATERIALDOCUMENTYEAR"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More