C_PurgDocFldValChg

DDL: C_PURGDOCFLDVALCHG SQL: CGRCFLDCHGPURDOC Type: view CONSUMPTION
28 Fields 2 Data Sources

Change Information Purchasing Document

C_PurgDocFldValChg is a Consumption CDS View that provides data about "Change Information Purchasing Document" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingDocumentItem, I_ChangeDocumentItem) and exposes 28 fields with key fields PurchasingDocument, PurchasingDocumentItem, ChangeDocument, DatabaseTableFieldName.

Data Sources (2)

SourceAliasJoin Type
I_PurchasingDocumentItem _PurchasingDocumentItem inner
I_ChangeDocumentItem I_ChangeDocumentItem from

Parameters (1)

NameTypeDefault
P_DatabaseTableFieldName fieldname

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CGRCFLDCHGPURDOC view
EndUserText.label Change Information Purchasing Document view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
OData.publish true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocumentItem PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
KEY ChangeDocument
KEY DatabaseTableFieldName I_ChangeDocumentItem ChangeDocDatabaseTableField User
ChangeDocNewFieldValue I_ChangeDocumentItem ChangeDocNewFieldValue New Field Value
ChangeDocPreviousFieldValue I_ChangeDocumentItem ChangeDocPreviousFieldValue Old Field Value
ChangeDocNewUnit I_ChangeDocumentItem ChangeDocNewUnit New Unit
ChangeDocPreviousUnit I_ChangeDocumentItem ChangeDocPreviousUnit Old Unit
ChangeDocNewCurrency I_ChangeDocumentItem ChangeDocNewCurrency New Currency
ChangeDocPreviousCurrency I_ChangeDocumentItem ChangeDocPreviousCurrency Old Currency
PurchasingDocumentCategory
PurchasingDocumentType
CompanyCode I_PurchasingDocumentItem CompanyCode Receiver Company Code
Plant I_PurchasingDocumentItem Plant Valuation Area
PurchasingOrganization
Supplier
DocumentCurrency
GrossAmount I_PurchasingDocumentItem GrossAmount Gross value
PurchasingDocumentItemText I_PurchasingDocumentItem PurchasingDocumentItemText Short Text
IsEndOfPurposeBlocked I_PurchasingDocumentItem IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
_PurchasingDocument I_PurchasingDocumentItem _PurchasingDocument
_PurchasingDocumentType
_PurchasingDocumentCategory
_CompanyCode I_PurchasingDocumentItem _CompanyCode
_Plant I_PurchasingDocumentItem _Plant
_PurchasingOrganization
_Supplier
_DocumentCurrency I_PurchasingDocumentItem _DocumentCurrency

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 C_PurgDocFldValChg.
-- 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: CGRCFLDCHGPURDOC
-- Parameters: P_DatabaseTableFieldName : fieldname

CREATE VIEW C_PurgDocFldValChg AS
SELECT
  _PurchasingDocumentItem.PurchasingDocument AS PurchasingDocument,
  _PurchasingDocumentItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  cast(I_ChangeDocumentItem.ChangeDocument as changedocumentnumber) AS ChangeDocument,
  I_ChangeDocumentItem.ChangeDocDatabaseTableField AS DatabaseTableFieldName,
  I_ChangeDocumentItem.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  I_ChangeDocumentItem.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  I_ChangeDocumentItem.ChangeDocNewUnit AS ChangeDocNewUnit,
  I_ChangeDocumentItem.ChangeDocPreviousUnit AS ChangeDocPreviousUnit,
  I_ChangeDocumentItem.ChangeDocNewCurrency AS ChangeDocNewCurrency,
  I_ChangeDocumentItem.ChangeDocPreviousCurrency AS ChangeDocPreviousCurrency,
  _PurchasingDocumentItem._PurchasingDocument.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchasingDocumentItem._PurchasingDocument.PurchasingDocumentType AS PurchasingDocumentType,
  _PurchasingDocumentItem.CompanyCode AS CompanyCode,
  _PurchasingDocumentItem.Plant AS Plant,
  _PurchasingDocumentItem._PurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingDocumentItem._PurchasingDocument.Supplier AS Supplier,
  _PurchasingDocumentItem.GrossAmount AS GrossAmount,
  _PurchasingDocumentItem.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  _PurchasingDocumentItem.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _PurchasingDocumentItem._PurchasingDocument AS _PurchasingDocument,
  _PurchasingDocumentItem._PurchasingDocument._PurchasingDocumentType AS _PurchasingDocumentType,
  _PurchasingDocumentItem._PurchasingDocument._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  _PurchasingDocumentItem._CompanyCode AS _CompanyCode,
  _PurchasingDocumentItem._Plant AS _Plant,
  _PurchasingDocumentItem._PurchasingDocument._PurchasingOrganization AS _PurchasingOrganization,
  _PurchasingDocumentItem._PurchasingDocument._Supplier AS _Supplier,
  _PurchasingDocumentItem._DocumentCurrency AS _DocumentCurrency
FROM I_ChangeDocumentItem
INNER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON /* join condition not captured in parsed metadata */
;

Learn More