I_SVTProdnPrprocgDocument

DDL: I_SVTPRODNPRPROCGDOCUMENT SQL: ISVTPREPROCPRO Type: view BASIC
13 Fields 1 Data Sources 1 Associations

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.

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 UUID for PROCO
MaterialDocument materialdocument Material Doc.
Material material Vehicle Model
Quantity Material Quantity
QuantityUnit materialquantityunit Material Qty Unit
MaterialDocumentItem materialdocumentitem Material Document Item
MaterialDocumentYear materialdocumentyear Material Document Year
ProductionCompanyCode productioncompanycode Prodn Co Code
ProductionPlant productionplant Prod plnt
PostingDate postingdate Posting Date for GR
CreationTime creationtimelogsystem Creation Time
StorageLocation storagelocation StorageLocation
_UnitOfMeasure _UnitOfMeasure

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_SVTProdnPrprocgDocument.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ISVTPREPROCPRO

CREATE VIEW I_SVTProdnPrprocgDocument AS
SELECT
  svtproductionconfirmedqtyuuid AS SVTConfirmedProductionDocUUID,
  MaterialDocument,
  Material,
  cast( materialquantity as ehpma_svt_subst_vol_ui ) AS Quantity,
  materialquantityunit AS QuantityUnit,
  MaterialDocumentItem,
  MaterialDocumentYear,
  ProductionCompanyCode,
  ProductionPlant,
  PostingDate,
  creationtimelogsystem AS CreationTime,
  StorageLocation
FROM ehpmad_svt_proco
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
;

Learn More