I_CstrtSwMatFinalDoc

DDL: I_CSTRTSWMATFINALDOC SQL: ICSTRTSWFINALDOC Type: view BASIC
4 Fields 1 Data Sources

Final Document Number for Software

I_CstrtSwMatFinalDoc is a Basic CDS View that provides data about "Final Document Number for Software" in SAP S/4HANA. It reads from 1 data source (I_CstrtSwMatlAllVers) and exposes 4 fields with key fields Material, DocumentPart, DocumentType.

Data Sources (1)

SourceAliasJoin Type
I_CstrtSwMatlAllVers I_CstrtSwMatlAllVers from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICSTRTSWFINALDOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Final Document Number for Software view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY DocumentPart DocumentPart Document Part
KEY DocumentType DocumentType Order Type
DocNumber

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_CstrtSwMatFinalDoc.
-- 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: ICSTRTSWFINALDOC

CREATE VIEW I_CstrtSwMatFinalDoc AS
SELECT
  Material,
  DocumentPart,
  DocumentType,
  min(DocNumber) AS DocNumber
FROM I_CstrtSwMatlAllVers
;

Learn More