P_ALTERNATEPRODLINES

DDL: P_ALTERNATEPRODLINES SQL: PALTPRODLIN Type: view BASIC
9 Fields 4 Data Sources

P_ALTERNATEPRODLINES is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (I_ProductionVersion, I_Capacity, P_SchedProdnPlantTimeZone, I_WorkCenter) and exposes 9 fields.

Data Sources (4)

SourceAliasJoin Type
I_ProductionVersion _altprodline inner
I_Capacity _Capacity inner
P_SchedProdnPlantTimeZone _timezone 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
PlantTimeZone P_SchedProdnPlantTimeZone PlantTimeZone Time Zone

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,
  _timezone.PlantTimeZone AS PlantTimeZone
INNER JOIN I_ProductionVersion AS _altprodline ON /* join condition not captured in parsed metadata */
INNER JOIN P_SchedProdnPlantTimeZone AS _timezone 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