P_CostCtrChangeDocItem

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_CostCtrChangeDocItem.
-- 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: PCOSTCTRCHGDOCIT

CREATE VIEW P_CostCtrChangeDocItem AS
SELECT
  I_ChangeDocumentItem.ChangeDocObject AS ChangeDocObject,
  I_ChangeDocumentItem.ChangeDocObjectClass AS ChangeDocObjectClass,
  I_ChangeDocumentItem.ChangeDocument AS ChangeDocument,
  I_ChangeDocumentItem.DatabaseTable AS DatabaseTable,
  I_ChangeDocumentItem.ChangeDocTableKey AS ChangeDocTableKey,
  I_ChangeDocumentItem.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  cast ( I_ChangeDocumentItem.ChangeDocItemChangeType as changedocumentchangetype preserving type ) AS ChangeDocItemChangeType,
  _ChgDocItemChangeTypeText.ChangeDocItemChangeTypeText AS ChangeDocItemChangeTypeText,
  I_ChangeDocumentItem.ChangeDocPreviousUnit AS ChangeDocPreviousUnit,
  I_ChangeDocumentItem.ChangeDocNewUnit AS ChangeDocNewUnit,
  I_ChangeDocumentItem.ChangeDocPreviousCurrency AS ChangeDocPreviousCurrency,
  I_ChangeDocumentItem.ChangeDocNewCurrency AS ChangeDocNewCurrency,
  cast ( I_ChangeDocumentItem.ChangeDocPreviousFieldValue as fis_cc_old_fieldval preserving type ) AS ChangeDocPreviousFieldValue,
  cast ( I_ChangeDocumentItem.ChangeDocNewFieldValue as fis_cc_new_fieldval preserving type ) AS ChangeDocNewFieldValue,
  cast ( substring(I_ChangeDocumentItem.ChangeDocTableKey, 1, 3) as mandt ) AS ChangeDocumentSAPClient,
  cast ( substring(I_ChangeDocumentItem.ChangeDocTableKey, 4, 4) as kokrs ) AS ChangeDocumentControllingArea,
  cast ( substring(I_ChangeDocumentItem.ChangeDocTableKey, 8, 10) as kostl ) AS ChangeDocumentCostCenter,
  cast ( substring(I_ChangeDocumentItem.ChangeDocTableKey, 18, 8) as fis_cc_datbis ) AS ChangeDocumentValidityEndDate,
  cast ( substring(I_ChangeDocumentItem.ChangeDocTableKey, 26, 8) as fis_cc_datab ) AS ChangeDocValidityStartDate,
  case when I_ChangeDocumentItem.DatabaseTable = 'CSKSB' and ( I_ChangeDocumentItem.ChangeDocDatabaseTableField = 'LAND1' or I_ChangeDocumentItem.ChangeDocDatabaseTableField = 'TELF1' or I_ChangeDocumentItem.ChangeDocDatabaseTableField = 'DRNAM' or I_ChangeDocumentItem.ChangeDocDatabaseTableField = 'NAME1' ) then 'PFICOSTCENTER' else I_ChangeDocumentItem.DatabaseTable end as ObjectDatabaseTable AS DatabaseTableendasObjectDatabaseTable
FROM I_ChangeDocumentItem
LEFT OUTER JOIN P_CostCenterChangeDocument AS _CostCenterChangeDocument ON ChangeDocObjectClass = _CostCenterChangeDocument.ChangeDocObjectClass AND ChangeDocObject = _CostCenterChangeDocument.ChangeDocObject AND ChangeDocument = _CostCenterChangeDocument.ChangeDocument  -- association [0..1]
LEFT OUTER JOIN I_ChgDocItemChangeTypeText AS _ChgDocItemChangeTypeText ON _ChgDocItemChangeTypeText.ChangeDocItemChangeType = ChangeDocItemChangeType AND _ChgDocItemChangeTypeText.Language = $session.system_language  -- association [0..1]
;