I_RO_SAFTMATERIALDOCUMENTITEM
RO SAFT Material Document Item
I_RO_SAFTMATERIALDOCUMENTITEM is a CDS View in S/4HANA. RO SAFT Material Document Item. It contains 18 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_RO_SAFTMatlDocLineItem | view_entity | from | COMPOSITE | RO SAFT Matl Doc Lines |
| I_RO_SAFTStockMovementLine | view | inner | COMPOSITE | Stock Movement Line Items |
Fields (18)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CompanyCode | CompanyCode | 1 |
| KEY | MaterialDocument | MaterialDocument | 2 |
| KEY | MaterialDocumentItem | MaterialDocumentItem | 1 |
| KEY | MaterialDocumentLine | MaterialDocumentLine | 1 |
| KEY | MaterialDocumentYear | MaterialDocumentYear | 2 |
| AccountingDocumentType | AccountingDocumentType | 1 | |
| AlternativeUnit | BaseUnit,MaterialBaseUnit | 2 | |
| Batch | Batch | 2 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| DebitCreditCode | DebitCreditCode | 1 | |
| DocumentDate | DocumentDate | 1 | |
| GoodsMovementStkAmtInCCCrcy | GoodsMovementStkAmtInCCCrcy | 1 | |
| GoodsMovementType | GoodsMovementType,MovementType | 2 | |
| MaterialDocumentItemText | MaterialDocumentItemText | 2 | |
| Plant | Plant | 1 | |
| PostingDate | PostingDate | 1 | |
| Product | Product | 1 |
@AbapCatalog.sqlViewName: 'IROSAFTMATDOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #X
@Analytics: { dataCategory: #DIMENSION }
@Analytics.internalName:#LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@VDM.viewType: #BASIC
@Metadata.allowExtensions:true
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET,
#CDS_MODELING_DATA_SOURCE,
#SQL_DATA_SOURCE]
@EndUserText.label: 'RO SAFT Material Document Item'
define view I_RO_SAFTMaterialDocumentItem
as select from matdoc as _Matdoc
inner join t001w as _Plant on _Matdoc.werks = _Plant.werks
association [0..1] to I_RO_SAFTProductValuation as _Valuation on _Matdoc.matbf = _Valuation.Product
and _Plant.bwkey = _Valuation.ValuationArea
and _Matdoc.bwtar = _Valuation.ValuationType
{
// _Matdoc.mblnr as MaterialDocument,
// _Matdoc.mjahr as MaterialDocumentYear,
//// line_id as MaterialDocumentLine,
// cast( lpad(_Matdoc.zeile, 6, '0') as fins_awitem ) as MaterialDocumentLine, //n3283572
//// key lpad(zeile, 6, '0') as awitem,
// _Matdoc.werks as Plant,
// _Matdoc.sobkz as ProjectNetworkHasSpecialStock,
// _Matdoc.bukrs as CompanyCode,
// _Matdoc.bwart as GoodsMovementType,
// _Matdoc.erfme as EntryUnit,
// @Semantics.quantity.unitOfMeasure : 'EntryUnit'
// _Matdoc.erfmg as GoodsMovementEntryQty,
// _Matdoc.budat as PostingDate,
// _Matdoc.matnr as Product,
// _Matdoc.meins as AlternativeUnit,
// _Matdoc.menge as GoodsMovementQuantity,
// _Matdoc.xblnr as DocumentReferenceID,
// _Matdoc.charg as Batch,
// _Matdoc.lgort as StorageLocation,
// _Matdoc.shkzg as DebitCreditCode,
// _Matdoc.sakto as ActiveGLAccount,
// _Matdoc.blart as AccountingDocumentType,
// _Matdoc.sgtxt as MaterialDocumentItemText,
// _Matdoc.vgart as MaterialLedgerTransactionType,
// cast(concat( _Matdoc.mblnr, _Matdoc.mjahr) as fac_awkey) as OriginalReferenceDocument,
_Matdoc.mblnr as MaterialDocument,
_Matdoc.mjahr as MaterialDocumentYear,
// line_id as MaterialDocumentLine,
_Matdoc.record_type as MaterialDocumentRecordType,
//cast( lpad(zeile, 6, '0') as fins_awitem ) as MaterialDocumentLine, //n3283572
cast(_Matdoc.zeile as nsdm_mblpo preserving type) as MaterialDocumentItem,
cast(_Matdoc.line_id as nsdm_mb_line_id preserving type ) as MaterialDocumentLine,
// key lpad(zeile, 6, '0') as awitem,
cast(_Matdoc.matbf as nsdm_matbf preserving type ) as StockIdentifyingMaterial,
_Matdoc.werks as Plant,
_Matdoc.lifnr as Supplier,
cast(_Matdoc.kunnr as nsdm_ekunn preserving type ) as Customer,
//sobkz as ProjectNetworkHasSpecialStock,
cast(_Matdoc.sobkz as nsdm_spcl_stock_type preserving type ) as ProjectNetworkHasSpecialStock,
_Matdoc.bukrs as CompanyCode,
_Matdoc.erfme as EntryUnit,
@Semantics.quantity.unitOfMeasure : 'EntryUnit'
_Matdoc.erfmg as GoodsMovementEntryQty,
_Matdoc.budat as PostingDate,
_Matdoc.matnr as Product,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
@DefaultAggregation: #NONE
cast(_Matdoc.dmbtr_stock as nsdm_dmbtr_stock_l preserving type ) as GoodsMovementStkAmtInCCCrcy,
cast(_Matdoc.waers as nsdm_comp_code_currency preserving type ) as CompanyCodeCurrency,
//meins as AlternativeUnit,
@Semantics.quantity.unitOfMeasure: 'AlternativeUnit'
_Matdoc.stock_qty as MatlStkChangeQtyInBaseUnit,
@Semantics.quantity.unitOfMeasure: 'AlternativeUnit'
_Matdoc.menge as GoodsMovementQuantity,
@Semantics.unitOfMeasure: true
_Matdoc.meins as AlternativeUnit,
//gjahr as FiscalYear,
cast(_Matdoc.gjahr as fis_gjahr_no_conv preserving type ) as FiscalYear,
_Matdoc.bldat as DocumentDate,
_Matdoc.xblnr as DocumentReferenceID,
_Matdoc.charg as Batch,
_Matdoc.lgort as StorageLocation,
_Matdoc.bwart as GoodsMovementType,
_Matdoc.bwtar as InventoryValuationType,
_Matdoc.shkzg as DebitCreditCode,
_Matdoc.sakto as ActiveGLAccount,
_Matdoc.blart as AccountingDocumentType,
_Matdoc.sgtxt as MaterialDocumentItemText,
_Matdoc.usnam as CreatedByUser,
_Matdoc.vgart as MaterialLedgerTransactionType,
cast(concat( _Matdoc.mblnr, _Matdoc.mjahr) as fac_awkey) as OriginalReferenceDocument,
_Valuation.ValuationClass
} where _Matdoc.record_type = 'MDOC'
and _Matdoc.bustw is not initial