P_SlsPurListBPTaxItem

Sales Purchase List BP Tax Item | view: PSPLSTBPTAXITM | Extraction: Not supported | Component: Localization Financials
Tables used: BKPFBSECBKPFBSEGBSETT001TKA02T005KNA1LFA1T007AT001T014T007B
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Document Number of an Accounting Document
TaxItem Number of Tax Line Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
💲 Reporting Currency (CountryCurrency):
TaxBaseAmountInCountryCrcy null
TaxAmountInCountryCrcy null
💲 Currency Key (DocumentCurrency):
TaxAmount null
TaxBaseAmountInTransCrcy null
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
TaxReportingDate Tax Reporting Date
ReportingDate Reporting Date
Column Name Description
FinancialAccountType Account Type Show values
stgrp Tax type Show values
stazf Indicator: Tax not deductible Show values
TaxType Tax Type Show values
EUTaxClassification EU Code/Code Show values
Column Name Description Domain name
TransactionTypeDetermination Transaction Key CHAR3
TaxRate Tax Rate
TaxCountry Tax Reporting Country/Region LAND1
TaxReturnCountry Country/Region for Tax Report LAND1
BusinessPlace Business Place J_1BBRANCH
FiscalPeriod Fiscal Period POPER
DocumentReferenceID Reference Document Number XBLNR1
AccountingDocumentHeaderText Document Header Text TEXT25
OrganizationBPName1 Name 1 TEXT40
OrganizationBPName2 Name 2 TEXT40
Country Country/Region Key LAND1
CityName City TEXT40
PostalCode Postal Code PSTLZ
StreetName Street and House Number TEXT35
IsOneTimeAccount null
VATRegistration VAT Registration Number STCEG
VATRegistrationFromLineItem VAT Registration Number STCEG
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
TaxNumber3 Tax Number 3 CHAR18
TaxNumber4 Tax Number 4 CHAR18
TaxNumber5 Tax Number 5 CHAR60
taxCalculationProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_SLSPURLISTBPTAXITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_SLSPURLISTBPTAXITEM.MANDT == T003.MANDT
Company Code
  • Client
  • Company Code
  • P_SLSPURLISTBPTAXITEM.MANDT == T001.MANDT
  • P_SLSPURLISTBPTAXITEM.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • P_SLSPURLISTBPTAXITEM.COMPANYCODECOUNTRY == T005.LAND1
  • P_SLSPURLISTBPTAXITEM.MANDT == T005.MANDT
Supplier
  • Supplier
  • Client
  • P_SLSPURLISTBPTAXITEM.CREDITOR == LFA1.LIFNR
  • P_SLSPURLISTBPTAXITEM.MANDT == LFA1.MANDT
Customer
  • Customer
  • Client
  • P_SLSPURLISTBPTAXITEM.DEBTOR == KNA1.KUNNR
  • P_SLSPURLISTBPTAXITEM.MANDT == KNA1.MANDT
Currency Key
  • Client
  • Currency Key
  • P_SLSPURLISTBPTAXITEM.MANDT == TCURC.MANDT
  • P_SLSPURLISTBPTAXITEM.DOCUMENTCURRENCY == TCURC.WAERS
Value Help for Target Tax Code
  • Client
  • ?
  • Target Tax Code for Deferred EU Acquisition Tax, Output Tax
  • P_SLSPURLISTBPTAXITEM.MANDT == T007A.MANDT
  • P_SLSPURLISTBPTAXITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • P_SLSPURLISTBPTAXITEM.EUACQNINPUTTAXCODE == T007A.MWSKZ
Foreign Key Tax Code
  • Target Tax Code for Deferred EU Acquisition Tax, Input Tax
  • Client
  • ?
  • P_SLSPURLISTBPTAXITEM.EUACQNOUTPUTTAXCODE == T007A.MWSKZ
  • P_SLSPURLISTBPTAXITEM.MANDT == T007A.MANDT
  • P_SLSPURLISTBPTAXITEM.[column in domain "KALSM_D"] == T007A.KALSM
Tax Code
  • Client
  • Target Tax Code (for Deferred Tax)
  • ?
  • P_SLSPURLISTBPTAXITEM.MANDT == T007A.MANDT
  • P_SLSPURLISTBPTAXITEM.TARGETTAXCODE == T007A.MWSKZ
  • P_SLSPURLISTBPTAXITEM.[column in domain "KALSM_D"] == T007A.KALSM
Tax on sales/purchases code
  • Tax on sales/purchases code
  • ?
  • Client
  • P_SLSPURLISTBPTAXITEM.TAXCODE == T007A.MWSKZ
  • P_SLSPURLISTBPTAXITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • P_SLSPURLISTBPTAXITEM.MANDT == T007A.MANDT