ESH_N_PLANNEDORDER

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 ESH_N_PLANNEDORDER.
-- 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: ESH_L_PLANEDORDR
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_PLANNEDORDER AS
SELECT
  PLANNEDORDER,
  _SALESORDER._SOLDTOPARTY.AUTHORIZATIONGROUP AS CUSTOMERAUTHZNGRP,
  _SUPPLIER.AUTHORIZATIONGROUP AS SUPPLIERAUTHZNGRP,
  BASEUNIT,
  CAPACITYREQUIREMENT,
  MATERIALPROCUREMENTTYPE,
  _MATLPROCUREMENTTYPE[1: ddlanguage = $parameters. P_Language].ddtext AS MATERIALPROCUREMENTTYPENAME,
  MRPAREA,
  _MRPAREA.MRPAREATEXT AS MRPAREATEXT,
  MRPCONTROLLER,
  _MRPCONTROLLER.MRPCONTROLLERNAME AS MRPCONTROLLERNAME,
  MRPPLANT,
  _SALESORDER._SOLDTOPARTY.ORGANIZATIONBPNAME1 AS ORGANIZATIONBPNAME1,
  _SUPPLIER.ORGANIZATIONBPNAME1 AS SUPPLIERNAME,
  PLANNEDORDEROPENINGDATE,
  PLANNEDORDERTYPE,
  _PLANNEDORDERTYPE[1: ddlanguage = $parameters. P_Language].ddtext AS PLANNEDORDERTYPENAME,
  PLANNEDTOTALQTYINBASEUNIT,
  _MRPPLANT.PLANTNAME AS PLANTNAME,
  _PRODUCTIONPLANT.PLANTNAME AS PRODUCTIONPLANTNAME,
  PLNDORDERPLANNEDENDDATE,
  PLNDORDERPLANNEDSTARTDATE,
  PRODUCT,
  _RESERVATION._RESERVATIONDOCUMENTITEM.PRODUCT AS MATERIALCOMPONENT,
  PRODUCTIONPLANT,
  PRODUCTIONSUPERVISOR,
  _PRODUCTIONSUPERVISOR.PRODUCTIONSUPERVISORNAME AS PRODUCTIONSUPERVISORNAME,
  PRODUCTIONVERSION,
  _PRODUCT._TEXT[1: LANGUAGE = $parameters. P_Language].PRODUCTNAME AS PRODUCTNAME,
  _RESERVATION._RESERVATIONDOCUMENTITEM._PRODUCT._TEXT[1: LANGUAGE = $parameters. P_Language].PRODUCTNAME AS MATERIALCOMPONENTNAME,
  _PRODUCTPLANT.PURCHASINGGROUP AS PURCHASINGGROUP,
  _PRODUCTPLANT._PURCHASINGGROUP.PURCHASINGGROUPNAME AS PURCHASINGGROUPNAME,
  QUOTAARRANGEMENT,
  SALESORDER,
  _SALESORDER.SOLDTOPARTY AS SOLDTOPARTY,
  _BASEUNIT._TEXT[1: LANGUAGE = $parameters. P_Language].UNITOFMEASURE_E AS UNITOFMEASURE_E,
  _CAPACITYREQUIREMENTITEMCAP.WORKCENTER AS WORKCENTER,
  _CAPACITYREQUIREMENTITEMCAP.WORKCENTERTEXT AS WORKCENTERTEXT
FROM I_PLANNEDORDER
LEFT OUTER JOIN N_MRPCONTROLLER AS _MRPCONTROLLER ON ProductionPlant=_MRPCONTROLLER.Plant AND MRPController=_MRPCONTROLLER.MRPController  -- association [0..1]
LEFT OUTER JOIN N_PRODUCTPLANT AS _PRODUCTPLANT ON ( MRPPlant=_PRODUCTPLANT.Plant AND Product=_PRODUCTPLANT.Product )  -- association [0..1]
LEFT OUTER JOIN N_CAPACITYREQUIREMENTITEMCAP AS _CAPACITYREQUIREMENTITEMCAP ON CapacityRequirement=_CAPACITYREQUIREMENTITEMCAP.CapacityRequirement  -- association [0..*]
LEFT OUTER JOIN dd07t AS _MATLPROCUREMENTTYPE ON ( MaterialProcurementType=_MATLPROCUREMENTTYPE.domvalue_l AND _MATLPROCUREMENTTYPE.domname='SOBES' AND _MATLPROCUREMENTTYPE.as4local='A' )  -- association [0..*]
LEFT OUTER JOIN dd07t AS _PLANNEDORDERTYPE ON ( PlannedOrderType=_PLANNEDORDERTYPE.domvalue_l AND _PLANNEDORDERTYPE.domname='PAART' AND _PLANNEDORDERTYPE.as4local='A' )  -- association [0..*]
;