I_SVTPreprocessedDocuments

DDL: I_SVTPREPROCESSEDDOCUMENTS SQL: ISVTPREPROCDOC Type: view COMPOSITE
29 Fields 3 Data Sources

Union view of the Preprocessed Documents

I_SVTPreprocessedDocuments is a Composite CDS View that provides data about "Union view of the Preprocessed Documents" in SAP S/4HANA. It reads from 3 data sources (I_SVTProdnPrprocgDocument, I_SVTPurgPrprocgDocument, I_SVTSalesPrprocgDocument) and exposes 29 fields with key field SVTPreprocessedDocumentUUID.

Data Sources (3)

SourceAliasJoin Type
I_SVTProdnPrprocgDocument I_SVTProdnPrprocgDocument from
I_SVTPurgPrprocgDocument I_SVTPurgPrprocgDocument union
I_SVTSalesPrprocgDocument I_SVTSalesPrprocgDocument union

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISVTPREPROCDOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Union view of the Preprocessed Documents view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY SVTPreprocessedDocumentUUID SVTConfirmedProductionDocUUID UUID for PROCO
MaterialDocument MaterialDocument Material Doc.
Material Material Vehicle Model
Quantity Quantity Value
QuantityUnit QuantityUnit Unit of measure
MaterialDocumentItem MaterialDocumentItem Material Document Item
MaterialDocumentYear MaterialDocumentYear Material Document Year
CompanyCode ProductionCompanyCode Selling Company Code
Plant ProductionPlant Selling Plant
PostingDate PostingDate Posting Date for GR
MaterialDocument MaterialDocument Material Doc.
Material Material Vehicle Model
Quantity Quantity Value
QuantityUnit QuantityUnit Unit of measure
MaterialDocumentItem MaterialDocumentItem Material Document Item
MaterialDocumentYear MaterialDocumentYear Material Document Year
CompanyCode ReceivingCompanyCode Selling Company Code
Plant ReceivingPlant Selling Plant
PostingDate PostingDate Posting Date for GR
MaterialDocument MaterialDocument Material Doc.
Material Material Vehicle Model
Quantity Quantity Value
QuantityUnit QuantityUnit Unit of measure
MaterialDocumentItem MaterialDocumentItem Material Document Item
MaterialDocumentYear MaterialDocumentYear Material Document Year
CompanyCode SellingCompanyCode Selling Company Code
Plant SellingPlant Selling Plant
PostingDate PostingDate Posting Date for GR
CreationTime CreationTime Time of Change

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_SVTPreprocessedDocuments.
-- 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: ISVTPREPROCDOC

CREATE VIEW I_SVTPreprocessedDocuments AS
SELECT
  SVTConfirmedProductionDocUUID AS SVTPreprocessedDocumentUUID,
  MaterialDocument,
  Material,
  Quantity,
  QuantityUnit,
  MaterialDocumentItem,
  MaterialDocumentYear,
  ProductionCompanyCode AS CompanyCode,
  ProductionPlant AS Plant,
  PostingDate,
  CreationTime
FROM I_SVTProdnPrprocgDocument
-- UNION with additional select branch(es): I_SVTPurgPrprocgDocument, I_SVTSalesPrprocgDocument
;

Learn More