What is I_CsgnmtAndSTOTaxPrpslItem in SAP S/4HANA?

I_CsgnmtAndSTOTaxPrpslItem is a basic CDS view in SAP S/4HANA. Tax Proposal Posting Item It contains 40 fields.

Which tables does I_CsgnmtAndSTOTaxPrpslItem read from?

I_CsgnmtAndSTOTaxPrpslItem reads data from: ptxpi.

What VDM layer is I_CsgnmtAndSTOTaxPrpslItem?

I_CsgnmtAndSTOTaxPrpslItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_CsgnmtAndSTOTaxPrpslItem

DDL: I_CSGNMTANDSTOTAXPRPSLITEM SQL: ITAXPRPSLITEM Type: view BASIC

40 Fields 1 Data Sources 1 Associations

Tax Proposal Posting Item

I_CsgnmtAndSTOTaxPrpslItem (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_CsgnmtAndSTOTaxPrpslItem is a Basic CDS View that provides data about "Tax Proposal Posting Item" in SAP S/4HANA. It reads from 1 data source (ptxpi) and exposes 40 fields with key fields ProposalTaxPostingIdentifier, ProposalTaxPostingItem. It has 1 association to related views.

SAP Help Documentation

Category	CDS Views for Transaction Data
Data Category	View

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 MEINS Base Unit CHARG Batch ITM_COMCO Commodity Code SPE_HERKL Country of Origin NSDM_KUNNR Customer for Special Stock WERKS Delivering Plant VGTYP Document Category of Preceding SD Document UECHA Higher Level of Batch Split Item BWRTR Item Gross Amount of Billing Document NETWR Item Net Amount of Billing Document MATNR Material ZEILE Material Document Item NTGEW Material Net Weight POSNR Outbound Delivery Item KURSK Price Exchange Rate PTXNR Proposal Tax Posting Identifier PTXIT Proposal Tax Posting Item FKLMG Quantity in Entry Unit FKIMG Quantity in Entry Base Unit UMWRK Receiving Plant SPE_HERKR Region of Origin SMBLP Reversed Material Document Item AUBEL Sales Document AUTYP Sales Document Category AUPOS Sales Document Item PSTYV Sales Document Item Category ARKTX Sales Document Item Text VRKME Sales Unit FBUDA Service Rendered Date KUNWE Ship-to Party KUNAG Sold-to Party GRWRT Statistical Value for Foreign Trade GEWEI Weight Unit

Data Extraction
Data Extraction Type Full (physical deletions are possible in source tables) Corresponding DataSource (Extractor) ITAXPRPSLITEM 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

State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-TXL-TGM
Capabilities	Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Data Extraction
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
ptxpi	TaxPropslItem	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_CsgnmtAndSTOTaxPrpsl	_TaxProposalHeader	`$projection.ProposalTaxPostingIdentifier = _TaxProposalHeader.ProposalTaxPostingIdentifier`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	ITAXPRPSLITEM	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 Item	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
Analytics.dataExtraction.enabled	true	view

Fields (40)

Key	Field	Source Table	Source Field	Description
KEY	ProposalTaxPostingIdentifier	ptxpi	ptxnr	Proposal Tax Posting UUID
KEY	ProposalTaxPostingItem	ptxpi	ptxit	Proposal Tax Posting Item Number
	DeliveringPlant	ptxpi	werks	Receiving Plant
	ReceivingPlant	ptxpi	umwrk	Receiving plant/issuing plant
	MaterialDocumentItem	ptxpi	zeile	Item in Material Document
	OutboundDeliveryItem	ptxpi	posnr	Delivery Item
	Batch	ptxpi	charg	Chargeable Proc.
	HigherLvlItmOfBatSpltItm	ptxpi	uecha	Higher-Level Item of Batch Split Item
	MaterialIsIntBatchManaged	ptxpi	xchar	Batch management indicator (internal)
	ReversedMaterialDocumentItem	ptxpi	smblp	Reversed Material Document Item
	Material	ptxpi	matnr	Material Number
	TransactionCurrency	_TaxProposalHeader	TransactionCurrency	Transaction Currency
	ForeignTradeStstclCurrency	_TaxProposalHeader	ForeignTradeStstclCurrency	Currency of statistical values for foreign trade
	QuantityInEntryUnit	ptxpi	fkimg	Actual Invoiced Quantity
	SalesUnit	ptxpi	vrkme	UoM for SubItm CCD
	QuantityInEntryUnitBaseUnit	ptxpi	fklmg	Billing quantity in stock keeping unit
	BaseUnit	ptxpi	meins	Base Unit of Measure
	MaterialNetWeight	ptxpi	ntgew	Net Weight
	WeightUnit	ptxpi	gewei	Unit of Weight
	ServicesRenderedDate	ptxpi	fbuda	Date on which services are rendered
	PriceDetnExchangeRate			Exchange Rate for Price Determination
	ItemNetAmountOfBillingDoc	ptxpi	netwr	Net Value of Billing item in Document Currency
	PrecdgSDDocCategory	ptxpi	vgtyp	Document Category of Preceding SD Document
	SalesDocument	ptxpi	aubel	Sales Document
	SalesDocumentItem	ptxpi	aupos	Sales Document Item
	SalesDocumentItemText	ptxpi	arktx	Short text for sales order item
	SalesDocumentItemCategory	ptxpi	pstyv	Sales Document Item Category
	SDDocumentCategory	ptxpi	autyp	SD Document Category
	ItemGrossAmountOfBillingDoc	ptxpi	brtwr	Gross Value of the Billing Item in Document Currency
	ForeignTradeStstclAmt	ptxpi	grwrt	Statistical value for foreign trade
	CountryOfOrigin	ptxpi	spe_herkl	Country/Region of Origin of Material (Non-Preferential Ori.)
	RegionOfOrigin	ptxpi	spe_herkr	Region of Origin of Material (Non-Preferential Origin)
	CommodityCode	ptxpi	itm_comco	Commodity Code
	SpecialStockIdfgCustomer	ptxpi	nsdm_kunnr	Customer for Special Stock
	SoldToParty	ptxpi	kunag	Sold-to Party
	SoldToPartyAddressID	ptxpi	kunag_adr	Address number of the sold-to party
	ShipToParty	ptxpi	kunwe	Ship-to Party
	ShipToPartyAddressID	ptxpi	kunwe_adr	Address number of the ship-to party
	CompanyCode	_TaxProposalHeader	CompanyCode	Receiver Company Code
	_TaxProposalHeader		_TaxProposalHeader

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_CsgnmtAndSTOTaxPrpslItem.
-- 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: ITAXPRPSLITEM

CREATE VIEW I_CsgnmtAndSTOTaxPrpslItem AS
SELECT
  TaxPropslItem.ptxnr AS ProposalTaxPostingIdentifier,
  TaxPropslItem.ptxit AS ProposalTaxPostingItem,
  TaxPropslItem.werks AS DeliveringPlant,
  TaxPropslItem.umwrk AS ReceivingPlant,
  TaxPropslItem.zeile AS MaterialDocumentItem,
  TaxPropslItem.posnr AS OutboundDeliveryItem,
  TaxPropslItem.charg AS Batch,
  TaxPropslItem.uecha AS HigherLvlItmOfBatSpltItm,
  TaxPropslItem.xchar AS MaterialIsIntBatchManaged,
  TaxPropslItem.smblp AS ReversedMaterialDocumentItem,
  TaxPropslItem.matnr AS Material,
  _TaxProposalHeader.TransactionCurrency AS TransactionCurrency,
  _TaxProposalHeader.ForeignTradeStstclCurrency AS ForeignTradeStstclCurrency,
  TaxPropslItem.fkimg AS QuantityInEntryUnit,
  TaxPropslItem.vrkme AS SalesUnit,
  TaxPropslItem.fklmg AS QuantityInEntryUnitBaseUnit,
  TaxPropslItem.meins AS BaseUnit,
  TaxPropslItem.ntgew AS MaterialNetWeight,
  TaxPropslItem.gewei AS WeightUnit,
  TaxPropslItem.fbuda AS ServicesRenderedDate,
  cast( TaxPropslItem.kursk as kursk_not_converted preserving type ) AS PriceDetnExchangeRate,
  TaxPropslItem.netwr AS ItemNetAmountOfBillingDoc,
  TaxPropslItem.vgtyp AS PrecdgSDDocCategory,
  TaxPropslItem.aubel AS SalesDocument,
  TaxPropslItem.aupos AS SalesDocumentItem,
  TaxPropslItem.arktx AS SalesDocumentItemText,
  TaxPropslItem.pstyv AS SalesDocumentItemCategory,
  TaxPropslItem.autyp AS SDDocumentCategory,
  TaxPropslItem.brtwr AS ItemGrossAmountOfBillingDoc,
  TaxPropslItem.grwrt AS ForeignTradeStstclAmt,
  TaxPropslItem.spe_herkl AS CountryOfOrigin,
  TaxPropslItem.spe_herkr AS RegionOfOrigin,
  TaxPropslItem.itm_comco AS CommodityCode,
  TaxPropslItem.nsdm_kunnr AS SpecialStockIdfgCustomer,
  TaxPropslItem.kunag AS SoldToParty,
  TaxPropslItem.kunag_adr AS SoldToPartyAddressID,
  TaxPropslItem.kunwe AS ShipToParty,
  TaxPropslItem.kunwe_adr AS ShipToPartyAddressID,
  _TaxProposalHeader.CompanyCode AS CompanyCode
FROM ptxpi AS TaxPropslItem
LEFT OUTER JOIN I_CsgnmtAndSTOTaxPrpsl AS _TaxProposalHeader ON ProposalTaxPostingIdentifier = _TaxProposalHeader.ProposalTaxPostingIdentifier  -- association [1..1]
;

Depth:

I_CsgnmtAndSTOTaxPrpslItem view

ptxpi

FAC_AUDIT_Z3_PROPOSE_TAX_VIEW view