I_SVTPREPROCESSEDDOCUMENTS

CDS View

Union view of the Preprocessed Documents

I_SVTPREPROCESSEDDOCUMENTS is a CDS View in S/4HANA. Union view of the Preprocessed Documents. It contains 5 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 5 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MatlDocsByMonthAndBusProcess view inner COMPOSITE Mat Doc Info By Month and Bus Process
R_SVTProcdMaterialDocumentTP view_entity from TRANSACTIONAL Processed Material Document - TP

Fields (5)

KeyField CDS FieldsUsed in Views
KEY SVTPreprocessedDocumentUUID SVTPreprocessedDocumentUUID 1
Material Material 1
Plant Plant 1
Quantity Quantity 1
QuantityUnit QuantityUnit 1 
@AbapCatalog.sqlViewName: 'ISVTPREPROCDOC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Union view of the Preprocessed Documents'


@ObjectModel: {
    usageType:{
        dataClass: #TRANSACTIONAL,
        serviceQuality: #B,
        sizeCategory: #L
      }
}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_SVTPreprocessedDocuments
  as select from I_SVTProdnPrprocgDocument
{
  key SVTConfirmedProductionDocUUID as SVTPreprocessedDocumentUUID,
      MaterialDocument,
      Material,
      Quantity,
      QuantityUnit,
      MaterialDocumentItem,
      MaterialDocumentYear,
      ProductionCompanyCode         as CompanyCode,
      ProductionPlant               as Plant,
      PostingDate,
      CreationTime,
      CreationDateTime,
      SVTPreprocessingStatus,
      OrderQuantity,
      OrderQuantityUnit,
      IsDeleted,
      GoodsMovementType,
      DebitCreditCode,
      AccountingDocumentType,
      InventoryTransactionType,
      ProdCmplncEventUUID,
      SVTBusinessProcessCategory,
      cast( '' as ehpma_svt_delivering_country ) as DeliveringCountry,
      cast( '' as ehpma_svt_supplier_is_importer ) as SupplierIsImporter,
      cast( '' as retpo ) as IsReturnsItem,
      cast( '' as ehpma_svt_delivering_region ) as DeliveringRegion,
      cast( '' as ehpma_svt_source_is_bwrhs ) as DlvgLocationIsBondedWarehouse,
      cast( '' as ehpma_svt_target_is_bwrhs ) as RcvgLocationIsBondedWarehouse
}
union select from I_SVTPurgPrprocgDocument
{
  key SVTConfirmedPurchasingDocUUID as SVTPreprocessedDocumentUUID,
      MaterialDocument,
      Material,
      Quantity,
      QuantityUnit,
      MaterialDocumentItem,
      MaterialDocumentYear,
      ReceivingCompanyCode          as CompanyCode,
      ReceivingPlant                as Plant,
      PostingDate,
      CreationTime,
      CreationDateTime,
      SVTPreprocessingStatus,
      OrderQuantity,
      OrderQuantityUnit,
      IsDeleted,
      GoodsMovementType,
      DebitCreditCode,
      AccountingDocumentType,
      InventoryTransactionType,
      ProdCmplncEventUUID,
      SVTBusinessProcessCategory,
      DeliveringCountry,
      SupplierIsImporter,
      IsReturnsItem,
      DeliveringRegion,
      DlvgLocationIsBondedWarehouse,
      RcvgLocationIsBondedWarehouse
}
union select from I_SVTSalesPrprocgDocument
{
  key SVTConfirmedSalesDocUUID as SVTPreprocessedDocumentUUID,
      MaterialDocument,
      Material,
      Quantity,
      QuantityUnit,
      MaterialDocumentItem,
      MaterialDocumentYear,
      SellingCompanyCode       as CompanyCode,
      SellingPlant             as Plant,
      PostingDate,
      CreationTime,
      CreationDateTime,
      SVTPreprocessingStatus,
      OrderQuantity,
      OrderQuantityUnit,
      IsDeleted,
      GoodsMovementType,
      DebitCreditCode,
      AccountingDocumentType,
      InventoryTransactionType,
      ProdCmplncEventUUID,
      SVTBusinessProcessCategory,
      DeliveringCountry,
      SupplierIsImporter,
      IsReturnsItem,
      DeliveringRegion,
      DlvgLocationIsBondedWarehouse,
      RcvgLocationIsBondedWarehouse
}

Learn More