C_PL_SAFTTaxItemCnsldtnQuery

DDL: C_PL_SAFTTAXITEMCNSLDTNQUERY SQL: CPLSAFTTAXCONSQ Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_PL
56 Fields 1 Data Sources

SAF-T Tax Item Consolidation Query

C_PL_SAFTTaxItemCnsldtnQuery is a Consumption CDS View that provides data about "SAF-T Tax Item Consolidation Query" in SAP S/4HANA. It reads from 1 data source (C_PL_SAFTTaxItemCnsldtnCube) and exposes 56 fields with key fields SAFTConsolidationUUID, CompanyCode, FiscalYear, AccountingDocument. Part of development package GLO_FIN_IS_SAFT_PL.

Data Sources (1)

SourceAliasJoin Type
C_PL_SAFTTaxItemCnsldtnCube saftn_pl_vat from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPLSAFTTAXCONSQ view
EndUserText.label SAF-T Tax Item Consolidation Query view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.query true view
Analytics.settings.maxProcessingEffort #HIGH view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY SAFTConsolidationUUID SAFTConsolidationUUID
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
FullName FullName Name
CustomerSupplierAddress CustomerSupplierAddress
VATRegistration VATRegistration VAT Registration No.
DocumentReferenceID DocumentReferenceID Reference
MasterDataSourceNode MasterDataSourceNode
SAFTExtractionUUID SAFTExtractionUUID
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
Currency Currency Valuation Crcy
PL_SAFTNetAmount10 PL_SAFTNetAmount10
PL_SAFTNetAmount11 PL_SAFTNetAmount11
PL_SAFTNetAmount12 PL_SAFTNetAmount12
PL_SAFTNetAmount13 PL_SAFTNetAmount13
PL_SAFTNetAmount14 PL_SAFTNetAmount14
PL_SAFTNetAmount15 PL_SAFTNetAmount15
PL_SAFTTaxAmount16 PL_SAFTTaxAmount16
PL_SAFTNetAmount17 PL_SAFTNetAmount17
PL_SAFTTaxAmount18 PL_SAFTTaxAmount18
PL_SAFTNetAmount19 PL_SAFTNetAmount19
PL_SAFTTaxAmount20 PL_SAFTTaxAmount20
PL_SAFTNetAmount21 PL_SAFTNetAmount21
PL_SAFTNetAmount22 PL_SAFTNetAmount22
PL_SAFTNetAmount23 PL_SAFTNetAmount23
PL_SAFTTaxAmount24 PL_SAFTTaxAmount24
PL_SAFTNetAmount25 PL_SAFTNetAmount25
PL_SAFTTaxAmount26 PL_SAFTTaxAmount26
PL_SAFTNetAmount27 PL_SAFTNetAmount27
PL_SAFTTaxAmount28 PL_SAFTTaxAmount28
PL_SAFTNetAmount29 PL_SAFTNetAmount29
PL_SAFTTaxAmount30 PL_SAFTTaxAmount30
PL_SAFTNetAmount31 PL_SAFTNetAmount31
PL_SAFTNetAmount32 PL_SAFTNetAmount32
PL_SAFTTaxAmount33 PL_SAFTTaxAmount33
PL_SAFTNetAmount34 PL_SAFTNetAmount34
PL_SAFTTaxAmount35 PL_SAFTTaxAmount35
PL_SAFTTaxAmount36 PL_SAFTTaxAmount36
PL_SAFTTaxAmount38 PL_SAFTTaxAmount38
PL_SAFTTaxAmount39 PL_SAFTTaxAmount39
PL_SAFTNetAmount43 PL_SAFTNetAmount43
PL_SAFTTaxAmount44 PL_SAFTTaxAmount44
PL_SAFTNetAmount45 PL_SAFTNetAmount45
PL_SAFTTaxAmount46 PL_SAFTTaxAmount46
CustomerTotalTaxAmount CustomerTotalTaxAmount Customer Total Tax Amount
SupplierTotalTaxAmount SupplierTotalTaxAmount Supplier Total Tax Amount

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_SAFTTaxItemCnsldtnQuery.
-- 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: CPLSAFTTAXCONSQ

CREATE VIEW C_PL_SAFTTaxItemCnsldtnQuery AS
SELECT
  SAFTConsolidationUUID,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  FullName,
  CustomerSupplierAddress,
  VATRegistration,
  DocumentReferenceID,
  MasterDataSourceNode,
  SAFTExtractionUUID,
  Customer,
  Supplier,
  DeliveryDate,
  InvoiceReceiptDate,
  TaxReportingDate,
  AccountingDocumentType,
  DocumentDate,
  PostingDate,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  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,
  CustomerTotalTaxAmount,
  SupplierTotalTaxAmount
FROM C_PL_SAFTTaxItemCnsldtnCube AS saftn_pl_vat
;

Learn More