C_US_TaxPartnerTaxDocItemQuery

Analytical Query for US Tax Items | view: CUSTXPTDITMQUERY | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: BKPFETXDCFETXDCHETXDCIETXDCJETXJCD
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
TaxBaseAmountInTransCrcy Tax Base Amount in Transaction Currency
TaxAmountInTransCrcy Tax Amount in Transaction Currency
TaxExemptionAmount Tax-Exempt Revaluation Amount
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Company Code Currency
TaxAmountInCoCodeCrcy Signed Tax Amount in Company Code Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ServicesRenderedDate Date on which services are rendered
US_TaxPartnerReceivedTaxDate Tax Date as Sent to Partner
TaxCalculationDate The date used for external tax calculation
Column Name Description
UnitedStatesTaxSourcing Tax Sourcing Show values
UnitedStatesTaxCategory Tax Category for US Taxes Show values
Column Name Description Domain name
US_TaxState External Tax State CHAR002
TaxJurisdictionLevel Tax jurisdiction code level CHAR1
TaxJurisdiction Tax Jurisdiction TXJCD
TaxJurisdictionText Tax Jurisdiction Code Description CHAR200
Product Product Number MATNR
MaterialGroup Material Group MATKL
TaxCalculationProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
TaxCode Tax on Sales/Purchases Code MWSKZ
PurchasingDocument Purchasing Document Number EBELN
SDDocument Sales and Distribution Document Number VBELN
CompanyCode Company Code BUKRS
AccountingDocument Journal Entry BELNR
FiscalYear Fiscal Year GJAHR
GLAccount G/L Account SAKNR
US_TaxFreeDefinedValue1 Extension Field 001 TEXT100
US_TaxFreeDefinedValue2 Extension Field 002 TEXT100
US_TaxFreeDefinedValue3 Extension Field 003 TEXT100
US_TaxFreeDefinedValue4 Extension Field 004 TEXT100
US_TaxFreeDefinedValue5 Extension Field 005 TEXT100
US_TaxFreeDefinedValue6 Extension Field 006 TEXT100
US_TaxFreeDefinedValue7 Extension Field 007 TEXT100
US_TaxFreeDefinedValue8 Extension Field 008 TEXT100
US_TaxFreeDefinedValue9 Extension Field 009 TEXT100
US_TaxFreeDefinedValue10 Extension Field 010 TEXT100
US_TaxFreeDefinedValue11 Extension Field 011 TEXT100
US_TaxFreeDefinedValue12 Extension Field 012 TEXT100
US_TaxFreeDefinedValue13 Extension Field 013 TEXT100
US_TaxFreeDefinedValue14 Extension Field 014 TEXT100
US_TaxFreeDefinedValue15 Extension Field 015 TEXT100
US_TaxFreeDefinedValue16 Extension Field 016 TEXT100
US_TaxFreeDefinedValue17 Extension Field 017 TEXT100
US_TaxFreeDefinedValue18 Extension Field 018 TEXT100
US_TaxFreeDefinedValue19 Extension Field 019 TEXT100
US_TaxFreeDefinedValue20 Extension Field 020 TEXT100
US_TaxFreeDefinedValue21 Extension Field 021 TEXT100
US_TaxFreeDefinedValue22 Extension Field 022 TEXT100
US_TaxFreeDefinedValue23 Extension Field 023 TEXT100
US_TaxFreeDefinedValue24 Extension Field 024 TEXT100
US_TaxFreeDefinedValue25 Extension Field 025 TEXT100
US_TaxFreeDefinedValue26 Extension Field 026 TEXT100
US_TaxFreeDefinedValue27 Extension Field 027 TEXT100
US_TaxFreeDefinedValue28 Extension Field 028 TEXT100
US_TaxFreeDefinedValue29 Extension Field 029 TEXT100
US_TaxFreeDefinedValue30 Extension Field 030 TEXT100
US_TaxFreeDefinedValue31 Extension Field 031 TEXT100
US_TaxFreeDefinedValue32 Extension Field 032 TEXT100
US_TaxFreeDefinedValue33 Extension Field 033 TEXT100
US_TaxFreeDefinedValue34 Extension Field 034 TEXT100
US_TaxFreeDefinedValue35 Extension Field 035 TEXT100
US_TaxFreeDefinedValue36 Extension Field 036 TEXT100
US_TaxFreeDefinedValue37 Extension Field 037 TEXT100
US_TaxFreeDefinedValue38 Extension Field 038 TEXT100
US_TaxFreeDefinedValue39 Extension Field 039 TEXT100
US_TaxFreeDefinedValue40 Extension Field 040 TEXT100
US_TaxFreeDefinedValue41 Extension Field 041 TEXT100
US_TaxFreeDefinedValue42 Extension Field 042 TEXT100
US_TaxFreeDefinedValue43 Extension Field 043 TEXT100
US_TaxFreeDefinedValue44 Extension Field 044 TEXT100
US_TaxFreeDefinedValue45 Extension Field 045 TEXT100
US_TaxFreeDefinedValue46 Extension Field 046 TEXT100
US_TaxFreeDefinedValue47 Extension Field 047 TEXT100
US_TaxFreeDefinedValue48 Extension Field 048 TEXT100
US_TaxFreeDefinedValue49 Extension Field 049 TEXT100
US_TaxFreeDefinedValue50 Extension Field 050 TEXT100