FMLV_PRDH_UCT

DDL: FMLV_PRDH_UCT SQL: FMLPRDHUCT Type: view

Super Join: MLORDERHIST/MLAUF/MLAUFCR

FMLV_PRDH_UCT is a CDS View that provides data about "Super Join: MLORDERHIST/MLAUF/MLAUFCR" in SAP S/4HANA. It reads from 2 data sources (mlorderhist, FMLV_MLAUFMFCR_UCT_UNION) and exposes 37 fields with key fields mlvnr, VGABE, GJAHR, BELNR, BUZEI.

2 data source(s) 37 fields

Data Sources (2)

SourceAliasJoin Type
mlorderhist H from
FMLV_MLAUFMFCR_UCT_UNION M inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FMLPRDHUCT view
EndUserText.label Super Join: MLORDERHIST/MLAUF/MLAUFCR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY mlvnr mlorderhist mlvnr
KEY VGABE FMLV_MLAUFMFCR_UCT_UNION VGABE
KEY GJAHR FMLV_MLAUFMFCR_UCT_UNION GJAHR
KEY BELNR FMLV_MLAUFMFCR_UCT_UNION BELNR
KEY BUZEI FMLV_MLAUFMFCR_UCT_UNION BUZEI
KEY KALNR FMLV_MLAUFMFCR_UCT_UNION KALNR
KEY CURTP FMLV_MLAUFMFCR_UCT_UNION CURTP
aufnr mlorderhist aufnr
posnr mlorderhist posnr
logsys mlorderhist logsys
initpoper mlorderhist initpoper
initbdatj mlorderhist initbdatj
init_done mlorderhist init_done
budat FMLV_MLAUFMFCR_UCT_UNION budat
menge FMLV_MLAUFMFCR_UCT_UNION menge
poper FMLV_MLAUFMFCR_UCT_UNION poper
bdatj FMLV_MLAUFMFCR_UCT_UNION bdatj
hrkft FMLV_MLAUFMFCR_UCT_UNION hrkft
kstar FMLV_MLAUFMFCR_UCT_UNION kstar
bwart FMLV_MLAUFMFCR_UCT_UNION bwart
MLAUF_AUFNR FMLV_MLAUFMFCR_UCT_UNION aufnr
MLAUF_POSNR FMLV_MLAUFMFCR_UCT_UNION posnr
settle_poper FMLV_MLAUFMFCR_UCT_UNION settle_poper
saprl FMLV_MLAUFMFCR_UCT_UNION saprl
MLAUF_CPUDT FMLV_MLAUFMFCR_UCT_UNION cpudt
MLAUF_CPUTM FMLV_MLAUFMFCR_UCT_UNION cputm
xwoff FMLV_MLAUFMFCR_UCT_UNION xwoff
werks FMLV_MLAUFMFCR_UCT_UNION werks
MLAUF_STORNO FMLV_MLAUFMFCR_UCT_UNION storno
meins FMLV_MLAUFMFCR_UCT_UNION meins
bstmg FMLV_MLAUFMFCR_UCT_UNION bstmg
bstme FMLV_MLAUFMFCR_UCT_UNION bstme
MLAUFCR_WAERS FMLV_MLAUFMFCR_UCT_UNION waers
shkzg FMLV_MLAUFMFCR_UCT_UNION shkzg
wrbtr FMLV_MLAUFMFCR_UCT_UNION wrbtr
arewr FMLV_MLAUFMFCR_UCT_UNION arewr
reewr FMLV_MLAUFMFCR_UCT_UNION reewr 
@AbapCatalog.sqlViewName: 'FMLPRDHUCT'
@EndUserText.label: 'Super Join: MLORDERHIST/MLAUF/MLAUFCR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
define view FMLV_PRDH_UCT 
    as select from mlorderhist as H
    inner join FMLV_MLAUFMFCR_UCT_UNION as M on H.mlvnr = M.MLVNR
{
    key H.mlvnr,
    key M.VGABE,
    key M.GJAHR,
    key M.BELNR,
    key M.BUZEI,
    key M.KALNR,
    key M.CURTP,
    H.aufnr,
    H.posnr,
    H.logsys,
    H.initpoper,
    H.initbdatj,
    H.init_done,
    M.budat,
    M.menge,
    M.poper,
    M.bdatj,
    M.hrkft,
    M.kstar,
    M.bwart,
    M.aufnr as MLAUF_AUFNR,
    M.posnr as MLAUF_POSNR,
    M.settle_poper,
    M.saprl,
    M.cpudt as MLAUF_CPUDT,
    M.cputm as MLAUF_CPUTM,
    M.xwoff,
    M.werks,
    M.storno as MLAUF_STORNO,
    M.meins,
    M.bstmg,
    M.bstme,
    M.waers as MLAUFCR_WAERS,
    M.shkzg,
    M.wrbtr,
    M.arewr,
    M.reewr
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FMLV_MLAUFMFCR_UCT_UNION",
"MLORDERHIST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More