P_AUDIT_AT_BSEG

Austrian Audit Journal Segment | view: PAUDITATBSEG | TRAN | Extraction: Not supported | Component: Financials Austria
Tables used: BSEGKNA1KNB1LFA1LFB1
Column Name Description
bukrs FK Company Code
belnr Document Number of an Accounting Document
gjahr Fiscal Year
buzei Number of Line Item Within Accounting Document
Column Name Description
💲 Local Currency (waers):
dmbtr Amount in local currency
💲 Currency Key (twaer):
wrbtr Amount in document currency
mwsts Tax Amount in Local Currency
hwbas Tax Base Amount in Local Currency
Column Name Description
Column Name Description
augdt Clearing Date
Column Name Description
koart Account type Show values
shkzg Debit/Credit Indicator Show values
mwart Tax Type Show values
xbilk Indicator: Account is a balance sheet account? Show values
Column Name Description Domain name
augbl Document Number of the Clearing Document BELNR
ltext Item Text TEXT50
kostl Cost Center KOSTL
kstrg Cost Object KSTRG
posn2 Sales Document Item POSNR
projk Work Breakdown Structure Element (WBS Element) PS_POSNR
gvtyp P&L statement account type CHAR2
Master Data Relations Join Conditions
Order Number
  • Order Number
  • Client
  • P_AUDIT_AT_BSEG.AUFNR == AUFK.AUFNR
  • P_AUDIT_AT_BSEG.MANDT == AUFK.MANDT
Posting Key
  • Client
  • Posting Key
  • P_AUDIT_AT_BSEG.MANDT == TBSL.MANDT
  • P_AUDIT_AT_BSEG.BSCHL == TBSL.BSCHL
Company Code
  • Client
  • Company Code
  • P_AUDIT_AT_BSEG.MANDT == T001.MANDT
  • P_AUDIT_AT_BSEG.BUKRS == T001.BUKRS
Business Area
  • Client
  • Business Area
  • P_AUDIT_AT_BSEG.MANDT == TGSB.MANDT
  • P_AUDIT_AT_BSEG.GSBER == TGSB.GSBER
General Ledger Account
  • Client
  • Company Code
  • General Ledger Account
  • P_AUDIT_AT_BSEG.MANDT == SKB1.MANDT
  • P_AUDIT_AT_BSEG.BUKRS == SKB1.BUKRS
  • P_AUDIT_AT_BSEG.HKONT == SKB1.SAKNR
Customer Number
  • Client
  • Customer Number
  • P_AUDIT_AT_BSEG.MANDT == KNA1.MANDT
  • P_AUDIT_AT_BSEG.KUNNR == KNA1.KUNNR
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_AUDIT_AT_BSEG.LIFNR == LFA1.LIFNR
  • P_AUDIT_AT_BSEG.MANDT == LFA1.MANDT
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • P_AUDIT_AT_BSEG.MANDT == T007A.MANDT
  • P_AUDIT_AT_BSEG.MWSKZ == T007A.MWSKZ
  • P_AUDIT_AT_BSEG.[column in domain "KALSM_D"] == T007A.KALSM
G/L Account Number
  • Client
  • G/L Account Number
  • Company Code
  • P_AUDIT_AT_BSEG.MANDT == SKB1.MANDT
  • P_AUDIT_AT_BSEG.SAKNR == SKB1.SAKNR
  • P_AUDIT_AT_BSEG.BUKRS == SKB1.BUKRS
Currency Key
  • Currency Key
  • Client
  • P_AUDIT_AT_BSEG.TWAER == TCURC.WAERS
  • P_AUDIT_AT_BSEG.MANDT == TCURC.MANDT