I_SVTProdnPrprocgDocument

DDL: I_SVTPRODNPRPROCGDOCUMENT SQL: ISVTPREPROCPRO Type: view BASIC

SVT production preprocessing document.

I_SVTProdnPrprocgDocument is a Basic CDS View that provides data about "SVT production preprocessing document." in SAP S/4HANA. It reads from 1 data source (ehpmad_svt_proco) and exposes 13 fields with key field SVTConfirmedProductionDocUUID. It has 1 association to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
ehpmad_svt_proco ehpmad_svt_proco from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_UnitOfMeasure _UnitOfMeasure $projection.QuantityUnit = _UnitOfMeasure.UnitOfMeasure

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISVTPREPROCPRO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label SVT production preprocessing document. view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY SVTConfirmedProductionDocUUID svtproductionconfirmedqtyuuid
MaterialDocument materialdocument
Material material
Quantity
QuantityUnit materialquantityunit
MaterialDocumentItem materialdocumentitem
MaterialDocumentYear materialdocumentyear
ProductionCompanyCode productioncompanycode
ProductionPlant productionplant
PostingDate postingdate
CreationTime creationtimelogsystem
StorageLocation storagelocation
_UnitOfMeasure _UnitOfMeasure 
@AbapCatalog.sqlViewName: 'ISVTPREPROCPRO'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'SVT production preprocessing document.'
@VDM.viewType: #BASIC

@ObjectModel: {
    usageType:{
        dataClass: #TRANSACTIONAL,
        serviceQuality: #B,
        sizeCategory: #L
      }
}

@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_SVTProdnPrprocgDocument
  as select from ehpmad_svt_proco
  association [1..1] to I_UnitOfMeasure as _UnitOfMeasure on $projection.QuantityUnit = _UnitOfMeasure.UnitOfMeasure
{
  key svtproductionconfirmedqtyuuid                      as SVTConfirmedProductionDocUUID,
      materialdocument                                   as MaterialDocument,
      material                                           as Material,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      cast( materialquantity as ehpma_svt_subst_vol_ui ) as Quantity,
      @Semantics.unitOfMeasure: true
      materialquantityunit                               as QuantityUnit,
      materialdocumentitem                               as MaterialDocumentItem,
      materialdocumentyear                               as MaterialDocumentYear,
      productioncompanycode                              as ProductionCompanyCode,
      productionplant                                    as ProductionPlant,
      postingdate                                        as PostingDate,
      creationtimelogsystem                              as CreationTime,
      storagelocation                                    as StorageLocation,
      _UnitOfMeasure
      //other fields are not selected as they are not needed nor are their GFNs requested

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHPMAD_SVT_PROCO"
],
"ASSOCIATED":
[
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More