P_MDChgProcCustValn

DDL: P_MDCHGPROCCUSTVALN SQL: PMDCCUSTVALN Type: view BASIC
51 Fields 4 Data Sources

P_MDChgProcCustValn is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (ausp, ausp, inob, tcla) and exposes 51 fields with key fields objek, source_atinn, atzhl, mafid, klart.

Data Sources (4)

SourceAliasJoin Type
ausp ausp from
ausp ausp inner
inob inob union
tcla tcla inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMDCCUSTVALN view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY objek ausp objek Object
KEY source_atinn ausp atinn Internal char.
KEY atzhl ausp atzhl Int counter
KEY mafid ausp mafid Record type
KEY klart ausp klart Class Type
atinn ausp atinn Internal char.
adzhl ausp adzhl Int. counter
atwrt ausp atwrt Char. Value
atflv ausp atflv Value from
atawe ausp atawe Internal UoM
atflb ausp atflb Value to
ataw1 ausp ataw1 Internal UoM
atcod ausp atcod Interval limits
attlv ausp attlv Tolerance from
attlb ausp attlb Tolerance to
atprz ausp atprz Percentage
atinc ausp atinc Increment
ataut ausp ataut Justification
aennr ausp aennr Change Number
datuv ausp datuv Valid-from date
lkenz ausp lkenz Deletion Ind.
atimb ausp atimb Internal char.
atzis ausp atzis Instance cntr
atsrt ausp atsrt Position
atvglart ausp atvglart Comp. type
objek Object
KEY source_atinn ausp atinn Internal char.
KEY atzhl ausp atzhl Int counter
KEY mafid ausp mafid Record type
KEY klart ausp klart Class Type
atinn ausp atinn Internal char.
adzhl ausp adzhl Int. counter
atwrt ausp atwrt Char. Value
atflv ausp atflv Value from
atawe ausp atawe Internal UoM
atflb ausp atflb Value to
ataw1 ausp ataw1 Internal UoM
atcod ausp atcod Interval limits
attlv ausp attlv Tolerance from
attlb ausp attlb Tolerance to
atprz ausp atprz Percentage
atinc ausp atinc Increment
ataut ausp ataut Justification
aennr ausp aennr Change Number
datuv ausp datuv Valid-from date
lkenz ausp lkenz Deletion Ind.
atimb ausp atimb Internal char.
atzis ausp atzis Instance cntr
atsrt ausp atsrt Position
atvglart ausp atvglart Comp. type
datub ausp datub Valid to

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 P_MDChgProcCustValn.
-- 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: PMDCCUSTVALN

CREATE VIEW P_MDChgProcCustValn AS
SELECT
  ausp.objek AS objek,
  ausp.atinn AS source_atinn,
  ausp.atzhl AS atzhl,
  ausp.mafid AS mafid,
  ausp.klart AS klart,
  ausp.atinn AS atinn,
  ausp.adzhl AS adzhl,
  ausp.atwrt AS atwrt,
  ausp.atflv AS atflv,
  ausp.atawe AS atawe,
  ausp.atflb AS atflb,
  ausp.ataw1 AS ataw1,
  ausp.atcod AS atcod,
  ausp.attlv AS attlv,
  ausp.attlb AS attlb,
  ausp.atprz AS atprz,
  ausp.atinc AS atinc,
  ausp.ataut AS ataut,
  ausp.aennr AS aennr,
  ausp.datuv AS datuv,
  ausp.lkenz AS lkenz,
  ausp.atimb AS atimb,
  ausp.atzis AS atzis,
  ausp.atsrt AS atsrt,
  ausp.atvglart AS atvglart,
  ausp.datub AS datub
FROM ausp
INNER JOIN tcla ON /* join condition not captured in parsed metadata */
INNER JOIN ausp ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): inob
;

Learn More