I_RO_SAFTMATERIALDOCUMENTITEM

CDS View

RO SAFT Material Document Item

I_RO_SAFTMATERIALDOCUMENTITEM is a CDS View in S/4HANA. RO SAFT Material Document Item. It contains 4 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 4 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RO_SAFTStockMovementLine view inner COMPOSITE Stock Movement Line Items

Fields (4)

KeyField CDS FieldsUsed in Views
KEY MaterialDocumentLine MaterialDocumentLine 1
Batch Batch 1
GoodsMovementType GoodsMovementType 1
MaterialDocumentItemText MaterialDocumentItemText 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: #B
@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 
{
      mblnr as MaterialDocument,
      mjahr as MaterialDocumentYear,
//      line_id as MaterialDocumentLine,

      cast( lpad(zeile, 6, '0') as fins_awitem ) as MaterialDocumentLine,  //n3283572

//    key lpad(zeile, 6, '0') as awitem,

      werks as Plant,
      sobkz as ProjectNetworkHasSpecialStock,
      bukrs as CompanyCode,
      bwart as GoodsMovementType,
      erfme as EntryUnit,
      @Semantics.quantity.unitOfMeasure : 'EntryUnit'
      erfmg as GoodsMovementEntryQty,
      budat as PostingDate,
      matnr as Product,
      meins as AlternativeUnit,
      menge as GoodsMovementQuantity,
      xblnr as DocumentReferenceID,
      charg as Batch,
      lgort as StorageLocation,
      shkzg as DebitCreditCode,
      sakto as ActiveGLAccount,
      blart as AccountingDocumentType,
      sgtxt as MaterialDocumentItemText, 
      vgart as MaterialLedgerTransactionType,
      cast(concat( mblnr, mjahr) as fac_awkey) as OriginalReferenceDocument

} where record_type = 'MDOC'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MATDOC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More