I_ContractSnapshotItemLevel

DDL: I_CONTRACTSNAPSHOTITEMLEVEL SQL: ICNTRCTSNPITMLVL Type: view BASIC
10 Fields 2 Data Sources

ACM Contract Snapshot for Item Level

I_ContractSnapshotItemLevel is a Basic CDS View that provides data about "ACM Contract Snapshot for Item Level" in SAP S/4HANA. It reads from 2 data sources (I_ContractSnapshotHeaderLevel, /accgo/t_snpit1) and exposes 10 fields with key fields ACMSnapshotID, ACMSnapshotAppl, ACMContractSnpshtDateTime, TradingContractItem.

Data Sources (2)

SourceAliasJoin Type
I_ContractSnapshotHeaderLevel SnapshotHeader inner
/accgo/t_snpit1 SnapshotItem from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICNTRCTSNPITMLVL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ACM Contract Snapshot for Item Level view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ACMSnapshotID /accgo/t_snpit1 document_id Snapshot ID
KEY ACMSnapshotAppl /accgo/t_snpit1 application UI Application
KEY ACMContractSnpshtDateTime /accgo/t_snpit1 timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
KEY TradingContractItem tposn Item Number
ACMSnpshtOutputProcStatus /accgo/t_snpit1 output_process Output Processing
ACMSignatureRelevant /accgo/t_snpit1 signature_rel Rel for Signature
ACMSignatureStatus /accgo/t_snpit1 signature_status Signature Status
TradingContractExternalID TradingContractExternalID Ext. Identifier
ChangedBy I_ContractSnapshotHeaderLevel ChangedBy User Name
ChangedByName I_ContractSnapshotHeaderLevel ChangedByName Changed By

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 I_ContractSnapshotItemLevel.
-- 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: ICNTRCTSNPITMLVL

CREATE VIEW I_ContractSnapshotItemLevel AS
SELECT
  SnapshotItem.document_id AS ACMSnapshotID,
  SnapshotItem.application AS ACMSnapshotAppl,
  SnapshotItem.timestamp AS ACMContractSnpshtDateTime,
  tposn AS TradingContractItem,
  SnapshotItem.output_process AS ACMSnpshtOutputProcStatus,
  SnapshotItem.signature_rel AS ACMSignatureRelevant,
  SnapshotItem.signature_status AS ACMSignatureStatus,
  TradingContractExternalID,
  SnapshotHeader.ChangedBy AS ChangedBy,
  SnapshotHeader.ChangedByName AS ChangedByName
FROM /accgo/t_snpit1 AS SnapshotItem
INNER JOIN I_ContractSnapshotHeaderLevel AS SnapshotHeader ON /* join condition not captured in parsed metadata */
;

Learn More