P_ChgImpactOrderEffectivity

DDL: P_CHGIMPACTORDEREFFECTIVITY SQL: PCHGIMPORDEFF Type: view BASIC
22 Fields 2 Data Sources

P_ChgImpactOrderEffectivity is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (tecs, afpo) and exposes 22 fields with key field OrderId.

Data Sources (2)

SourceAliasJoin Type
tecs ChgImpactParameffec left_outer
afpo ChgImpactProd from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCHGIMPORDEFF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY OrderId afpo aufnr SettlementOrder
techs afpo techs Tech st from
mandt tecs mandt Editing Client
andat tecs andat Created On
annam tecs annam Created By
date_lo tecs date_lo Date
date_hi tecs date_hi Date
date_oi tecs date_oi Date
matnr_lo tecs matnr_lo Material
sernr_lo tecs sernr_lo Serial no.
sernr_hi tecs sernr_hi Serial no.
product_lo tecs product_lo Product
class_lo tecs class_lo Class
classty_lo tecs classty_lo Class Type
plant_lo tecs plant_lo Plant
startup_lo tecs startup_lo Start-Up Params
locno_lo tecs locno_lo Location
sernr_oi tecs sernr_oi Serial no.
tabname tecs tabname Table/Constant Value
objky tecs objky Relation (Key)
techu tecs techu Original technical status
techo tecs techo Technical status for original

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_ChgImpactOrderEffectivity.
-- 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: PCHGIMPORDEFF

CREATE VIEW P_ChgImpactOrderEffectivity AS
SELECT
  ChgImpactProd.aufnr AS OrderId,
  ChgImpactProd.techs AS techs,
  ChgImpactParameffec.mandt AS mandt,
  ChgImpactParameffec.andat AS andat,
  ChgImpactParameffec.annam AS annam,
  ChgImpactParameffec.date_lo AS date_lo,
  ChgImpactParameffec.date_hi AS date_hi,
  ChgImpactParameffec.date_oi AS date_oi,
  ChgImpactParameffec.matnr_lo AS matnr_lo,
  ChgImpactParameffec.sernr_lo AS sernr_lo,
  ChgImpactParameffec.sernr_hi AS sernr_hi,
  ChgImpactParameffec.product_lo AS product_lo,
  ChgImpactParameffec.class_lo AS class_lo,
  ChgImpactParameffec.classty_lo AS classty_lo,
  ChgImpactParameffec.plant_lo AS plant_lo,
  ChgImpactParameffec.startup_lo AS startup_lo,
  ChgImpactParameffec.locno_lo AS locno_lo,
  ChgImpactParameffec.sernr_oi AS sernr_oi,
  ChgImpactParameffec.tabname AS tabname,
  ChgImpactParameffec.objky AS objky,
  ChgImpactParameffec.techu AS techu,
  ChgImpactParameffec.techo AS techo
FROM afpo AS ChgImpactProd
LEFT OUTER JOIN tecs AS ChgImpactParameffec ON /* join condition not captured in parsed metadata */
;

Learn More