Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_PL_SAFTTaxItemCnsldtnCube

DDL: C_PL_SAFTTAXITEMCNSLDTNCUBE SQL: CPLSAFTTAXCONSC Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_PL
57 Fields 2 Data Sources

SAF-T Tax Item Consolidation Cube

C_PL_SAFTTaxItemCnsldtnCube is a Consumption CDS View (Cube) that provides data about "SAF-T Tax Item Consolidation Cube" in SAP S/4HANA. It reads from 2 data sources (I_SAFTConsolidationKey, I_PL_SAFTTaxItem) and exposes 57 fields with key fields SAFTConsolidationUUID, MasterDataSourceNode, CompanyCode, FiscalYear, AccountingDocument. Part of development package GLO_FIN_IS_SAFT_PL.

Data Sources (2)

SourceAliasJoin Type
I_SAFTConsolidationKey saftn_consolidation inner
I_PL_SAFTTaxItem saftn_pl_vat from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPLSAFTTAXCONSC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label SAF-T Tax Item Consolidation Cube view
VDM.lifecycle.status #DEPRECATED view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY SAFTConsolidationUUID I_SAFTConsolidationKey SAFTConsolidationUUID Consolidation ID
KEY MasterDataSourceNode MasterDataSourceNode ViolationSource
KEY CompanyCode I_PL_SAFTTaxItem CompanyCode Receiver Company Code
KEY FiscalYear I_PL_SAFTTaxItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_PL_SAFTTaxItem AccountingDocument Journal Entry
SAFTExtractionUUID I_SAFTConsolidationKey SAFTExtractionUUID Extraction ID
Customer Customer Sold-to Party
Supplier Supplier Supplier
DeliveryDate DeliveryDate Delivery Date
InvoiceReceiptDate InvoiceReceiptDate Invoice Receipt Date
TaxReportingDate TaxReportingDate Tax Reporting Date
AccountingDocumentType AccountingDocumentType Journal Entry Type
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
ReferenceDocumentType ReferenceDocumentType Reference Document Type
OriginalReferenceDocument OriginalReferenceDocument Reference Key
AlternativeReferenceDocument AlternativeReferenceDocument Alternative Reference Document
Currency Currency Valuation Crcy
PL_SAFTNetAmount10 PL_SAFTNetAmount10 K_10
PL_SAFTNetAmount11 PL_SAFTNetAmount11 K_11
PL_SAFTNetAmount12 PL_SAFTNetAmount12 K_12
PL_SAFTNetAmount13 PL_SAFTNetAmount13 K_13
PL_SAFTNetAmount14 PL_SAFTNetAmount14 K_14
PL_SAFTNetAmount15 PL_SAFTNetAmount15 K_15
PL_SAFTTaxAmount16 PL_SAFTTaxAmount16 K_16
PL_SAFTNetAmount17 PL_SAFTNetAmount17 K_17
PL_SAFTTaxAmount18 PL_SAFTTaxAmount18 K_18
PL_SAFTNetAmount19 PL_SAFTNetAmount19 K_19
PL_SAFTTaxAmount20 PL_SAFTTaxAmount20 K_20
PL_SAFTNetAmount21 PL_SAFTNetAmount21 K_21
PL_SAFTNetAmount22 PL_SAFTNetAmount22 K_22
PL_SAFTNetAmount23 PL_SAFTNetAmount23 K_23
PL_SAFTTaxAmount24 PL_SAFTTaxAmount24 K_24
PL_SAFTNetAmount25 PL_SAFTNetAmount25 K_25
PL_SAFTTaxAmount26 PL_SAFTTaxAmount26 K_26
PL_SAFTNetAmount27 PL_SAFTNetAmount27 K_27
PL_SAFTTaxAmount28 PL_SAFTTaxAmount28 K_28
PL_SAFTNetAmount29 PL_SAFTNetAmount29 K_29
PL_SAFTTaxAmount30 PL_SAFTTaxAmount30 K_30
PL_SAFTNetAmount31 PL_SAFTNetAmount31 K_31
PL_SAFTNetAmount32 PL_SAFTNetAmount32 K_32
PL_SAFTTaxAmount33 PL_SAFTTaxAmount33 K_33
PL_SAFTNetAmount34 PL_SAFTNetAmount34 K_34
PL_SAFTTaxAmount35 PL_SAFTTaxAmount35 K_35
PL_SAFTTaxAmount36 PL_SAFTTaxAmount36 K_36
PL_SAFTTaxAmount38 PL_SAFTTaxAmount38 K_38
PL_SAFTTaxAmount39 PL_SAFTTaxAmount39 K_39
PL_SAFTNetAmount43 PL_SAFTNetAmount43 K_43
PL_SAFTTaxAmount44 PL_SAFTTaxAmount44 K_44
PL_SAFTNetAmount45 PL_SAFTNetAmount45 K_45
PL_SAFTTaxAmount46 PL_SAFTTaxAmount46 K_46
SupplierTotalTaxAmount
CompanyName
HouseNumber1asCompanyCodeAddress
CompanyVATRegistration
CompanyCodeCurrency
EmailAddress EmailAddress E-Mail Address

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_PL_SAFTTaxItemCnsldtnCube.
-- 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: CPLSAFTTAXCONSC

