P_TaxRecon07

retrieve data from bseg | view: PTAXRECON07 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: BSEGBSEGT001T001
Column Name Description
bukrs FK Company Code
belnr Document Number of an Accounting Document
mwskz FK Tax on sales/purchases code
tax_country Tax Reporting Country/Region
txdat_from Valid-From Date of the Tax Rate
gjahr Fiscal Year
Column Name Description
dmbtr Amount in local currency
txbhw Original Tax Base Amount in Local Currency
hwbas Tax Base Amount in Local Currency
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
xauto Indicator: Line item automatically created 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
txgrp null
buzei Number of Line Item Within Accounting Document BUZEI
h_monat Fiscal period MONAT
altkt Group Account Number SAKNR
lokkt Alternative Account Number in Company Code SAKNR
mwart null
prctr Profit Center PRCTR
zbd1p Cash discount percentage 1 PRZ23
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_TAXRECON07.MANDT == T001.MANDT
  • P_TAXRECON07.BUKRS == T001.BUKRS
General Ledger Account
  • General Ledger Account
  • Client
  • Company Code
  • P_TAXRECON07.HKONT == SKB1.SAKNR
  • P_TAXRECON07.MANDT == SKB1.MANDT
  • P_TAXRECON07.BUKRS == SKB1.BUKRS
Document Type
  • Client
  • Document Type
  • P_TAXRECON07.MANDT == T003.MANDT
  • P_TAXRECON07.H_BLART == T003.BLART
Country/Region Key
  • Client
  • Country/Region Key
  • P_TAXRECON07.MANDT == T005.MANDT
  • P_TAXRECON07.LAND1 == T005.LAND1
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • P_TAXRECON07.[column in domain "KALSM_D"] == T007A.KALSM
  • P_TAXRECON07.MANDT == T007A.MANDT
  • P_TAXRECON07.MWSKZ == T007A.MWSKZ
Special G/L Indicator
  • Client
  • Special G/L Indicator
  • ?
  • P_TAXRECON07.MANDT == T074U.MANDT
  • P_TAXRECON07.UMSKZ == T074U.UMSKZ
  • P_TAXRECON07.[column in domain "KOART"] == T074U.KOART