P_SlsPurListBPTaxItem

DDL: P_SLSPURLISTBPTAXITEM SQL: PSPLSTBPTAXITM Type: view CONSUMPTION
53 Fields 2 Data Sources

Sales Purchase List BP Tax Item

P_SlsPurListBPTaxItem is a Consumption CDS View that provides data about "Sales Purchase List BP Tax Item" in SAP S/4HANA. It reads from 2 data sources (P_SlsPurListBPTaxItem20, I_TaxCode) and exposes 53 fields with key fields CompanyCode, FiscalYear, AccountingDocument, TaxItem.

Data Sources (2)

SourceAliasJoin Type
P_SlsPurListBPTaxItem20 itm from
I_TaxCode txc left_outer

Annotations (7)

NameValueLevelField
EndUserText.label Sales Purchase List BP Tax Item view
AbapCatalog.sqlViewName PSPLSTBPTAXITM view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_SlsPurListBPTaxItem20 CompanyCode Receiver Company Code
KEY FiscalYear P_SlsPurListBPTaxItem20 FiscalYear G/L Fiscal Year
KEY AccountingDocument P_SlsPurListBPTaxItem20 AccountingDocument Journal Entry
KEY TaxItem P_SlsPurListBPTaxItem20 TaxItem Tax Item
TaxCode P_SlsPurListBPTaxItem20 TaxCode Tax Code
TransactionTypeDetermination P_SlsPurListBPTaxItem20 TransactionTypeDetermination Transaction Key
TaxBaseAmountInCoCodeCrcy P_SlsPurListBPTaxItem20 TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy P_SlsPurListBPTaxItem20 TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxRate P_SlsPurListBPTaxItem20 TaxRate Tax Rate
TaxCountry P_SlsPurListBPTaxItem20 TaxCountry Tax Ctry/Reg.
TaxReturnCountry P_SlsPurListBPTaxItem20 TaxReturnCountry Reporting C/R
TaxBaseAmountInCountryCrcy P_SlsPurListBPTaxItem20 TaxBaseAmountInCountryCrcy Base Amount
TaxAmountInCountryCrcy P_SlsPurListBPTaxItem20 TaxAmountInCountryCrcy Tax Rept. Crcy
BusinessPlace P_SlsPurListBPTaxItem20 BusinessPlace Business place
TaxAmount P_SlsPurListBPTaxItem20 TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInTransCrcy P_SlsPurListBPTaxItem20 TaxBaseAmountInTransCrcy Value-Added Tax
CompanyCodeCountry P_SlsPurListBPTaxItem20 CompanyCodeCountry Reporting Ctry/Reg.
AccountingDocumentType P_SlsPurListBPTaxItem20 AccountingDocumentType Journal Entry Type
DocumentDate P_SlsPurListBPTaxItem20 DocumentDate Journal Entry Date
PostingDate P_SlsPurListBPTaxItem20 PostingDate Posting Date for GR
TaxReportingDate P_SlsPurListBPTaxItem20 TaxReportingDate Tax Reporting Date
ReportingDate P_SlsPurListBPTaxItem20 ReportingDate
FiscalPeriod P_SlsPurListBPTaxItem20 FiscalPeriod Tax period
DocumentReferenceID P_SlsPurListBPTaxItem20 DocumentReferenceID Reference
AccountingDocumentHeaderText P_SlsPurListBPTaxItem20 AccountingDocumentHeaderText Doc.Header Text
DocumentCurrency P_SlsPurListBPTaxItem20 DocumentCurrency Document Currency
CompanyCodeCurrency P_SlsPurListBPTaxItem20 CompanyCodeCurrency Local Currency
FinancialAccountType P_SlsPurListBPTaxItem20 FinancialAccountType Fin. Account Type
Debtor P_SlsPurListBPTaxItem20 Debtor Debtor
Creditor P_SlsPurListBPTaxItem20 Creditor Supplier
OrganizationBPName1 P_SlsPurListBPTaxItem20 OrganizationBPName1 Name 1
OrganizationBPName2 P_SlsPurListBPTaxItem20 OrganizationBPName2 Name 2
Country P_SlsPurListBPTaxItem20 Country Venue: Ctry/Reg
CityName P_SlsPurListBPTaxItem20 CityName Name
PostalCode P_SlsPurListBPTaxItem20 PostalCode Postal Code
StreetName P_SlsPurListBPTaxItem20 StreetName Text
IsOneTimeAccount P_SlsPurListBPTaxItem20 IsOneTimeAccount One-time acct
VATRegistration P_SlsPurListBPTaxItem20 VATRegistration VAT Registration No.
VATRegistrationFromLineItem P_SlsPurListBPTaxItem20 VATRegistrationFromLineItem VAT Registration No.
TaxNumber1 P_SlsPurListBPTaxItem20 TaxNumber1 VAT Reg. No.
TaxNumber2 P_SlsPurListBPTaxItem20 TaxNumber2 Tax Number 2
TaxNumber3 P_SlsPurListBPTaxItem20 TaxNumber3
TaxNumber4 P_SlsPurListBPTaxItem20 TaxNumber4
TaxNumber5 P_SlsPurListBPTaxItem20 TaxNumber5
taxCalculationProcedure P_SlsPurListBPTaxItem20 taxCalculationProcedure Tax Procedure
CountryCurrency P_SlsPurListBPTaxItem20 CountryCurrency Currency
stgrp P_SlsPurListBPTaxItem20 stgrp Tax Type
stazf P_SlsPurListBPTaxItem20 stazf Not deductible
TaxType I_TaxCode TaxType Tax Type
TargetTaxCode I_TaxCode TargetTaxCode
EUTaxClassification I_TaxCode EUTaxClassification EU Code/Code
EUAcqnInputTaxCode I_TaxCode EUAcqnInputTaxCode TgtTxCd Inp.Tax
EUAcqnOutputTaxCode I_TaxCode EUAcqnOutputTaxCode TgtTxCd OutpTax

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_SlsPurListBPTaxItem.
-- 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: PSPLSTBPTAXITM