CREATE VIEW C_PL_SAFTTaxItemCnsldtnCube AS
SELECT
  saftn_consolidation.SAFTConsolidationUUID AS SAFTConsolidationUUID,
  MasterDataSourceNode,
  saftn_pl_vat.CompanyCode AS CompanyCode,
  saftn_pl_vat.FiscalYear AS FiscalYear,
  saftn_pl_vat.AccountingDocument AS AccountingDocument,
  saftn_consolidation.SAFTExtractionUUID AS SAFTExtractionUUID,
  Customer,
  Supplier,
  DeliveryDate,
  InvoiceReceiptDate,
  TaxReportingDate,
  AccountingDocumentType,
  DocumentDate,
  PostingDate,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  AlternativeReferenceDocument,
  Currency,
  PL_SAFTNetAmount10,
  PL_SAFTNetAmount11,
  PL_SAFTNetAmount12,
  PL_SAFTNetAmount13,
  PL_SAFTNetAmount14,
  PL_SAFTNetAmount15,
  PL_SAFTTaxAmount16,
  PL_SAFTNetAmount17,
  PL_SAFTTaxAmount18,
  PL_SAFTNetAmount19,
  PL_SAFTTaxAmount20,
  PL_SAFTNetAmount21,
  PL_SAFTNetAmount22,
  PL_SAFTNetAmount23,
  PL_SAFTTaxAmount24,
  PL_SAFTNetAmount25,
  PL_SAFTTaxAmount26,
  PL_SAFTNetAmount27,
  PL_SAFTTaxAmount28,
  PL_SAFTNetAmount29,
  PL_SAFTTaxAmount30,
  PL_SAFTNetAmount31,
  PL_SAFTNetAmount32,
  PL_SAFTTaxAmount33,
  PL_SAFTNetAmount34,
  PL_SAFTTaxAmount35,
  PL_SAFTTaxAmount36,
  PL_SAFTTaxAmount38,
  PL_SAFTTaxAmount39,
  PL_SAFTNetAmount43,
  PL_SAFTTaxAmount44,
  PL_SAFTNetAmount45,
  PL_SAFTTaxAmount46,
  (PL_SAFTTaxAmount44 + PL_SAFTTaxAmount46 ) AS SupplierTotalTaxAmount,
  '' AS CompanyName,
  concat_with_space(concat_with_space(concat_with_space(saftn_pl_vat._CompanyCode._Address.CityName,saftn_pl_vat._CompanyCode._Address.PostalCode, 1), saftn_pl_vat._CompanyCode._Address.StreetName,1),saftn_pl_vat._CompanyCode._Address.HouseNumber,1) as CompanyCodeAddress AS HouseNumber1asCompanyCodeAddress,
  replace(saftn_pl_vat._CompanyCode.VATRegistration,_CompanyCode.Country,'') AS CompanyVATRegistration,
  saftn_pl_vat._CompanyCode.Currency AS CompanyCodeCurrency,
  EmailAddress
FROM I_PL_SAFTTaxItem AS saftn_pl_vat
INNER JOIN I_SAFTConsolidationKey AS saftn_consolidation ON /* join condition not captured in parsed metadata */
;

Learn More