C_TDAPutHeaderTP

DDL: C_TDAPUTHEADERTP Type: view_entity CONSUMPTION Package: FRM_S4C_DB

Post upgrade tests header detail - TP

C_TDAPutHeaderTP is a Consumption CDS View that provides data about "Post upgrade tests header detail - TP" in SAP S/4HANA. It reads from 1 data source (I_TDAPutHeaderTP) and exposes 38 fields with key field PUTExecID. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F8242, UI_E2EIE_UPGRADE_IC_TC_V4). Part of development package FRM_S4C_DB.

Data Sources (1)

SourceAliasJoin Type
I_TDAPutHeaderTP I_TDAPutHeaderTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_PUTTestDataContainerDetail _PutItemDataContainer _PutItemDataContainer.PUTExecID = $projection.PUTExecID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Post upgrade tests header detail - TP view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F8242 ASQL_F8242 C2 NOT_RELEASED
UI_E2EIE_UPGRADE_IC_TC_V4 UI_E2EIE_UPGRADE_IC_TC_V4 V4 C1 NOT_RELEASED

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY PUTExecID PUTExecID
PUTExecName PUTExecName
PUTExecutedByName PUTExecutedByName
PUTExecutedDate PUTExecutedDate
PUTExecutedTime PUTExecutedTime
PUTExecStatusText PUTExecStatusText
PUTExecRemarksText PUTExecRemarksText
TDAPutReleaseText TDAPutReleaseText
PUTScopeItemsValue PUTScopeItemsValue
PUTScopeSubmittedValue PUTScopeSubmittedValue
PUTScopeNotSubmittedValue PUTScopeNotSubmittedValue
PUTScopeCompletedValue PUTScopeCompletedValue
PUTStartupValue PUTStartupValue
PUTStartupCompletedValue PUTStartupCompletedValue
PUTRunningStepValue PUTRunningStepValue
PUTOthersValue PUTOthersValue
PUTReadinessCheckStartDteTme PUTReadinessCheckStartDteTme
PUTReadinessCheckEndDteTme PUTReadinessCheckEndDteTme
PUTSmokeTestsExecStartDteTme PUTSmokeTestsExecStartDteTme
PUTSmokeTestsExecEndDteTme PUTSmokeTestsExecEndDteTme
PUTStartupTestsExecStartDteTme PUTStartupTestsExecStartDteTme
PUTStartupTestsExecEndDteTme PUTStartupTestsExecEndDteTme
PUTExecStartDteTme PUTExecStartDteTme
PUTExecEndDteTme PUTExecEndDteTme
PUTUnitTestsStartDteTme PUTUnitTestsStartDteTme
PUTUnitTestsEndDteTme PUTUnitTestsEndDteTme
PUTUnitTestsValue PUTUnitTestsValue
TDAScopeText TDAScopeText
PUTExecutedDateTime PUTExecutedDateTime
TDAType TDAType
PUTUnitTestsSubmittedValue PUTUnitTestsSubmittedValue
PUTUnitTestsExecStatus PUTUnitTestsExecStatus
TDAIsPutConsent TDAIsPutConsent
TDAScopeVariantName TDAScopeVariantName
TDAScopeSourceText TDAScopeSourceText
_PutItemDataContainer _PutItemDataContainer
_PUTItemredirectedtoC_PUTExecDetailTP
_UnitTestsredirectedtoC_TDAUnitTestTP

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_TDAPutHeaderTP.
-- 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.

CREATE VIEW C_TDAPutHeaderTP AS
SELECT
  PUTExecID,
  PUTExecName,
  PUTExecutedByName,
  PUTExecutedDate,
  PUTExecutedTime,
  PUTExecStatusText,
  PUTExecRemarksText,
  TDAPutReleaseText,
  PUTScopeItemsValue,
  PUTScopeSubmittedValue,
  PUTScopeNotSubmittedValue,
  PUTScopeCompletedValue,
  PUTStartupValue,
  PUTStartupCompletedValue,
  PUTRunningStepValue,
  PUTOthersValue,
  PUTReadinessCheckStartDteTme,
  PUTReadinessCheckEndDteTme,
  PUTSmokeTestsExecStartDteTme,
  PUTSmokeTestsExecEndDteTme,
  PUTStartupTestsExecStartDteTme,
  PUTStartupTestsExecEndDteTme,
  PUTExecStartDteTme,
  PUTExecEndDteTme,
  PUTUnitTestsStartDteTme,
  PUTUnitTestsEndDteTme,
  PUTUnitTestsValue,
  TDAScopeText,
  PUTExecutedDateTime,
  TDAType,
  PUTUnitTestsSubmittedValue,
  PUTUnitTestsExecStatus,
  TDAIsPutConsent,
  TDAScopeVariantName,
  TDAScopeSourceText
FROM I_TDAPutHeaderTP
LEFT OUTER JOIN C_PUTTestDataContainerDetail AS _PutItemDataContainer ON _PutItemDataContainer.PUTExecID = PUTExecID  -- association [0..*]
;