SAP ABAP - CDS View Material Stock - Hallo sahabat Dev-Create, Pada Artikel yang anda baca kali ini dengan judul SAP ABAP - CDS View Material Stock, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan
Artikel ABAP,
Artikel CDS View, yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.
Judul : SAP ABAP - CDS View Material Stock
link : SAP ABAP - CDS View Material Stock
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CDS View Material Stock'
define view ZCDSMM002 as select from nsdm_v_mkol {
matnr,
werks,
lgort,
charg,
slabs as menge,
sobkz,
lifnr as snumb,
0 as retme,
'' as lgpbe
}
union all select from nsdm_v_msku{
matnr,
werks,
'' as lgort,
charg,
kulab as menge,
sobkz,
kunnr as snumb,
0 as retme,
'' as lgpbe
}
union all select from nsdm_v_mchb{
matnr,
werks,
lgort,
charg,
clabs as menge,
'' as sobkz,
'' as snumb,
cretm as retme,
'' as lgpbe
}
union all select from nsdm_v_mard{
matnr,
werks,
lgort,
'' as charg,
labst as menge,
'' as sobkz,
'' as snumb,
retme,
lgpbe
}
Anda sekarang membaca artikel SAP ABAP - CDS View Material Stock dengan alamat link https://dev-create.blogspot.com/2021/04/sap-abap-cds-view-material-stock.html
Judul : SAP ABAP - CDS View Material Stock
link : SAP ABAP - CDS View Material Stock
SAP ABAP - CDS View Material Stock
@AbapCatalog.sqlViewName: 'ZVMM002'
@AbapCatalog.compiler.compareFilter: true@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CDS View Material Stock'
define view ZCDSMM002 as select from nsdm_v_mkol {
matnr,
werks,
lgort,
charg,
slabs as menge,
sobkz,
lifnr as snumb,
0 as retme,
'' as lgpbe
}
union all select from nsdm_v_msku{
matnr,
werks,
'' as lgort,
charg,
kulab as menge,
sobkz,
kunnr as snumb,
0 as retme,
'' as lgpbe
}
union all select from nsdm_v_mchb{
matnr,
werks,
lgort,
charg,
clabs as menge,
'' as sobkz,
'' as snumb,
cretm as retme,
'' as lgpbe
}
union all select from nsdm_v_mard{
matnr,
werks,
lgort,
'' as charg,
labst as menge,
'' as sobkz,
'' as snumb,
retme,
lgpbe
}
Demikianlah Artikel SAP ABAP - CDS View Material Stock
Sekianlah artikel SAP ABAP - CDS View Material Stock kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.
Anda sekarang membaca artikel SAP ABAP - CDS View Material Stock dengan alamat link https://dev-create.blogspot.com/2021/04/sap-abap-cds-view-material-stock.html