SRFD_RECONDOCDATA

DDL: SRFD_RECONDOCDATA Type: view_entity Package: GLO_GEN_SRF_RUNTIME
33 Fields 5 Data Sources

Reconciled Document Data

SRFD_RECONDOCDATA is a CDS View that provides data about "Reconciled Document Data" in SAP S/4HANA. It reads from 5 data sources (SRFD_DocumentData, SRFD_DocumentData, srf_rep_doc_rec, srf_rep_doc_rec, SRFD_DocumentData) and exposes 33 fields with key fields systDocumentKey, systDocDataKey, authDocDataKey, systDocDataKey, authDocDataKey. Part of development package GLO_GEN_SRF_RUNTIME.

Data Sources (5)

SourceAliasJoin Type
SRFD_DocumentData authority left_outer
SRFD_DocumentData authority inner
srf_rep_doc_rec recon from
srf_rep_doc_rec recon union_all
SRFD_DocumentData systemDoc inner

Parameters (2)

NameTypeDefault
p_systdoc_partition srf_partition_no
p_authdoc_partition srf_partition_no

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Reconciled Document Data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY systDocumentKey SRFD_DocumentData StatryRptDocUUID UUID
KEY systDocDataKey SRFD_DocumentData StatryRptDocDataUUID NodeID
KEY authDocDataKey srf_rep_doc_rec auth_doc_data_key NodeID
authDocumentKey SRFD_DocumentData StatryRptDocUUID UUID
StatryRptPartitionNoendassystPartitionNo
StatryRptPartitionNoendasauthPartitionNo
StatryRptSchemaElementId SRFD_DocumentData StatryRptSchemaElementId OAN Element ID
StatryRptSchemaAttributeId SRFD_DocumentData StatryRptSchemaAttributeId INT4
systParentSeqNo SRFD_DocumentData StatryRptParentSequenceNumber Sqnc No. in Par File
systSequenceNumber SRFD_DocumentData StatryRptSequenceNumber Sqnc No. in Ext File
systValue SRFD_DocumentData StatryRptDocDataValue
systGeneratedValue SRFD_DocumentData StatryRptDocDataGeneratedValue Value
systModifiedValue SRFD_DocumentData StatryRptDocDataModifiedValue Value
systDataChangeInd SRFD_DocumentData StatryRptDocDataChangeInd Change Type
authValue SRFD_DocumentData StatryRptDocDataValue
syst_doc_keyassystDocumentKey
KEY systDocDataKey srf_rep_doc_rec syst_doc_data_key NodeID
KEY authDocDataKey srf_rep_doc_rec auth_doc_data_key NodeID
authDocumentKey SRFD_DocumentData StatryRptDocUUID UUID
systPartitionNo 0
StatryRptPartitionNoendasauthPartitionNo
StatryRptSchemaElementId SRFD_DocumentData StatryRptSchemaElementId OAN Element ID
StatryRptSchemaAttributeId SRFD_DocumentData StatryRptSchemaAttributeId INT4
systParentSeqNo 0 Sqnc No. in Par File
authParentSeqNo SRFD_DocumentData StatryRptParentSequenceNumber Sqnc No. in Par File
systSequenceNumber 0 Sqnc No. in Ext File
authSequenceNumber SRFD_DocumentData StatryRptSequenceNumber Sqnc No. in Ext File
systValue
systGeneratedValue Value
systModifiedValue Value
systDataChangeInd Change Type
authValue SRFD_DocumentData StatryRptDocDataValue
reconStatus srf_rep_doc_rec status Workflow Status

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 SRFD_RECONDOCDATA.
-- 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.
-- Parameters: p_systdoc_partition : srf_partition_no, p_authdoc_partition : srf_partition_no

CREATE VIEW SRFD_RECONDOCDATA AS
SELECT
  systemDoc.StatryRptDocUUID AS systDocumentKey,
  systemDoc.StatryRptDocDataUUID AS systDocDataKey,
  recon.auth_doc_data_key AS authDocDataKey,
  systemDoc.StatryRptDocUUID AS authDocumentKey,
  case when systemDoc.StatryRptPartitionNo is null then 0 else systemDoc.StatryRptPartitionNo end as systPartitionNo AS StatryRptPartitionNoendassystPartitionNo,
  case when authority.StatryRptPartitionNo is null then 0 else authority.StatryRptPartitionNo end as authPartitionNo AS StatryRptPartitionNoendasauthPartitionNo,
  systemDoc.StatryRptSchemaElementId AS StatryRptSchemaElementId,
  systemDoc.StatryRptSchemaAttributeId AS StatryRptSchemaAttributeId,
  systemDoc.StatryRptParentSequenceNumber AS systParentSeqNo,
  systemDoc.StatryRptSequenceNumber AS systSequenceNumber,
  systemDoc.StatryRptDocDataValue AS systValue,
  systemDoc.StatryRptDocDataGeneratedValue AS systGeneratedValue,
  systemDoc.StatryRptDocDataModifiedValue AS systModifiedValue,
  systemDoc.StatryRptDocDataChangeInd AS systDataChangeInd,
  authority.StatryRptDocDataValue AS authValue,
  recon.status as reconStatus AS syst_doc_keyassystDocumentKey,
  0 AS systPartitionNo,
  authority.StatryRptParentSequenceNumber AS authParentSeqNo,
  authority.StatryRptSequenceNumber AS authSequenceNumber,
  recon.status AS reconStatus
FROM srf_rep_doc_rec AS recon
INNER JOIN SRFD_DocumentData AS systemDoc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SRFD_DocumentData AS authority ON /* join condition not captured in parsed metadata */
INNER JOIN SRFD_DocumentData AS authority ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): srf_rep_doc_rec
;

Learn More