SDM_IR_A0XX

DDL: SDM_IR_BLANK_A0XX SQL: SDMIRA0XX Type: view Package: APPL_MM_PUR_INFORECORD_TR
31 Fields 6 Data Sources

SDM View for Blank A table entries

SDM_IR_A0XX is a CDS View that provides data about "SDM View for Blank A table entries" in SAP S/4HANA. It reads from 6 data sources and exposes 31 fields. Part of development package APPL_MM_PUR_INFORECORD_TR.

Data Sources (6)

SourceAliasJoin Type
a017 _017 union_all
a018 _018 from
a025 _025 union_all
a028 _028 union_all
a066 _066 union_all
a067 _067 union_all

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName SDMIRA0XX view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (31)

KeyFieldSource TableSource FieldDescription
mandt a018 mandt Editing Client
knumh a018 knumh NoCondRec.Batch
kschl a018 kschl Tax Item Type
datab a018 datab Validity period
kotabnr
mandtasmandt
knumh a017 knumh NoCondRec.Batch
kschl a017 kschl Tax Item Type
datab a017 datab Validity period
kotabnr
mandtasmandt
knumh a025 knumh NoCondRec.Batch
kschl a025 kschl Tax Item Type
datab a025 datab Validity period
kotabnr
mandtasmandt
knumh a028 knumh NoCondRec.Batch
kschl a028 kschl Tax Item Type
datab a028 datab Validity period
kotabnr
mandtasmandt
knumh a066 knumh NoCondRec.Batch
kschl a066 kschl Tax Item Type
datab a066 datab Validity period
kotabnr
mandtasmandt
knumh a067 knumh NoCondRec.Batch
kschl a067 kschl Tax Item Type
datab a067 datab Validity period
kotabnr
sdm_status

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 SDM_IR_A0XX.
-- 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: SDMIRA0XX

CREATE VIEW SDM_IR_A0XX AS
SELECT
  _018.mandt AS mandt,
  _018.knumh AS knumh,
  _018.kschl AS kschl,
  _018.datab AS datab,
  cast('018' as kotabnr) AS kotabnr,
  '00' as sdm_status AS mandtasmandt,
  '00' AS sdm_status
FROM a018 AS _018
-- UNION ALL with additional select branch(es): a017, a025, a028, a066, a067
;

Learn More