CDS_ATP_RES_HEAD_CHK_LOG_CMPAT

DDL: CDS_ATP_RES_HEAD_CHK_LOG_CMPAT SQL: ATPRESCHKCOMP Type: view Package: ATP_RESULT
11 Fields 2 Data Sources

Compatibility view of ATP result header and ATP check

CDS_ATP_RES_HEAD_CHK_LOG_CMPAT is a CDS View that provides data about "Compatibility view of ATP result header and ATP check" in SAP S/4HANA. It reads from 2 data sources (I_ATPCheck, I_ATPResultHeader) and exposes 11 fields with key field cid. Part of development package ATP_RESULT.

Data Sources (2)

SourceAliasJoin Type
I_ATPCheck I_ATPCheck from
I_ATPResultHeader I_ATPResultHeader union

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ATPRESCHKCOMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Compatibility view of ATP result header and ATP check view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY cid ATPCheckUUID Check ID
time_start StartUTCDateTime Start Timestamp
uname TriggeredByUser User Name
variant_uuid _ExecutedABOPVariant ABOPVariantUUID BOP Variant UUID
variant_name _ExecutedABOPVariant ABOPVariantName Variant Name
time_start ATPCheckStartUTCDateTime Start Timestamp
uname StartedByUser User Name
variant_uuid _Variant ABOPVariantUUID BOP Variant UUID
variant_name _Variant ABOPVariantName Variant Name
status ATPCheckStatus
time_zone

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 CDS_ATP_RES_HEAD_CHK_LOG_CMPAT.
-- 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: ATPRESCHKCOMP

CREATE VIEW CDS_ATP_RES_HEAD_CHK_LOG_CMPAT AS
SELECT
  ATPCheckUUID AS cid,
  StartUTCDateTime AS time_start,
  TriggeredByUser AS uname,
  _ExecutedABOPVariant.ABOPVariantUUID AS variant_uuid,
  _ExecutedABOPVariant.ABOPVariantName AS variant_name,
  ATPCheckStatus AS status,
  $session.user_timezone AS time_zone
FROM I_ATPCheck
-- UNION with additional select branch(es): I_ATPResultHeader
;

Learn More