P_PurchaseOrderHistory2

DDL: P_PURCHASEORDERHISTORY2 SQL: PMMPURORDHIST2 Type: view BASIC Package: VDM_MM_PUR_PO

Purchase Order History 2

P_PurchaseOrderHistory2 is a Basic CDS View that provides data about "Purchase Order History 2" in SAP S/4HANA. It reads from 2 data sources (ekbe, ekbeh) and exposes 102 fields with key fields ebeln, ebelp, zekkn, vgabe, gjahr. Part of development package VDM_MM_PUR_PO.

2 data source(s) 102 fields

Data Sources (2)

SourceAliasJoin Type
ekbe ekbe from
ekbeh ekbeh union_all

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PMMPURORDHIST2 view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #BASIC view
VDM.private true view

Fields (102)

KeyFieldSource TableSource FieldDescription
KEY ebeln ebeln
KEY ebelp ebelp
KEY zekkn zekkn
KEY vgabe vgabe
KEY gjahr gjahr
KEY belnr belnr
KEY buzei buzei
bewtp bewtp
bwart bwart
budat budat
waers waers
shkzg shkzg
elikz elikz
lfgja lfgja
lfbnr lfbnr
lfpos lfpos
matnr matnr
werks werks
xwsbr xwsbr
knumv knumv
mwskz mwskz
bldat bldat
ernam ernam
bwtar bwtar
xblnr xblnr
lsmeh lsmeh
ematn ematn
cpudt cpudt
menge menge
dmbtr dmbtr
wrbtr wrbtr
bpmng bpmng
arewr arewr
wesbs wesbs
bpwes bpwes
reewr reewr
refwr refwr
lsmng lsmng
areww areww
bamng bamng
arewb arewb
rewrb rewrb
wesbb wesbb
bpweb bpweb
weora weora
kudif kudif
evere evere
lemin lemin
hswae hswae
wkurs wkurs
vbeln_st vbeln_st
KEY ebelp ebelp
KEY zekkn zekkn
KEY vgabe vgabe
KEY gjahr gjahr
KEY belnr belnr
KEY buzei buzei
bewtp bewtp
bwart bwart
budat budat
waers waers
shkzg shkzg
elikz elikz
lfgja lfgja
lfbnr lfbnr
lfpos lfpos
matnr matnr
werks werks
xwsbr xwsbr
knumv knumv
mwskz mwskz
bldat bldat
ernam ernam
bwtar bwtar
xblnr xblnr
lsmeh lsmeh
ematn ematn
cpudt cpudt
menge menge
dmbtr dmbtr
wrbtr wrbtr
bpmng bpmng
arewr arewr
wesbs wesbs
bpwes bpwes
reewr reewr
refwr refwr
lsmng lsmng
areww areww
bamng bamng
arewb arewb
rewrb rewrb
wesbb wesbb
bpweb bpweb
weora weora
kudif kudif
evere evere
lemin lemin
hswae hswae
wkurs wkurs
vbeln_st vbeln_st
vbelp_st vbelp_st 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'PMMPURORDHIST2'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType : #BASIC 
@VDM.private: true

define view P_PurchaseOrderHistory2
 as select from ekbe 
  
 
 {
    key ebeln,
    key ebelp,
    key zekkn,
    key vgabe,
    key gjahr,
    key belnr,
    key buzei,
    bewtp,
    bwart,
    budat,
    waers,
    shkzg,
    elikz,
    lfgja,
    lfbnr,
    lfpos,
    matnr,
    werks,
    xwsbr,
    knumv,
    mwskz,     
    bldat,
    ernam,
    bwtar,
    xblnr,
    lsmeh,
    ematn,    
    cpudt,
    menge,
    dmbtr,
    wrbtr,
    bpmng,
    arewr,
    wesbs,
    bpwes,
    reewr,
    refwr,
    lsmng,
    areww,
    bamng,
    arewb,
    rewrb,
    wesbb,
    bpweb,
    weora,    
    kudif,
    evere,
    lemin,
    hswae,
    wkurs,
    vbeln_st,
    vbelp_st
      
} where belnr != ''

union all

select from ekbeh 



{
    key ebeln,
    key ebelp,
    key zekkn,
    key vgabe,
    key gjahr,
    key belnr,
    key buzei,
    bewtp,
    bwart,
    budat,
    waers,
    shkzg,
    elikz,
    lfgja,
    lfbnr,
    lfpos,
    matnr,
    werks,
    xwsbr,
    knumv,
    mwskz,     
    bldat,
    ernam,
    bwtar,
    xblnr,
    lsmeh,
    ematn,    
    cpudt,
    menge,
    dmbtr,
    wrbtr,
    bpmng,
    arewr,
    wesbs,
    bpwes,
    reewr,
    refwr,
    lsmng,
    areww,
    bamng,
    arewb,
    rewrb,
    wesbb,
    bpweb,
    weora,    
    kudif,
    evere,
    lemin,
    hswae,
    wkurs,
    vbeln_st,
    vbelp_st
        
    };

Learn More