P_LOG_REN_Header

DDL: P_LOG_REN_HEADER Type: view_entity COMPOSITE
16 Fields 1 Data Sources 1 Associations

P_LOG_REN_Header is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_CnsldtnTaskLogHeader) and exposes 16 fields. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnTaskLogHeader header from

Associations (1)

CardinalityTargetAliasCondition
[1..*] P_CnsldtnPstRlLgUnqCnsldtnUnt _CU $projection.cnsldtnlognumber = _CU.CnsldtnPostingRuleLogUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (16)

KeyFieldSource TableSource FieldDescription
userid I_CnsldtnTaskLogHeader UserID User Name
cnsldtntask I_CnsldtnTaskLogHeader ConsolidationTask Task
externalid I_CnsldtnTaskLogHeader ExternalId SRM Reference
cnsldtngroup I_CnsldtnTaskLogHeader ConsolidationGroup Cons. Group
cnsldtnunit I_CnsldtnTaskLogHeader ConsolidationUnit Consolidation Unit
fiscalyear I_CnsldtnTaskLogHeader FiscalYear G/L Fiscal Year
fiscalperiod I_CnsldtnTaskLogHeader FiscalPeriod Tax period
status I_CnsldtnTaskLogHeader CnsldtnTaskLogMessageType Workflow Status
UpdateMode I_CnsldtnTaskLogHeader CnsldtnIsUpdateMode Update mode
Is_Cumulative I_CnsldtnTaskLogHeader CnsldtnIsCumulative Is Cumulative
TimeStamp I_CnsldtnTaskLogHeader CnsldtnLogHeaderDateTime
yearperiod I_CnsldtnTaskLogHeader FiscalYearPeriod Period/Year
ReferenceApplicationJobName I_CnsldtnTaskLogHeader ReferenceApplicationJobName Job Name
ApplicationJob I_CnsldtnTaskLogHeader ApplicationJob Job No.
JobStepNumber I_CnsldtnTaskLogHeader JobStepNumber Step no.
_CU _CU

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_LOG_REN_Header.
-- 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 P_LOG_REN_Header AS
SELECT
  header.UserID AS userid,
  header.ConsolidationTask AS cnsldtntask,
  header.ExternalId AS externalid,
  header.ConsolidationGroup AS cnsldtngroup,
  header.ConsolidationUnit AS cnsldtnunit,
  header.FiscalYear AS fiscalyear,
  header.FiscalPeriod AS fiscalperiod,
  header.CnsldtnTaskLogMessageType AS status,
  header.CnsldtnIsUpdateMode AS UpdateMode,
  header.CnsldtnIsCumulative AS Is_Cumulative,
  header.CnsldtnLogHeaderDateTime AS TimeStamp,
  header.FiscalYearPeriod AS yearperiod,
  header.ReferenceApplicationJobName AS ReferenceApplicationJobName,
  header.ApplicationJob AS ApplicationJob,
  header.JobStepNumber AS JobStepNumber
FROM I_CnsldtnTaskLogHeader AS header
LEFT OUTER JOIN P_CnsldtnPstRlLgUnqCnsldtnUnt AS _CU ON cnsldtnlognumber = _CU.CnsldtnPostingRuleLogUUID  -- association [1..*]
;

Learn More