ScmPrd_Matpack

DDL: SCMPRD_MATPACK SQL: SCMPRDMATPACK Type: view

Redirect for /SAPAPO/MATPACK

ScmPrd_Matpack is a CDS View that provides data about "Redirect for /SAPAPO/MATPACK" in SAP S/4HANA. It reads from 1 data source (mara) and exposes 20 fields.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
mara mara from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName SCMPRDMATPACK view
EndUserText.label Redirect for /SAPAPO/MATPACK view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view

Fields (20)

KeyFieldSource TableSource FieldDescription
matid mara scm_matid_guid22
MAXW
MAXW_UOM mara ergei
MAXW_TOL mara gewto
MAXV
MAXV_UOM mara ervoe
MAXV_TOL mara volto
PMTYP mara vhart
CLOSED_PM mara kzgvh
MAX_FILL_UP
HUTYP mara hutyp
TARE_VAR mara tare_var
MAXC mara maxc
MAXC_TOL mara maxc_tol
MAXL mara maxl
MAXB mara maxb
MAXH mara maxh
MAXDIM_UOM mara maxdim_uom
PS_SMARTFORM mara ps_smartform
PS_PDF_FORM 
@AbapCatalog.sqlViewName: 'SCMPRDMATPACK'
@EndUserText.label: 'Redirect for /SAPAPO/MATPACK'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #AUTOMATED

define view ScmPrd_Matpack
  as select from mara
{
//  mara.mandt,

  mara.scm_matid_guid22                                                                    as    matid,
  cast ( mara.ergew   as /scwm/de_maxw )                                                   as    MAXW,
  mara.ergei                                                                               as    MAXW_UOM,
  mara.gewto                                                                               as    MAXW_TOL,
  cast ( mara.ervol   as /scwm/de_maxv )                                                   as    MAXV,
  mara.ervoe                                                                               as    MAXV_UOM,
  mara.volto                                                                               as    MAXV_TOL,
  mara.vhart                                                                               as    PMTYP,
  mara.kzgvh                                                                               as    CLOSED_PM,
  cast ( mara.fuelg   as /scwm/de_max_fill_up )                                            as    MAX_FILL_UP,
  mara.hutyp                                                                               as    HUTYP,
  mara.tare_var                                                                            as    TARE_VAR,
  mara.maxc                                                                                as    MAXC,
  mara.maxc_tol                                                                            as    MAXC_TOL,
  mara.maxl                                                                                as    MAXL,
  mara.maxb                                                                                as    MAXB,
  mara.maxh                                                                                as    MAXH,
  mara.maxdim_uom                                                                          as    MAXDIM_UOM,
  mara.ps_smartform                                                                        as    PS_SMARTFORM,
  cast( '' as /scwm/de_ps_pdfname )                                                        as    PS_PDF_FORM
} where mara.vhart <> ''
  and mara.vhart <> '0'

Learn More