pph_e_Mdbs_2
pph_e_Mdbs_2 is a CDS View in SAP S/4HANA. It reads from 1 data source (pph_e_Mdbs_1) and exposes 76 fields.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| pph_e_Mdbs_1 | pph_e_Mdbs_1 | from |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | V_PPH_MDBS_2 | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ClientHandling.algorithm | #AUTOMATED | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view |
Fields (76)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| matnr | matnr | Vehicle Model | ||
| werks | werks | Receiving Plant | ||
| sgt_scat | sgt_scat | Stock Segment | ||
| sgt_rcat | sgt_rcat | Req. Segment | ||
| umrez | umrez | Numerator | ||
| umren | umren | Denominator | ||
| webaz | webaz | GR Proc. Time | ||
| fix01 | fix01 | Fixed Lot Size | ||
| fix02 | fix02 | Fixed explosion | ||
| bstyp | bstyp | Source doc.cat. | ||
| eglkz | eglkz | Final Delivery | ||
| pstyp | pstyp | Item Category | ||
| retpo | retpo | Returns Item | ||
| ebeln | ebeln | Source PurchDoc | ||
| ebelp | ebelp | Item pur. doc. | ||
| lgort | lgort | Sublocation | ||
| delnr | delnr | Order No.(OLTP) | ||
| delps | delps | Order Item | ||
| revlv | revlv | Revision Level | ||
| arsnr | arsnr | Settle.reser.No | ||
| arsps | arsps | Settle.item no. | ||
| knttp | knttp | AcctAssgnCat:CC | ||
| kzvbr | kzvbr | Consumption | ||
| sobkz | sobkz | Special Stock | ||
| kzbws | kzbws | Valuation | ||
| reslo | reslo | Iss. Stor. Loc. | ||
| prio_urg | prio_urg | Reqmt Urgency | ||
| prio_req | prio_req | Reqmt Priority | ||
| statu | statu | Vehicle Status | ||
| wepos | wepos | Goods Receipt | ||
| insmk | insmk | Stock Type | ||
| etfz2 | etfz2 | Trade-Off Zone | ||
| mdbs_itcons | mdbs_itcons | |||
| mdbs_statu | mdbs_statu | |||
| mdbs_wepos | mdbs_wepos | |||
| mdbs_emlif | mdbs_emlif | |||
| mdbs_lblkz | mdbs_lblkz | |||
| mdbs_insmk | mdbs_insmk | |||
| mdbs_bstme | mdbs_bstme | |||
| mng01 | mng01 | Rec./reqd qty | ||
| mng02 | mng02 | Scrap | ||
| auftm | auftm | |||
| etmen | etmen | |||
| glmng | glmng | Qty Delivered | ||
| etenr | etenr | Schedule Line | ||
| uzeit | uzeit | Time | ||
| dat01 | dat01 | Finish date | ||
| bedat | bedat | Start date | ||
| delet | delet | Scheduling | ||
| rsnum | rsnum | Reservation | ||
| sernr | sernr | Serial Number | ||
| verid | verid | Version ID | ||
| qunum | qunum | Quota arr. | ||
| qupos | qupos | Quota arr. item | ||
| mdbs_no_disp | mdbs_no_disp | |||
| wrk02 | wrk02 | Plant | ||
| lifnr | lifnr | Vendor no. | ||
| beskz | beskz | Procuremt Type | ||
| sort1 | sort1 | Sort string 1 | ||
| sort2 | sort2 | Sort string 2 | ||
| delkz | delkz | MRP Elmnt Ind. | ||
| plumi | plumi | Plus/minus | ||
| sobes | sobes | Spec. procuremt | ||
| charg | charg | Chargeable Proc. | ||
| dbskz | dbskz | Direct procure. | ||
| mdbs_loekz | mdbs_loekz | |||
| mdbs_aktnr | mdbs_aktnr | |||
| fls_rsto | fls_rsto | Enh. Store Ret. | ||
| mdbs_ameng | mdbs_ameng | |||
| mdbs_fixmg | mdbs_fixmg | |||
| mdbs_eglkz | mdbs_eglkz | |||
| mdbs_kzfix | mdbs_kzfix | |||
| mdbs_etfz1 | mdbs_etfz1 | |||
| mdbs_etfz2 | mdbs_etfz2 | |||
| mdbs_etdrk | mdbs_etdrk | |||
| calculateBASISMNG |
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 pph_e_Mdbs_2.
-- 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: V_PPH_MDBS_2
CREATE VIEW pph_e_Mdbs_2 AS
SELECT
matnr,
werks,
sgt_scat,
sgt_rcat,
umrez,
umren,
webaz,
fix01,
fix02,
bstyp,
eglkz,
pstyp,
retpo,
ebeln,
ebelp,
lgort,
delnr,
delps,
revlv,
arsnr,
arsps,
knttp,
kzvbr,
sobkz,
kzbws,
reslo,
prio_urg,
prio_req,
statu,
wepos,
insmk,
etfz2,
mdbs_itcons,
mdbs_statu,
mdbs_wepos,
mdbs_emlif,
mdbs_lblkz,
mdbs_insmk,
mdbs_bstme,
mng01,
mng02,
auftm,
etmen,
glmng,
etenr,
uzeit,
dat01,
bedat,
delet,
rsnum,
sernr,
verid,
qunum,
qupos,
mdbs_no_disp,
wrk02,
lifnr,
beskz,
sort1,
sort2,
delkz,
plumi,
sobes,
charg,
dbskz,
mdbs_loekz,
mdbs_aktnr,
fls_rsto,
mdbs_ameng,
mdbs_fixmg,
mdbs_eglkz,
mdbs_kzfix,
mdbs_etfz1,
mdbs_etfz2,
mdbs_etdrk
FROM pph_e_Mdbs_1
;
Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA