P_MDChgProcCustClAssgmtWthNmbr

DDL: P_MDCHGPROCCUSTCLASSGMTWTHNMBR SQL: PMDCCUSTCLASSNNO Type: view BASIC
29 Fields 10 Data Sources

P_MDChgProcCustClAssgmtWthNmbr is a Basic CDS View in SAP S/4HANA. It reads from 10 data sources and exposes 29 fields with key fields source_id, mafid, klart, source_clint, adzhl.

Data Sources (10)

SourceAliasJoin Type
but000 but000 from
but000 but000 union
cvi_cust_link cust_link inner
klah klah inner
klah klah inner
kna1 kna1 inner
kna1 kna1 inner
P_MDChgProcCustClAssgmt kssk inner
P_MDChgProcCustClAssgmt kssk inner
mdg_mlt_assgmnt mlt_assmnt inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMDCCUSTCLASSNNO 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 (29)

KeyFieldSource TableSource FieldDescription
KEY source_id but000 partner With Partner
KEY mafid P_MDChgProcCustClAssgmt mafid Record type
KEY klart P_MDChgProcCustClAssgmt klart Class Type
KEY source_clint source_clint Source CLINT
KEY adzhl P_MDChgProcCustClAssgmt adzhl Int. counter
zaehl P_MDChgProcCustClAssgmt zaehl Sort pos.
statu P_MDChgProcCustClAssgmt statu Vehicle Status
stdcl P_MDChgProcCustClAssgmt stdcl Std class
rekri P_MDChgProcCustClAssgmt rekri Recursive
aennr P_MDChgProcCustClAssgmt aennr Change Number
datuv P_MDChgProcCustClAssgmt datuv Valid-from date
lkenz P_MDChgProcCustClAssgmt lkenz Deletion Ind.
datub P_MDChgProcCustClAssgmt datub Valid to
clint P_MDChgProcCustClAssgmt clint Int class no.
KEY source_id but000 partner With Partner
KEY mafid P_MDChgProcCustClAssgmt mafid Record type
KEY klart P_MDChgProcCustClAssgmt klart Class Type
KEY source_clint source_clint Source CLINT
KEY adzhl P_MDChgProcCustClAssgmt adzhl Int. counter
zaehl P_MDChgProcCustClAssgmt zaehl Sort pos.
statu P_MDChgProcCustClAssgmt statu Vehicle Status
stdcl P_MDChgProcCustClAssgmt stdcl Std class
rekri P_MDChgProcCustClAssgmt rekri Recursive
aennr P_MDChgProcCustClAssgmt aennr Change Number
datuv P_MDChgProcCustClAssgmt datuv Valid-from date
lkenz P_MDChgProcCustClAssgmt lkenz Deletion Ind.
datub P_MDChgProcCustClAssgmt datub Valid to
clint P_MDChgProcCustClAssgmt clint Int class no.
class klah class User Group

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_MDChgProcCustClAssgmtWthNmbr.
-- 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: PMDCCUSTCLASSNNO

CREATE VIEW P_MDChgProcCustClAssgmtWthNmbr AS
SELECT
  but000.partner AS source_id,
  kssk.mafid AS mafid,
  kssk.klart AS klart,
  source_clint,
  kssk.adzhl AS adzhl,
  kssk.zaehl AS zaehl,
  kssk.statu AS statu,
  kssk.stdcl AS stdcl,
  kssk.rekri AS rekri,
  kssk.aennr AS aennr,
  kssk.datuv AS datuv,
  kssk.lkenz AS lkenz,
  kssk.datub AS datub,
  kssk.clint AS clint,
  klah.class AS class
FROM but000
INNER JOIN cvi_cust_link AS cust_link ON /* join condition not captured in parsed metadata */
INNER JOIN kna1 ON /* join condition not captured in parsed metadata */
INNER JOIN P_MDChgProcCustClAssgmt AS kssk ON /* join condition not captured in parsed metadata */
INNER JOIN klah ON /* join condition not captured in parsed metadata */
INNER JOIN mdg_mlt_assgmnt AS mlt_assmnt ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): but000
;

Learn More