Arun_I_So_1

DDL: ARUN_I_SO_1 SQL: ARUN_V_I_SO_1 Type: view
61 Fields 5 Data Sources

SO Item level Data selection

Arun_I_So_1 is a CDS View that provides data about "SO Item level Data selection" in SAP S/4HANA. It reads from 5 data sources (vbap, nsdm_e_marc, mara, makt, tmvf) and exposes 61 fields with key fields client, vbeln, posnr.

Data Sources (5)

SourceAliasJoin Type
vbap i from
nsdm_e_marc m inner
mara ma inner
makt makt left_outer
tmvf tmvf inner

Parameters (1)

NameTypeDefault
p_langu abap.lang

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ARUN_V_I_SO_1 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label SO Item level Data selection view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY client vbap mandt Editing Client
KEY vbeln vbap vbeln SD Sched. Agmt
KEY posnr vbap posnr WBS Element
matnr vbap matnr Vehicle Model
charg vbap charg Chargeable Proc.
matkl vbap matkl Product Sold Group
mvgr1 vbap mvgr1 MaterialGroup 1
werks vbap werks Receiving Plant
lgort vbap lgort Sublocation
fsh_candate vbap fsh_candate Cancel Date
hfsh_candate vbap fsh_candate Cancel Date
sgt_rcat vbap sgt_rcat Req. Segment
meins vbap meins Valuation Unit
fsh_season vbap fsh_season Season
fsh_theme vbap fsh_theme Theme
grkor vbap grkor Delivery Group
uepos vbap uepos Higher-Lev.Item
lprio vbap lprio Delivery Prior.
sobkz vbap sobkz Special Stock
shkzg vbap shkzg Returns
kowrr vbap kowrr Stat. Value
stdat vbap stdat Status Change
stlnr vbap stlnr BOM
sposn vbap sposn Item
bedae vbap bedae Reqmts type
pstyv vbap pstyv Item Category
fsh_vas_rel vbap fsh_vas_rel VAS Relevant
fsh_item vbap fsh_item Item Number
lfsta vbap lfsta Delivery Status
vstel vbap vstel ShpPtDeparture
mtvfp vbap mtvfp Avail. check
berid vbap berid Single-Character Flag
route vbap route Vehicle route
fixmg vbap fixmg Planned qty
kdgrp_ana vbap kdgrp_ana Customer Group
satnr mara satnr Cross-plant CM
spart vbap spart Source supplier
xchpf nsdm_e_marc xchpf Batch Mgmt Rqt(Plnt)
dismm nsdm_e_marc dismm MRP Type
sgt_stk_prt nsdm_e_marc sgt_stk_prt Stk Prot.
sgt_covs nsdm_e_marc sgt_covs Segment. Strategy
color_atinn mara color_atinn Internal Char.
size1_atinn mara size1_atinn Internal Char.
size2_atinn mara size2_atinn Internal Char.
color mara color Level Color
size1 mara size1 Size 1
size2 mara size2 Size 2
fsh_mg_at1 mara fsh_mg_at1 Fsh. Attribute1
fsh_mg_at2 mara fsh_mg_at2 Fsh. Attribute2
fsh_mg_at3 mara fsh_mg_at3 Fsh. Attribute3
attyp mara attyp Trdg Goods Cat.
maktg makt maktg Description
ilfgsa lfgsa Ovrl Deliv. Sts
iuvall uvall Overall Header
iuvvlk uvvlk Delivery – Item
iuvfak uvfak Billing Doc.
netpr netpr Price
netwr netwr Value
waerk waerk Doc. Currency
sgt_scope mara sgt_scope Seg. Scope
klmeng vbap klmeng CumltvConfdQty

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 Arun_I_So_1.
-- 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: ARUN_V_I_SO_1
-- Parameters: p_langu : abap.lang

CREATE VIEW Arun_I_So_1 AS
SELECT
  i.mandt AS client,
  i.vbeln AS vbeln,
  i.posnr AS posnr,
  i.matnr AS matnr,
  i.charg AS charg,
  i.matkl AS matkl,
  i.mvgr1 AS mvgr1,
  i.werks AS werks,
  i.lgort AS lgort,
  i.fsh_candate AS fsh_candate,
  i.fsh_candate AS hfsh_candate,
  i.sgt_rcat AS sgt_rcat,
  i.meins AS meins,
  i.fsh_season AS fsh_season,
  i.fsh_theme AS fsh_theme,
  i.grkor AS grkor,
  i.uepos AS uepos,
  i.lprio AS lprio,
  i.sobkz AS sobkz,
  i.shkzg AS shkzg,
  i.kowrr AS kowrr,
  i.stdat AS stdat,
  i.stlnr AS stlnr,
  i.sposn AS sposn,
  i.bedae AS bedae,
  i.pstyv AS pstyv,
  i.fsh_vas_rel AS fsh_vas_rel,
  i.fsh_item AS fsh_item,
  i.lfsta AS lfsta,
  i.vstel AS vstel,
  i.mtvfp AS mtvfp,
  i.berid AS berid,
  i.route AS route,
  i.fixmg AS fixmg,
  i.kdgrp_ana AS kdgrp_ana,
  ma.satnr AS satnr,
  i.spart AS spart,
  m.xchpf AS xchpf,
  m.dismm AS dismm,
  m.sgt_stk_prt AS sgt_stk_prt,
  m.sgt_covs AS sgt_covs,
  ma.color_atinn AS color_atinn,
  ma.size1_atinn AS size1_atinn,
  ma.size2_atinn AS size2_atinn,
  ma.color AS color,
  ma.size1 AS size1,
  ma.size2 AS size2,
  ma.fsh_mg_at1 AS fsh_mg_at1,
  ma.fsh_mg_at2 AS fsh_mg_at2,
  ma.fsh_mg_at3 AS fsh_mg_at3,
  ma.attyp AS attyp,
  makt.maktg AS maktg,
  lfgsa AS ilfgsa,
  uvall AS iuvall,
  uvvlk AS iuvvlk,
  uvfak AS iuvfak,
  netpr,
  netwr,
  waerk,
  ma.sgt_scope AS sgt_scope,
  i.klmeng AS klmeng
FROM vbap AS i
INNER JOIN tmvf ON /* join condition not captured in parsed metadata */
INNER JOIN mara AS ma ON /* join condition not captured in parsed metadata */
INNER JOIN nsdm_e_marc AS m ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN makt ON /* join condition not captured in parsed metadata */
;

Learn More