R_SVTProcdMaterialDocumentTP

DDL: R_SVTPROCDMATERIALDOCUMENTTP Type: view_entity TRANSACTIONAL Package: EHPMA_CNS_SVT

Processed Material Document - TP

R_SVTProcdMaterialDocumentTP is a Transactional CDS View that provides data about "Processed Material Document - TP" in SAP S/4HANA. It reads from 1 data source (I_SVTPreprocessedDocuments) and exposes 43 fields with key field SVTPreprocessedDocumentUUID. It has 15 associations to related views. Part of development package EHPMA_CNS_SVT.

Data Sources (1)

SourceAliasJoin Type
I_SVTPreprocessedDocuments SVTPreprocessedDocuments from

Associations (15)

CardinalityTargetAliasCondition
[0..1] I_SVTPurgPrprocgDocument _PurchasingDocs $projection.SVTPreprocessedDocumentUUID = _PurchasingDocs.SVTConfirmedPurchasingDocUUID
[0..1] I_SVTProdnPrprocgDocument _ProductionDocs $projection.SVTPreprocessedDocumentUUID = _ProductionDocs.SVTConfirmedProductionDocUUID
[0..1] I_SVTSalesPrprocgDocument _SalesDocs $projection.SVTPreprocessedDocumentUUID = _SalesDocs.SVTConfirmedSalesDocUUID
[0..1] I_SVTPreprocessingStatus _PreprocessingStatus $projection.SVTPreprocessingStatus = _PreprocessingStatus.SVTPreprocessingStatus
[0..1] I_SVTBizProcessCategory _SVTBizProcCategory $projection.SVTBusinessProcessCategory = _SVTBizProcCategory.SVTBusinessProcessCategory
[1..1] I_SVTProdCmplncEvent _SVTProdCmplncEvent $projection.ProdCmplncEventUUID = _SVTProdCmplncEvent.ProdCmplncEventUUID
[0..1] I_Country _DeliveringCountry $projection.DeliveringCountry = _DeliveringCountry.Country
[1..1] I_UnitOfMeasure _UnitOfMeasure $projection.QuantityUnit = _UnitOfMeasure.UnitOfMeasure
[0..1] I_PlantVH _Plant $projection.Plant = _Plant.Plant
[0..1] I_CompanyCodeVH _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_ProdCmplncEventType _ProdCmplncEventType $projection.prodcmplnceventtype = _ProdCmplncEventType.ProdCmplncEventType
[0..1] I_GoodsMovementType _GoodsMovementType $projection.GoodsMovementType = _GoodsMovementType.GoodsMovementType
[0..1] I_InventoryTransactionType _InventoryTransactionType $projection.InventoryTransactionType = _InventoryTransactionType.InventoryTransactionType
[0..1] I_AccountingDocumentType _AccountingDocumentType $projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType
[0..1] I_DebitCreditCode _DebitCreditCode $projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Processed Material Document - TP view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY SVTPreprocessedDocumentUUID SVTPreprocessedDocumentUUID
MaterialDocument MaterialDocument
MaterialDocumentItem MaterialDocumentItem
MaterialDocumentYear MaterialDocumentYear
Material Material
PostingDate PostingDate
CreationTime CreationTime
CreationDateTime CreationDateTime
Quantity Quantity
QuantityUnit QuantityUnit
SVTPreprocessingStatus SVTPreprocessingStatus
Plant Plant
PlantName _Plant PlantName
CompanyCode CompanyCode
CompanyCodeName _CompanyCode CompanyCodeName
OrderQuantity OrderQuantity
OrderQuantityUnit OrderQuantityUnit
IsDeleted IsDeleted
GoodsMovementType GoodsMovementType
DebitCreditCode DebitCreditCode
AccountingDocumentType AccountingDocumentType
InventoryTransactionType InventoryTransactionType
ProdCmplncEventUUID ProdCmplncEventUUID
ProdCmplncEventType _SVTProdCmplncEvent ProdCmplncEventType
DeliveringCountry DeliveringCountry
SupplierIsImporter SupplierIsImporter
IsReturnsItem IsReturnsItem
DeliveringRegion DeliveringRegion
DlvgLocationIsBondedWarehouse DlvgLocationIsBondedWarehouse
RcvgLocationIsBondedWarehouse RcvgLocationIsBondedWarehouse
SVTBusinessProcessCategory SVTBusinessProcessCategory
_PurchasingDocs _PurchasingDocs
_ProductionDocs _ProductionDocs
_SalesDocs _SalesDocs
_PreprocessingStatus _PreprocessingStatus
_ProdCmplncEventType _ProdCmplncEventType
_SVTBizProcCategory _SVTBizProcCategory
_DeliveringCountry _DeliveringCountry
_GoodsMovementType _GoodsMovementType
_InventoryTransactionType _InventoryTransactionType
_AccountingDocumentType _AccountingDocumentType
_DebitCreditCode _DebitCreditCode
_UnitOfMeasure _UnitOfMeasure
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Processed Material Document - TP'
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel: {
    usageType:{
        dataClass: #MIXED,
        serviceQuality: #C,  // If #B: Prio 2 View ... (serviceQuality '...') has more than 5 underlying tables (...)

        sizeCategory: #L
      }
}

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
define view entity R_SVTProcdMaterialDocumentTP
  as select from I_SVTPreprocessedDocuments as SVTPreprocessedDocuments
  association [0..1] to I_SVTPurgPrprocgDocument   as _PurchasingDocs           on $projection.SVTPreprocessedDocumentUUID = _PurchasingDocs.SVTConfirmedPurchasingDocUUID
  association [0..1] to I_SVTProdnPrprocgDocument  as _ProductionDocs           on $projection.SVTPreprocessedDocumentUUID = _ProductionDocs.SVTConfirmedProductionDocUUID
  association [0..1] to I_SVTSalesPrprocgDocument  as _SalesDocs                on $projection.SVTPreprocessedDocumentUUID = _SalesDocs.SVTConfirmedSalesDocUUID
  association [0..1] to I_SVTPreprocessingStatus   as _PreprocessingStatus      on $projection.SVTPreprocessingStatus = _PreprocessingStatus.SVTPreprocessingStatus
  association [0..1] to I_SVTBizProcessCategory    as _SVTBizProcCategory       on $projection.SVTBusinessProcessCategory = _SVTBizProcCategory.SVTBusinessProcessCategory
  association [1..1] to I_SVTProdCmplncEvent       as _SVTProdCmplncEvent       on $projection.ProdCmplncEventUUID = _SVTProdCmplncEvent.ProdCmplncEventUUID
  association [0..1] to I_Country                  as _DeliveringCountry        on $projection.DeliveringCountry = _DeliveringCountry.Country
  association [1..1] to I_UnitOfMeasure            as _UnitOfMeasure            on $projection.QuantityUnit = _UnitOfMeasure.UnitOfMeasure
  association [0..1] to I_PlantVH                  as _Plant                    on $projection.Plant = _Plant.Plant
  association [0..1] to I_CompanyCodeVH            as _CompanyCode              on $projection.CompanyCode = _CompanyCode.CompanyCode
  association [1..1] to I_ProdCmplncEventType      as _ProdCmplncEventType      on $projection.prodcmplnceventtype = _ProdCmplncEventType.ProdCmplncEventType
  association [0..1] to I_GoodsMovementType        as _GoodsMovementType        on $projection.GoodsMovementType = _GoodsMovementType.GoodsMovementType
  association [0..1] to I_InventoryTransactionType as _InventoryTransactionType on $projection.InventoryTransactionType = _InventoryTransactionType.InventoryTransactionType
  association [0..1] to I_AccountingDocumentType   as _AccountingDocumentType   on $projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType
  association [0..1] to I_DebitCreditCode          as _DebitCreditCode          on $projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode
{
  key SVTPreprocessedDocumentUUID,
      MaterialDocument,
      MaterialDocumentItem,
      MaterialDocumentYear,
      Material,
      PostingDate,
      CreationTime,
      CreationDateTime,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      Quantity,
      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      QuantityUnit,
      SVTPreprocessingStatus,
      Plant,
      _Plant.PlantName,
      CompanyCode,
      _CompanyCode.CompanyCodeName,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      OrderQuantity,
      OrderQuantityUnit,
      IsDeleted,
      GoodsMovementType,
      DebitCreditCode,
      AccountingDocumentType,
      InventoryTransactionType,
      ProdCmplncEventUUID,
      _SVTProdCmplncEvent.ProdCmplncEventType,
      DeliveringCountry,
      SupplierIsImporter,
      IsReturnsItem,
      DeliveringRegion,
      DlvgLocationIsBondedWarehouse,
      RcvgLocationIsBondedWarehouse,
      SVTBusinessProcessCategory,

      _PurchasingDocs,
      _ProductionDocs,
      _SalesDocs,
      _PreprocessingStatus,
      _ProdCmplncEventType,
      _SVTBizProcCategory,
      _DeliveringCountry,
      _GoodsMovementType,
      _InventoryTransactionType,
      _AccountingDocumentType,
      _DebitCreditCode,
      _UnitOfMeasure
}