ScmPrd_V_Bwlprd

DDL: SCMPRD_V_BWLPRD SQL: SCMPRDVBWLPRD Type: view
56 Fields 1 Data Sources

Product Scm redirect for V_BWLPRD

ScmPrd_V_Bwlprd is a CDS View that provides data about "Product Scm redirect for V_BWLPRD" in SAP S/4HANA. It reads from 1 data source (ScmPrd_Matloc) and exposes 56 fields.

Data Sources (1)

SourceAliasJoin Type
ScmPrd_Matloc matloc from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName SCMPRDVBWLPRD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label Product Scm redirect for V_BWLPRD view

Fields (56)

KeyFieldSource TableSource FieldDescription
MATLOCID MATLOCID Loc. Prod. ID
MATID ScmPrd_Matloc MATID Product ID
LOCID ScmPrd_Matloc LOCID Single-Character Flag
MATNR matkey MATNR Vehicle Model
MEINS matkey MEINS Valuation Unit
locno loc locno Location
loctype loc loctype Location Type
PLANNER_PPS PLANNER_PPS MRP Controller
PLANNER_SNP PLANNER_SNP SNP Planner
PLANNER_DEMAND PLANNER_DEMAND
PLANNER_TRANS PLANNER_TRANS
MTVFP MTVFP Avail. check
CONHAP CONHAP GR Handlg Cap. Cons.
HUNIT HUNIT UoM:HandlCap GR
CONINP CONINP Stor. Consumptn
IUNIT IUNIT Unit of Meas.
KDMATID KDMATID
MATSTORE MATSTORE Mat. StLoc resource
SAFTY SAFTY Safety stock
LGRAD ScmPrd_Matloc LGRAD Target Service Level
SCOST SCOST Prod.Stor. Costs
BESKZ BESKZ Procuremt Type
RRP_TYPE RRP_TYPE PP Plng Proced.
EKGRP EKGRP Sub. purchasing grp
PRIO PRIO Profile priority
VEGRP VEGRP Cust.'s Pur. Grp
PLIFZ PLIFZ Plnd Deliv.Time
MANOT MANOT
ATP_CHMOD ATP_CHMOD
WHATBOM WHATBOM Plan Explosion
DIBER DIBER MRP area exists
CHKHOR CHKHOR
CHKHORCAL CHKHORCAL
LSZID LSZID Internal ID:Lot size/days'supply profile in material master
DPRID DPRID Ret. Income Res.
SPRID SPRID Supply Profile
DPLID DPLID Deploymt Profle
GRPRT GRPRT GR Processng Time
GIPRT GIPRT GI Processng Time
STOCK_UID STOCK_UID UUID 22 char.
SW_SCZPRF SW_SCZPRF TSL Calculation
RQMID RQMID Internal Number for Requirement Profile in Product Master
DIUOM DIUOM
AT101 AT101 Free Attribute 1
AT102 AT102 Free Attribute 2
AT103 AT103 Free Attribute 3
AT104 AT104 Free Attribute
AT105 AT105 Free Attribute
KOSCH ScmPrd_Matloc KOSCH Prod.allocation
KOSCH_GRP ScmPrd_Matloc KOSCH_GRP Procedure Seq.
COSID COSID Cost Function
ND_STORDU ND_STORDU Av. Time in Storage
LVORM ScmPrd_Matloc LVORM Stock del. flag
MATLOC_CHANGEUTC ScmPrd_Matloc CHANGEUTC Time Stamp
LOC_CHANGEUTC loc changeutc Time Stamp
MAT_CHANGEUTC matkey CHANGEUTC Time Stamp

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 ScmPrd_V_Bwlprd.
-- 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: SCMPRDVBWLPRD

CREATE VIEW ScmPrd_V_Bwlprd AS
SELECT
  MATLOCID,
  matloc.MATID AS MATID,
  matloc.LOCID AS LOCID,
  matkey.MATNR AS MATNR,
  matkey.MEINS AS MEINS,
  loc.locno AS locno,
  loc.loctype AS loctype,
  PLANNER_PPS,
  PLANNER_SNP,
  PLANNER_DEMAND,
  PLANNER_TRANS,
  MTVFP,
  CONHAP,
  HUNIT,
  CONINP,
  IUNIT,
  KDMATID,
  MATSTORE,
  SAFTY,
  matloc.LGRAD AS LGRAD,
  SCOST,
  BESKZ,
  RRP_TYPE,
  EKGRP,
  PRIO,
  VEGRP,
  PLIFZ,
  MANOT,
  ATP_CHMOD,
  WHATBOM,
  DIBER,
  CHKHOR,
  CHKHORCAL,
  LSZID,
  DPRID,
  SPRID,
  DPLID,
  GRPRT,
  GIPRT,
  STOCK_UID,
  SW_SCZPRF,
  RQMID,
  DIUOM,
  AT101,
  AT102,
  AT103,
  AT104,
  AT105,
  matloc.KOSCH AS KOSCH,
  matloc.KOSCH_GRP AS KOSCH_GRP,
  COSID,
  ND_STORDU,
  matloc.LVORM AS LVORM,
  matloc.CHANGEUTC AS MATLOC_CHANGEUTC,
  loc.changeutc AS LOC_CHANGEUTC,
  matkey.CHANGEUTC AS MAT_CHANGEUTC
FROM ScmPrd_Matloc AS matloc
;

Learn More