SAP table REEX_DOC_ITEM_TAXCUM (RE Line Item with External Tax Code for Tax Summarization)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
DOCGUID GUID: Unique Internal Key for RE Document RAW 16 0 VIRADOC RERADOCGUID
ITEMNO Accounting Document Line Item Number NUMC 10 0 POSNR_ACC
REFITEMNO Reference to Other Item Number of Document NUMC 10 0 RERAREFITEMNO
BUKRS Company Code CHAR 4 0 BUKRS
ITEMTYPE Item Category CHAR 2 0 RERAITEMTYPE
REFDATE Reference date for settlement DATS 8 0 DABRBEZ
PROCESS Process CHAR 4 0 * RECAPROCESS
PROCESSGUID Generic Key of Process RAW 16 0 RECAPROCESSGUID
CLEARINGSTATUS Clearing status CHAR 2 0 RERACLEARINGSTATUS
CLEARNGPROCESSID Process Identification -> Accounting Reference Number CHAR 16 0 RECAPROCESSID
PAYEDSTATUS Payment Status CHAR 2 0 RERAPAYEDSTATUS
DUNNINGSTATUS Dunning Status CHAR 2 0 RERADUNNINGSTATUS
REFGUIDORIGIN Source of GUID CHAR 4 0 RERAGUIDORIGIN
REFGUID Reference GUID RAW 16 0 RERAREFGUID
OBJNR Account Assignment: Object Number CHAR 22 0 * RERAOBJNR
PFROM Start of Calculation Period DATS 8 0 DBERVON
PTO End of Calculation Period DATS 8 0 DBERBIS
BLINEDATE Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
ORIGDUEDATE Original Due Date DATS 8 0 RECDORIGDUEDATE
CONDTYPE Condition Type CHAR 4 0 TIVCDCONDTYPE RECDCONDTYPE
ISADVANCEPAYMENT Condition Is Advance Payment Condition CHAR 1 0 RECDADVANCEPAYMENT
FLOWTYPE Flow Type CHAR 4 0 TIVCDFLOWTYPE RECDFLOWTYPE
DCINDICATOR Debit/Credit Indicator CHAR 1 0 RERADCINDICATOR
C Credit
D Debit
TAXGROUPID Group Indicator for Tax Line Items NUMC 3 0 RERATAXGROUPID
TAXDATE Date of Tax Calculation DATS 8 0 RERATAXDATE
TERMNOOA Term Number CHAR 4 0 RETMTERMNO
GSBER Business Area CHAR 4 0 * GSBER
PRCTR Profit Center CHAR 10 0 PRCTR
ADDOBJNR Object Number for Additional Account Assignment CHAR 22 0 * RERAADDOBJNR
FUND Fund CHAR 24 0 RERAFUND
FUNDSCENTER Funds Center CHAR 24 0 RERAFUNDSCENTER
COMMITMENTITEM Commitment Item CHAR 24 0 * RERACOMMITMENTITEM
FUNCTIONALAREA Functional Area CHAR 24 0 RERAFUNCTIONALAREA
GRANTNUMBER Grant CHAR 24 0 RERAGRANTNUMBER
MEASURE Program in Funds Management CHAR 24 0 RERAMEASURE
BUDGETPERIOD FM: Budget Period CHAR 24 0 RERABUDGETPERIOD
TERMNOPY Term Number CHAR 4 0 RETMTERMNO
CDSPLITNO Number of Condition Split NUMC 4 0 RETMCDSPLITNO
PYMTMETH Payment Method CHAR 4 0 RERAPYMTMETH
PYMTMETHCRMO Payment Method for Credit Memos CHAR 4 0 RERAPYMTMETHCRMO
PYMTBLOCK Payment block key CHAR 4 0 RERAPYMTBLOCK
PYMTTERM Terms of Payment Key CHAR 4 0 RERAPYMTTERM
HOUSEBKID Key for House Bank CHAR 15 0 RERAHOUSEBKID
HOUSEBKACC Key for House Bank Account CHAR 15 0 RERAHOUSEBKACC
BANKDETAILID Bank Details ID CHAR 15 0 RERABANKDETAILID
NOTETOPAYEE Note to Payee CHAR 25 0 RERANOTETOPAYEE
DUNNAREA Dunning Area CHAR 4 0 RERADUNNAREA
DUNNKEY Dunning Keys CHAR 4 0 RERADUNNKEY
DUNNBLOCK Dunning Block CHAR 4 0 RERADUNNBLOCK
ACCDETKEY Account Determination Value CHAR 10 0 * RERAACCDETKEY
TAXTYPE Tax Type CHAR 4 0 TIVRATAXTYPE RERATAXTYPE
TAXGROUP Tax Group CHAR 20 0 TIVRATAXGROUP RERATAXGROUP
ISGROSS Condition Amount Is Gross Amount CHAR 1 0 RECDISGROSS
TAXCOUNTRY Alternative Tax Reporting Country/Region CHAR 3 0 * RERATAXCOUNTRY
PARTNER Business Partner Number CHAR 10 0 BU_PARTNER
PARTNEROBJNR Object Number for Internal Use CHAR 22 0 * RETMPARTNEROBJNR
TXJCD Tax Jurisdiction CHAR 15 0 * TXJCD
ISCDSPLIT Condition Split CHAR 1 0 RETMISCDSPLIT
CTRULE Currency Translation Rule CHAR 20 0 * RECACTRULE
ISPARTNERBLOCKED Lock of Partner Data in Posting Term CHAR 1 0 RERAISPARTNERBLOCKED
SEPAMNDID SEPA Mandate: Unique Reference to Mandate per Vendor CHAR 35 0 RETMSEPAMNDID
SEPARECCRDID SEPA Mandate: Creditor ID CHAR 35 0 RETMSEPARECCRDID
TERMNOWT Term Number CHAR 4 0 RETMTERMNO
ACCTYPE Account Type CHAR 1 0 RERAACCTYPE
A Assets
D Customer
K Vendor
M Material
S G/L Accounts
GLACCSYMB Account Determination: Account Symbols CHAR 15 0 * RERAGLACCSYMB
GLACCOUNT General Ledger Account CHAR 10 0 RERAGLACCOUNT
AMOUNT Amount in Transaction Currency CURR 15 2 RERAAMOUNT
GROSSAMOUNT Gross Amount in Transaction Currency CURR 15 2 RERAGROSSAMOUNT
NETAMOUNT Net Amount in Transaction Currency CURR 15 2 RERANETAMOUNT
TAXAMOUNT Tax Amount in Transaction Currency CURR 15 2 RERATAXAMOUNT
CURRENCY Currency Key CUKY 5 0 * WAERS
CTLCAMOUNT Amount in Local Currency CURR 15 2 RECACTLCAMOUNT
CTLCGROSSAMOUNT Gross Amount in Local Currency CURR 15 2 RECACTLCGROSSAMOUNT
CTLCNETAMOUNT Net Amount in Local Currency CURR 15 2 RECACTLCNETAMOUNT
CTLCTAXAMOUNT Tax Amount in Local Currency CURR 15 2 RECACTLCTAXAMOUNT
CTLCCURRKEY Local Currency CUKY 5 0 * RECACTLCCURRKEY
CTFCAMOUNT Amount in Foreign Currency CURR 15 2 RECACTFCAMOUNT
CTFCGROSSAMOUNT Gross Amount in Foreign Currency CURR 15 2 RECACTFCGROSSAMOUNT
CTFCNETAMOUNT Net Amount in Foreign Currency CURR 15 2 RECACTFCNETAMOUNT
CTFCTAXAMOUNT Tax Amount in Foreign Currency CURR 15 2 RECACTFCTAXAMOUNT
CTFCCURRKEY Foreign Currency CUKY 5 0 * RECACTFCCURRKEY
TAXRATE Tax Rate DEC 7 3 RERATAXRATE
EXTTAXCODE Tax Code of the Accounting System CHAR 5 0 RERATAXCODE
EXTREF1 External Reference 1 (Line Item) CHAR 60 0 RERAEXTREF1
EXTREF2 External Reference 2 (Line Item) CHAR 60 0 RERAEXTREF2
EXTREF3 External Reference 3 (Line Item) CHAR 60 0 RERAEXTREF3
EXTREF4 External Reference 4 (Line Item) CHAR 60 0 RERAEXTREF4
ASSETOBJNR Object Number - Asset CHAR 22 0 * RECEASOBJNR
ASSETVALUEDATE Reference date DATS 8 0 BF_BZDAT
ASSETPROCEDURE Asset Process CHAR 1 0 RECEASPROCEDURE
A Acquisition
B Credit Memo in Acquisition Year
C Credit Memo in Following Year
D Depreciation (on CY Acq.)
E Depreciation (on Prior-Year Acquisitions)
N Retirement (From Current-Year Acquisitions)
P Reactivation
R Retirement (From Prior-Year Acquisitions)
W Appreciation
ISCOMPLETERETIREMENT Complete Retirement? CHAR 1 0 RECEISCOMPLETERETIREMENT
REDUCTION_PERCENTAGE Asset Retirement: Percentage Rate DEC 5 2 PROZS
ITEMTXT Item Text CHAR 50 0 SGTXT
VENDOR Vendor number CHAR 10 0 RERAVENDORNO
CUSTOMER Customer Number CHAR 10 0 RERACUSTOMERNO
VALUEDATE Value Date DATS 8 0 RERAVALUEDATE
ALLOCATIONNUMBER Assignment Number CHAR 18 0 RERAALLOCATIONNUMBER
REIPREFGUID Reference GUID RAW 16 0 RERAREFGUID
ISFLATRATE Condition Is a Flat Rate Condition CHAR 1 0 RECDFLATRATE
HASMANUALTAX Manual Entry of Tax? CHAR 1 0 RERAHASMANUALTAX
TXJCD_DEEP Tax Jurisdiction CHAR 15 0 * TXJCD
TXJLV Tax jurisdiction code level CHAR 1 0 TXJCD_LEVEL
CTRATE Exchange Rate DEC 9 5 RECACTRATE
CTDATEREQ Planned Translation Date DATS 8 0 RECACTDATEREQ
CTDATEACT Actual Translation Date DATS 8 0 RECACTDATEACT
POSTCDCURR Post in Condition Currency CHAR 1 0 RECACTPOSTCDCURR
QUANTITY Quantity QUAN 13 3 MENGE_D
BASE_UOM Base Unit of Measure UNIT 3 0 * MEINS
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
COSTCENTER Cost Center CHAR 10 0 * KOSTL
ORDERID Order Number CHAR 12 0 * AUFNR
AMTRANSTYPE Transaction Type of Asset Postings CHAR 3 0 * REITAMTRANSTYPE
PARTNER_PRCTR Partner Profit Center CHAR 10 0 * RERAPARTNERPRCTR
PAROBJNR Partner Object CHAR 22 0 * RERAPARTNEROBJNR
CONDGUID GUID (RAW16) for Conditions RAW 16 0 RECDCONDGUID
OBJNRCALC Object Number CHAR 22 0 * RECAOBJNR
FMDOCNO Document Number for Earmarked Funds CHAR 10 0 * KBLNR
FMDOCITEMNO Earmarked Funds: Document Item NUMC 3 0 * KBLPOS
FMDOCREVID Indicator for Reversed Documents CHAR 1 0 RERAREVID
1 Reversed Document
2 Reversal Document
X Document has been reversed
GENDATA CHAR 60 0
MARKEDFORCLEARING Line Item Marked for Clearing CHAR 1 0 RERAMARKEDFORCLEARING
ZEROTAX Dummy Zero Tax Item CHAR 1 0 RERAZEROTAX
TCOBJNR Object Number Correction Object CHAR 22 0 * REITTCOBJNR
DATEOFSERVICE Date of Service DATS 8 0 REITTCDATEOFSERVICE
HASDIFFOPTRATE Has Differing Option Rate CHAR 1 0 REITHASDIFFOPTRATE
DIFFOPTRATE Differing Option Rate for Distribution DEC 9 6 REITDIFFOPTRATE
NOTAXCORR Do Not Consider Item in Input Tax Correction CHAR 1 0 REITNOTAXCORR
OIACCOUNTTYPE Account Type CHAR 1 0 RERAOIACCOUNTTYPE
1 Customer
2 Vendor
3 Contract A/R + A/P
OIACCOUNT Open Item Account CHAR 20 0 RERAOIACCOUNT
REVERSAL_FOR GUID (RAW16) for 'Reversal for' References RAW 16 0 RECDREVERSALFORGUID
REVERSAL_BY GUID (RAW16) for 'Reversed by' References RAW 16 0 RECDREVERSALBYGUID
FOLLOWUP_FOR GUID (RAW16) for 'Follow-Up Posting for' References RAW 16 0 RECDFOLLOWUPFORGUID
WHEREFROM Flow Origin CHAR 1 0 RECDWHEREFROM
A Entered by Process - Accruals/Deferrals
E Entered by Process - Reservation/Continuous Occupancy
F Entered by RE - Generating Program (Follow-Up Postings)
G Entered by TR - Generating Program (Financial Mathematics)
O Entered by TR - Generating Program (One-Time Conditions)
P Entered by Process - One-Time Postings
R Entered by RE - Generator (Differences)
S Entered by RE - Generator (Split)
U Entered by Process - Sales-Based Settlement
CF_RERF Entered By CHAR 12 0 RERF
CF_DERF First Entered On DATS 8 0 DERF
CF_TERF Time of Creation TIMS 6 0 TERF
CF_REHER Source of Initial Entry CHAR 10 0 REHER
CF_RBEAR Employee ID CHAR 12 0 RBEAR
CF_DBEAR Last Edited On DATS 8 0 DBEAR
CF_TBEAR Last Edited At TIMS 6 0 TBEAR
CF_RBHER Editing Source CHAR 10 0 RBHER
AMMRHY Frequency in months NUMC 3 0 AMMRHY
ATTRHY Frequency in Days NUMC 3 0 ATTRHY
REFFLOWREL Type of Relationship Between Flow Type and Refer.Flow Type CHAR 3 0 * RECDREFFLOWREL
CONTRACTREF Contract Reference CHAR 20 0 RERACONTRACTREF
CFTYPE Cash Flow Type CHAR 1 0 RECECFTYPE
1 Assets
2 Depreciation
3 Interest
4 Repayment
5 Linearization
6 Transfer Posting
7 Clearing
TAXFROMDATE Valid-From Date of Tax Rate DATS 8 0 RERATAXCALCFROMDATE
ISREDUCTION General Yes/No Field CHAR 1 0 RECABOOL
No
X Yes
ISUSEDBYEVAL General Yes/No Field CHAR 1 0 RECABOOL
No
X Yes
VALOBJTYPE Type of the Financial Valuation Object CHAR 4 0 * VAL_OBJ_TYPE
CNOBJNREVAL Object Number CHAR 22 0 * RECAOBJNR
TERMNOEVAL Term Number CHAR 4 0 RETMTERMNO
TRADEID Company ID CHAR 6 0 * VBUND
TAXBYITEM General Yes/No Field CHAR 1 0 RECABOOL
No
X Yes
TAXCODE Tax on sales/purchases code CHAR 2 0 MWSKZ
TAXCATEGORY Tax Category in Account Master Record CHAR 2 0 SMWSK
TXJCD_DATE Date of Tax Calculation DATS 8 0 RERATAXDATE

REEX_DOC_ITEM_TAXCUM foreign key relationships

Table Field Check Table Check Field
0 REEX_DOC_ITEM_TAXCUM CONDTYPE TIVCDCONDTYPE Condition Type MANDT
0 REEX_DOC_ITEM_TAXCUM CONDTYPE TIVCDCONDTYPE Condition Type CONDTYPE
1 REEX_DOC_ITEM_TAXCUM DOCGUID VIRADOC RE Document Header MANDT
1 REEX_DOC_ITEM_TAXCUM DOCGUID VIRADOC RE Document Header .INCLUDE
0 REEX_DOC_ITEM_TAXCUM FLOWTYPE TIVCDFLOWTYPE Flow Type MANDT
1 REEX_DOC_ITEM_TAXCUM TAXGROUP TIVRATAXGROUP Tax Group TAXGROUP
0 REEX_DOC_ITEM_TAXCUM TAXTYPE TIVRATAXTYPE Tax Types COUNTRY
0 REEX_DOC_ITEM_TAXCUM TAXTYPE TIVRATAXTYPE Tax Types TAXTYPE