P_ALTERNATEPRODLINES

DDL: P_ALTERNATEPRODLINES SQL: PALTPRODLIN Type: view BASIC Package: PPH_VDM_CAP_EVAL
9 Fields 3 Data Sources

Alternate Production Lines for a given Production Line

P_ALTERNATEPRODLINES is a Basic CDS View that provides data about "Alternate Production Lines for a given Production Line" in SAP S/4HANA. It reads from 3 data sources (I_ProductionVersion, I_Capacity, I_WorkCenter) and exposes 9 fields. Part of development package PPH_VDM_CAP_EVAL.

Data Sources (3)

SourceAliasJoin Type
I_ProductionVersion _altprodline inner
I_Capacity _Capacity inner
I_WorkCenter _workcenter inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PALTPRODLIN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
WorkCenter _prodline ProductionLine Production Line
Plant _prodline Plant Valuation Area
Material _prodline Material Vehicle Model
AlternateWorkCenter I_ProductionVersion ProductionLine Production Line
AlternatePlant I_ProductionVersion Plant Valuation Area
AltWorkCenterInternalID I_WorkCenter WorkCenterInternalID Work Center
AltWorkCenterTypeCode I_WorkCenter WorkCenterTypeCode Object Type
AltCapacityInternalID I_WorkCenter CapacityInternalID Capacity ID
AddressTimeZoneendasPlantTimeZone

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 P_ALTERNATEPRODLINES.
-- 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: PALTPRODLIN

CREATE VIEW P_ALTERNATEPRODLINES AS
SELECT
  _prodline.ProductionLine AS WorkCenter,
  _prodline.Plant AS Plant,
  _prodline.Material AS Material,
  _altprodline.ProductionLine AS AlternateWorkCenter,
  _altprodline.Plant AS AlternatePlant,
  _workcenter.WorkCenterInternalID AS AltWorkCenterInternalID,
  _workcenter.WorkCenterTypeCode AS AltWorkCenterTypeCode,
  _workcenter.CapacityInternalID AS AltCapacityInternalID,
  case when _workcenter._Plant._StandardOrganizationAddress.AddressTimeZone is null or _workcenter._Plant._StandardOrganizationAddress.AddressTimeZone is initial then abap_system_timezone($session.client, 'NULL') else _workcenter._Plant._StandardOrganizationAddress.AddressTimeZone end as PlantTimeZone AS AddressTimeZoneendasPlantTimeZone
INNER JOIN I_ProductionVersion AS _altprodline ON /* join condition not captured in parsed metadata */
INNER JOIN I_WorkCenter AS _workcenter ON /* join condition not captured in parsed metadata */
INNER JOIN I_Capacity AS _Capacity ON /* join condition not captured in parsed metadata */
;

Learn More