oib_e_mardo1_ag

DDL: OIB_DDL_MARDO1_AG SQL: OIB_V_MARDO1_AG Type: view
7 Fields 2 Data Sources

MARDO1 Compatibility View: Aggregation

oib_e_mardo1_ag is a CDS View that provides data about "MARDO1 Compatibility View: Aggregation" in SAP S/4HANA. It reads from 2 data sources (matdocoil_index, matdocoilextract) and exposes 7 fields with key fields mandt, matnr, werks, lgort, msehi.

Data Sources (2)

SourceAliasJoin Type
matdocoil_index i inner
matdocoilextract m from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName OIB_V_MARDO1_AG view
EndUserText.label MARDO1 Compatibility View: Aggregation view
DataAging.noAgingRestriction false view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_ALLOWED view
AbapCatalog.viewEnhancementCategory #PROJECTION_LIST view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY mandt matdocoilextract mandt Editing Client
KEY matnr matdocoilextract matbf Stock Mat.
KEY werks matdocoilextract werks Receiving Plant
KEY lgort matdocoilextract lgort_sid Stor. Location SID
KEY msehi matdocoil_index msehi Unit of measmnt
lbbsa matdocoilextract lbbsa_sid Stock Type
sobkz matdocoilextract sobkz Special Stock

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 oib_e_mardo1_ag.
-- 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: OIB_V_MARDO1_AG

CREATE VIEW oib_e_mardo1_ag AS
SELECT
  m.mandt AS mandt,
  m.matbf AS matnr,
  m.werks AS werks,
  m.lgort_sid AS lgort,
  i.msehi AS msehi,
  m.lbbsa_sid AS lbbsa,
  m.sobkz AS sobkz
FROM matdocoilextract AS m
INNER JOIN matdocoil_index AS i ON /* join condition not captured in parsed metadata */
;

Learn More