P_SK_CAReconKeyMerge

DDL: P_SK_CARECONKEYMERGE Type: view_entity COMPOSITE Package: FKK_ID_SK_REP
7 Fields 4 Data Sources

Merge of recon keys from CA and FI

P_SK_CAReconKeyMerge is a Composite CDS View that provides data about "Merge of recon keys from CA and FI" in SAP S/4HANA. It reads from 4 data sources (P_SK_CATotalsRecordTax, P_SK_CATotalsRecordTax, P_SK_CABsetTaxItemRecKey, P_SK_CABsetTaxItemRecKey) and exposes 7 fields with key fields CompanyCode, CAReconciliationKey, CAPostingDate, CompanyCode, CAReconciliationKey. Part of development package FKK_ID_SK_REP.

Data Sources (4)

SourceAliasJoin Type
P_SK_CATotalsRecordTax CASumTaxKey inner
P_SK_CATotalsRecordTax CASumTaxKey inner
P_SK_CABsetTaxItemRecKey GlSumTaxKey from
P_SK_CABsetTaxItemRecKey GlSumTaxKey union

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_SK_CATotalsRecordTax CompanyCode Receiver Company Code
KEY CAReconciliationKey P_SK_CATotalsRecordTax CAReconciliationKey Reconcil. Key
KEY CAPostingDate P_SK_CATotalsRecordTax CAPostingDate Posting Date
KEY CompanyCode Receiver Company Code
KEY CAReconciliationKey P_SK_CATotalsRecordTax CAReconciliationKey Reconcil. Key
KEY CAPostingDate P_SK_CATotalsRecordTax CAPostingDate Posting Date
KEY TaxReportingDate P_SK_CATotalsRecordTax TaxReportingDate Tax Reporting Date

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_SK_CAReconKeyMerge.
-- 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_SK_CAReconKeyMerge AS
SELECT
  CASumTaxKey.CompanyCode AS CompanyCode,
  CASumTaxKey.CAReconciliationKey AS CAReconciliationKey,
  CASumTaxKey.CAPostingDate AS CAPostingDate,
  CASumTaxKey.TaxReportingDate AS TaxReportingDate
FROM P_SK_CABsetTaxItemRecKey AS GlSumTaxKey
INNER JOIN P_SK_CATotalsRecordTax AS CASumTaxKey ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): P_SK_CABsetTaxItemRecKey
;

Learn More