P_PurOrdItemChgScoreHistory

DDL: P_PURORDITEMCHGSCOREHISTORY SQL: PCHGSCOREHIST Type: view CONSUMPTION
16 Fields 2 Data Sources

Pur Ord Item Changed Score History

P_PurOrdItemChgScoreHistory is a Consumption CDS View that provides data about "Pur Ord Item Changed Score History" in SAP S/4HANA. It reads from 2 data sources (P_PurOrdItmChgScoreHist, I_User) and exposes 16 fields with key fields PurchaseOrder, PurchaseOrderItem, LastChangeDateTime.

Data Sources (2)

SourceAliasJoin Type
P_PurOrdItmChgScoreHist P_PurOrdItmChgScoreHist from
I_User User left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCHGSCOREHIST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Pur Ord Item Changed Score History view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY LastChangeDateTime LastChangeDateTime Timestamp
LastChangeUser LastChangeUser User Name
Comments Comments User Notes
InspectionLotQualityScore InspectionLotQualityScore Inspection Lot Score
InspectionLotQualityOldScore InspectionLotQualityOldScore
QuantityVarianceScore QuantityVarianceScore Quantity Var. Score
QuantityVarianceOldScore QuantityVarianceOldScore
TimeVarianceScore TimeVarianceScore Time Variance Score
TimeVarianceOldScore TimeVarianceOldScore
PriceVarianceScore PriceVarianceScore Price Variance Score
PriceVarianceOldScore PriceVarianceOldScore
IsScoreResetToCalculated IsScoreResetToCalculated
QualityNotificationScore QualityNotificationScore Quality Notif. Score
QualityNotificationOldScore QualityNotificationOldScore

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_PurOrdItemChgScoreHistory.
-- 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: PCHGSCOREHIST

CREATE VIEW P_PurOrdItemChgScoreHistory AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  LastChangeDateTime,
  LastChangeUser,
  Comments,
  InspectionLotQualityScore,
  InspectionLotQualityOldScore,
  QuantityVarianceScore,
  QuantityVarianceOldScore,
  TimeVarianceScore,
  TimeVarianceOldScore,
  PriceVarianceScore,
  PriceVarianceOldScore,
  IsScoreResetToCalculated,
  QualityNotificationScore,
  QualityNotificationOldScore
FROM P_PurOrdItmChgScoreHist
LEFT OUTER JOIN I_User AS User ON /* join condition not captured in parsed metadata */
;

Learn More