I_RO_SAFTMatlInitialValue

DDL: I_RO_SAFTMATLINITIALVALUE SQL: IROSAFTINITVAL Type: view COMPOSITE Package: GLO_LOG_SAFT_RO
6 Fields 1 Data Sources

Initial Value of Stocks RO SAFT

I_RO_SAFTMatlInitialValue is a Composite CDS View that provides data about "Initial Value of Stocks RO SAFT" in SAP S/4HANA. It reads from 1 data source (acdoca_m_extract) and exposes 6 fields with key fields SourceLedger, CompanyCode, Material, Plant, Supplier. Part of development package GLO_LOG_SAFT_RO.

Data Sources (1)

SourceAliasJoin Type
acdoca_m_extract acdoca_m_extract from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IROSAFTINITVAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
EndUserText.label Initial Value of Stocks RO SAFT view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger rldnr Ledger (Compat.)
KEY CompanyCode rbukrs Company Code
KEY Material matnr Vehicle Model
KEY Plant bwkey Valuation Area
KEY Supplier ml_lifnr Vendor of Inv.
GoodsMovementStkAmtInCCCrcy

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_RO_SAFTMatlInitialValue.
-- 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: IROSAFTINITVAL

CREATE VIEW I_RO_SAFTMatlInitialValue AS
SELECT
  rldnr AS SourceLedger,
  rbukrs AS CompanyCode,
  matnr AS Material,
  bwkey AS Plant,
  ml_lifnr AS Supplier,
  sum( hsl ) AS GoodsMovementStkAmtInCCCrcy
FROM acdoca_m_extract
;

Learn More