I_CsgnmtAndSTOTaxPrpsl

DDL: I_CSGNMTANDSTOTAXPRPSL SQL: ITAXPRPSLHEAD Type: view BASIC
41 Fields 1 Data Sources

Tax Proposal Posting Header

I_CsgnmtAndSTOTaxPrpsl (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Consignment and STO Tax Proposal · Accounting and Financial Close

I_CsgnmtAndSTOTaxPrpsl is a Basic CDS View that provides data about "Tax Proposal Posting Header" in SAP S/4HANA. It reads from 1 data source (ptxph) and exposes 41 fields with key field ProposalTaxPostingIdentifier.

SAP Help Documentation

CategoryCDS Views for Transaction Data
Data CategoryView
StatusTax Posting Status
Purpose
This CDS view provides a single-source view for all tax items in proposed tax postings created for simplified consignment or stock transfer orders for the consignment register. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to run reports using this CDS view must have the authorization to display the following data: Financial Accounting Document Users must also have a role that gives them read access to the following authorization objects and fields: Authorization for Company Codes ( F_BKPF_BUK ) Company Code ( BUKRS )

Structure
Important Fields Important fields in this view include the following: Field Name Description KURRF Accounting Exchange Rate BUKRS Company Code ERNAM Created By User ERDAT Creation Date ERZET Creation Time PTXTYPE Cross-Border Tax Proposal Category PTXSUBTYPE Cross-Border Tax Proposal Subcategory GRWCU Currency of Statistical Values for Foreign Trade KUNNR Customer STCEG Customer VAT Registration OSTCEG Departure Country/Region Company Code VAT Registration Number ISTCEG Destination Country/Region Company Code VAT Registration Number INTRA_EXCL Exclude from Intrastat Reporting GJAHR Fiscal Year INCO1 Incoterms (Part 1) BELNR Journal Entry UPNAM Last Changed by User UPDAT Last Change Date UPTIM Last Change Time MBLNR Material Document CPUDT Material Document Creation Date CPUTM Material Document Creation Time BUDAT Material Document Posting Date MJAHR Material Document Year HDR_COUNTER Number of Material Document Headers CR_COUNTER Number of Reversed Material Document HEaders VBELN Outbound Delivery FIBUDAT Posting Date PTXNU Proposal Tax Posting Identifier REGIO Region INTRA_REL Relevant for Intrastat Reporting SMBLN Reversed Material Document SJAHR Reversed Material Document Year VKORG Sales Organization OTAXCNTY Tax Departure Country/Region ITAXCNTY Tax Destination Country/Region CANCELCODE Tax Posting Cancellation Code REVERSECODE Tax Posting Reversal Code TAXSTATUS Tax Posting Status WAERK Transaction Currency

Data Extraction
Data Extraction Type Full (physical deletions are possible in source tables) Corresponding DataSource (Extractor) ITAXPRPSLHEAD Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. For details about the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-TXL-TGM
CapabilitiesData Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Data Extraction
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
ptxph TaxPropslHearder from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ITAXPRPSLHEAD view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Tax Proposal Posting Header view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Analytics.dataExtraction.enabled true view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY ProposalTaxPostingIdentifier ptxph ptxnr Proposal Tax Posting UUID
CrossBorderTaxProposalCategory ptxph ptxtype Process Type
CrossBorderTaxPrpslSubcategory ptxph ptxsubtype Consignment Type
MaterialDocument ptxph mblnr Number of Material Document
MaterialDocumentYear ptxph mjahr Material Document Year
NrOfMaterialDocumentHeaders ptxph hdr_counter Material Document Header Counter
OutboundDelivery ptxph vbeln SD Sched. Agmt
TransactionCurrency ptxph waerk SD Document Currency
CompanyCode ptxph bukrs Company Code
ReversedMaterialDocument ptxph smbln Reversed Material Document
ReversedMaterialDocumentYear ptxph sjahr Reversed Material Document Year
NrOfReversedMatlDocHeaders ptxph cr_counter Canceled/Reversed Material Document Header Counter
MaterialDocPostgDate ptxph budat Actual Goods Movement Date
MaterialDocumentCreationDate ptxph cpudt Day On Which Accounting Document Was Entered
MaterialDocCreationTime ptxph cputm Time of Entry
Customer ptxph kunnr Customer Number
TaxDepartureCountry ptxph otaxcnty Tax Departure Country/Region
TaxDestinationCountry ptxph itaxcnty Tax Destination Country/Region
TaxPostingStatus ptxph taxstatus Tax Posting Status
TaxPostingReverseCode ptxph reversecode Reversal Code
TaxPostingCancelCode ptxph cancelcode Cancellation Code
JournalEntry ptxph belnr Document Number of an Accounting Document
FiscalYear Fiscal Year
PostingDate ptxph fibudat Posting Date in FI Document
CustomerVATRegistration ptxph stceg VAT Registration Number
DeptrCtryCoCodeVATRegnNumber ptxph ostceg CoCode VAT Registration Number in Tax Departure C/R
DestCtryCoCodeVATRegnNumber ptxph istceg CoCode VAT Registration Number in Tax Destination C/R
CreatedByUser ptxph ernam Name of Person Responsible for Creating the Object
CreationDate ptxph erdat Record Created On
CreationTime ptxph erzet Entry time
LastChangedByUser ptxph upnam Last Changed By
LastChangeDate ptxph updat Date on which object was last changed
LastChangeTime ptxph uptim Last changed at
IncotermsPart1 ptxph inco1 Incoterms (Part 1)
AccountingExchangeRate Exchange Rate for FI Postings
DestinationCountry ptxph land1 Destination Country/Region
Region ptxph regio Region (State, Province, County)
ForeignTradeStstclCurrency ptxph grwcu Currency of statistical values for foreign trade
SalesOrganization ptxph vkorg Sales Organization
IsIntrastatReportingRelevant ptxph intra_rel Relevant for Intrastat Reporting
IsIntrastatReportingExcluded ptxph intra_excl Exclude from Intrastat Reporting

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 I_CsgnmtAndSTOTaxPrpsl.
-- 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: ITAXPRPSLHEAD

CREATE VIEW I_CsgnmtAndSTOTaxPrpsl AS
SELECT
  TaxPropslHearder.ptxnr AS ProposalTaxPostingIdentifier,
  TaxPropslHearder.ptxtype AS CrossBorderTaxProposalCategory,
  TaxPropslHearder.ptxsubtype AS CrossBorderTaxPrpslSubcategory,
  TaxPropslHearder.mblnr AS MaterialDocument,
  TaxPropslHearder.mjahr AS MaterialDocumentYear,
  TaxPropslHearder.hdr_counter AS NrOfMaterialDocumentHeaders,
  TaxPropslHearder.vbeln AS OutboundDelivery,
  TaxPropslHearder.waerk AS TransactionCurrency,
  TaxPropslHearder.bukrs AS CompanyCode,
  TaxPropslHearder.smbln AS ReversedMaterialDocument,
  TaxPropslHearder.sjahr AS ReversedMaterialDocumentYear,
  TaxPropslHearder.cr_counter AS NrOfReversedMatlDocHeaders,
  TaxPropslHearder.budat AS MaterialDocPostgDate,
  TaxPropslHearder.cpudt AS MaterialDocumentCreationDate,
  TaxPropslHearder.cputm AS MaterialDocCreationTime,
  TaxPropslHearder.kunnr AS Customer,
  TaxPropslHearder.otaxcnty AS TaxDepartureCountry,
  TaxPropslHearder.itaxcnty AS TaxDestinationCountry,
  TaxPropslHearder.taxstatus AS TaxPostingStatus,
  TaxPropslHearder.reversecode AS TaxPostingReverseCode,
  TaxPropslHearder.cancelcode AS TaxPostingCancelCode,
  TaxPropslHearder.belnr AS JournalEntry,
  cast(TaxPropslHearder.gjahr as fis_gjahr_no_conv preserving type) AS FiscalYear,
  TaxPropslHearder.fibudat AS PostingDate,
  TaxPropslHearder.stceg AS CustomerVATRegistration,
  TaxPropslHearder.ostceg AS DeptrCtryCoCodeVATRegnNumber,
  TaxPropslHearder.istceg AS DestCtryCoCodeVATRegnNumber,
  TaxPropslHearder.ernam AS CreatedByUser,
  TaxPropslHearder.erdat AS CreationDate,
  TaxPropslHearder.erzet AS CreationTime,
  TaxPropslHearder.upnam AS LastChangedByUser,
  TaxPropslHearder.updat AS LastChangeDate,
  TaxPropslHearder.uptim AS LastChangeTime,
  TaxPropslHearder.inco1 AS IncotermsPart1,
  cast( TaxPropslHearder.kurrf as kurrf_not_converted preserving type ) AS AccountingExchangeRate,
  TaxPropslHearder.land1 AS DestinationCountry,
  TaxPropslHearder.regio AS Region,
  TaxPropslHearder.grwcu AS ForeignTradeStstclCurrency,
  TaxPropslHearder.vkorg AS SalesOrganization,
  TaxPropslHearder.intra_rel AS IsIntrastatReportingRelevant,
  TaxPropslHearder.intra_excl AS IsIntrastatReportingExcluded
FROM ptxph AS TaxPropslHearder
;

Learn More