FSH_V_PLANNING_FILE_ENTRIES

DDL: FSH_V_PLANNING_FILE_ENTRIES SQL: FSH_V_PFE Type: view

Planning File entries for Fashion

FSH_V_PLANNING_FILE_ENTRIES is a CDS View that provides data about "Planning File entries for Fashion" in SAP S/4HANA. It reads from 4 data sources (pph_dbvm, mara, marc, t438a) and exposes 9 fields.

Data Sources (4)

SourceAliasJoin Type
pph_dbvm dbvm inner
mara mara inner
marc marc_kmat left_outer
t438a t438a inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FSH_V_PFE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #AUTOMATED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Planning File entries for Fashion view

Fields (9)

KeyFieldSource TableSource FieldDescription
mandt marc mandt Editing Client
matnr pph_dbvm matnr Vehicle Model
berid pph_dbvm berid Single-Character Flag
werks pph_dbvm werks Receiving Plant
gsaen pph_dbvm gsaen Net Change Plng
sobsl marc sobsl SpecProcuremKey
dispo marc dispo MRP Controller
beskz marc beskz Procuremt Type
disvf t438a disvf MRP Procedure

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 FSH_V_PLANNING_FILE_ENTRIES.
-- 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: FSH_V_PFE

CREATE VIEW FSH_V_PLANNING_FILE_ENTRIES AS
SELECT
  marc.mandt AS mandt,
  dbvm.matnr AS matnr,
  dbvm.berid AS berid,
  dbvm.werks AS werks,
  dbvm.gsaen AS gsaen,
  marc.sobsl AS sobsl,
  marc.dispo AS dispo,
  marc.beskz AS beskz,
  t438a.disvf AS disvf
INNER JOIN mara ON /* join condition not captured in parsed metadata */
INNER JOIN t438a ON /* join condition not captured in parsed metadata */
INNER JOIN pph_dbvm AS dbvm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN marc AS marc_kmat ON /* join condition not captured in parsed metadata */
;