P_TaxRecon05

join the bseg with agrregated value to find the ratio | view: PTAXRECON05 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: BSEGBSETBSEGBSETT001T007BT001
Column Name Description
Column Name Description
dmbtr Amount in local currency
dmbtr_sum null
txbhw Original Tax Base Amount in Local Currency
txbhw_sum null
hwbas null
hwbas_sum null
hwste null
kbetr Tax Rate
posted null
calculated null
Column Name Description
Column Name Description
txdat_from Valid-From Date of the Tax Rate
h_budat Posting Date in the Document
h_bldat Document Date in Document
Column Name Description
stazf Indicator: Tax not deductible Show values
stbkz Posting indicator Show values
xmwsn Indicator: Base amount for tax is net of discount ? Show values
xskfn Indicator: Discount base amount is the net value Show values
Column Name Description Domain name
belnr Document Number of an Accounting Document BELNR
tax_country Tax Reporting Country/Region LAND1
gjahr Fiscal Year GJAHR
buzei Number of Line Item Within Accounting Document BUZEI
kbetr_calc null
lokkt Alternative Account Number in Company Code SAKNR
altkt Group Account Number SAKNR
prctr Profit Center PRCTR
mwart null
zbd1p null
h_monat Fiscal period MONAT
ktosl null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_TAXRECON05.BUKRS == T001.BUKRS
  • P_TAXRECON05.MANDT == T001.MANDT
General Ledger Account
  • Company Code
  • Client
  • General Ledger Account
  • P_TAXRECON05.BUKRS == SKB1.BUKRS
  • P_TAXRECON05.MANDT == SKB1.MANDT
  • P_TAXRECON05.HKONT == SKB1.SAKNR
Document Type
  • Document Type
  • Client
  • P_TAXRECON05.H_BLART == T003.BLART
  • P_TAXRECON05.MANDT == T003.MANDT
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • P_TAXRECON05.[column in domain "KALSM_D"] == T007A.KALSM
  • P_TAXRECON05.MANDT == T007A.MANDT
  • P_TAXRECON05.MWSKZ == T007A.MWSKZ