CREATE VIEW P_SlsPurListBPTaxItem AS
SELECT
  itm.CompanyCode AS CompanyCode,
  itm.FiscalYear AS FiscalYear,
  itm.AccountingDocument AS AccountingDocument,
  itm.TaxItem AS TaxItem,
  itm.TaxCode AS TaxCode,
  itm.TransactionTypeDetermination AS TransactionTypeDetermination,
  itm.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  itm.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  itm.TaxRate AS TaxRate,
  itm.TaxCountry AS TaxCountry,
  itm.TaxReturnCountry AS TaxReturnCountry,
  itm.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  itm.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  itm.BusinessPlace AS BusinessPlace,
  itm.TaxAmount AS TaxAmount,
  itm.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  itm.CompanyCodeCountry AS CompanyCodeCountry,
  itm.AccountingDocumentType AS AccountingDocumentType,
  itm.DocumentDate AS DocumentDate,
  itm.PostingDate AS PostingDate,
  itm.TaxReportingDate AS TaxReportingDate,
  itm.ReportingDate AS ReportingDate,
  itm.FiscalPeriod AS FiscalPeriod,
  itm.DocumentReferenceID AS DocumentReferenceID,
  itm.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  itm.DocumentCurrency AS DocumentCurrency,
  itm.CompanyCodeCurrency AS CompanyCodeCurrency,
  itm.FinancialAccountType AS FinancialAccountType,
  itm.Debtor AS Debtor,
  itm.Creditor AS Creditor,
  itm.OrganizationBPName1 AS OrganizationBPName1,
  itm.OrganizationBPName2 AS OrganizationBPName2,
  itm.Country AS Country,
  itm.CityName AS CityName,
  itm.PostalCode AS PostalCode,
  itm.StreetName AS StreetName,
  itm.IsOneTimeAccount AS IsOneTimeAccount,
  itm.VATRegistration AS VATRegistration,
  itm.VATRegistrationFromLineItem AS VATRegistrationFromLineItem,
  itm.TaxNumber1 AS TaxNumber1,
  itm.TaxNumber2 AS TaxNumber2,
  itm.TaxNumber3 AS TaxNumber3,
  itm.TaxNumber4 AS TaxNumber4,
  itm.TaxNumber5 AS TaxNumber5,
  itm.taxCalculationProcedure AS taxCalculationProcedure,
  itm.CountryCurrency AS CountryCurrency,
  itm.stgrp AS stgrp,
  itm.stazf AS stazf,
  txc.TaxType AS TaxType,
  txc.TargetTaxCode AS TargetTaxCode,
  txc.EUTaxClassification AS EUTaxClassification,
  txc.EUAcqnInputTaxCode AS EUAcqnInputTaxCode,
  txc.EUAcqnOutputTaxCode AS EUAcqnOutputTaxCode
FROM P_SlsPurListBPTaxItem20 AS itm
LEFT OUTER JOIN I_TaxCode AS txc ON /* join condition not captured in parsed metadata */
;

Learn More