1. Home
  2. Resources
  3. SAP Tables
  4. REEX_DOC_ITEM_TAXCUM - RE Line Item with External Tax Code for Tax Summarization

SAP Table REEX_DOC_ITEM_TAXCUM

RE Line Item with External Tax Code for Tax Summarization

REEX_DOC_ITEM_TAXCUM (RE Line Item with External Tax Code for Tax Summarization) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link REEX_DOC_ITEM_TAXCUM to other SAP tables.

Source: REEX_DOC_ITEM_TAXCUM (RE Line Item with External Tax Code for Tax Summarization)

REEX_DOC_ITEM_TAXCUM table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
DOCGUID GUID: Unique Internal Key for RE Document RERADOCGUID VIRADOC RAW 16 0
ITEMNO Accounting Document Line Item Number POSNR_ACC NUMC 10 0
REFITEMNO Reference to Other Item Number of Document RERAREFITEMNO NUMC 10 0
BUKRS Company Code BUKRS CHAR 4 0
ITEMTYPE Item Category RERAITEMTYPE CHAR 2 0
REFDATE Reference Date for Settlement DABRBEZ DATS 8 0
PROCESS Process RECAPROCESS CHAR 4 0
PROCESSGUID Generic Key of Process RECAPROCESSGUID RAW 16 0
CLEARINGSTATUS Clearing status RERACLEARINGSTATUS CHAR 2 0
CLEARNGPROCESSID Process Identification -> Accounting Reference Number RECAPROCESSID CHAR 16 0
PAYEDSTATUS Payment Status RERAPAYEDSTATUS CHAR 2 0
DUNNINGSTATUS Dunning Status RERADUNNINGSTATUS CHAR 2 0
REFGUIDORIGIN Source of GUID RERAGUIDORIGIN CHAR 4 0
REFGUID Reference GUID RERAREFGUID RAW 16 0
OBJNR Account Assignment: Object Number RERAOBJNR CHAR 22 0
PFROM Start of Calculation Period DBERVON DATS 8 0
PTO End of Calculation Period DBERBIS DATS 8 0
BLINEDATE Baseline Date for Due Date Calculation DZFBDT DATS 8 0
ORIGDUEDATE Original Due Date RECDORIGDUEDATE DATS 8 0
CONDTYPE Condition Type RECDCONDTYPE TIVCDCONDTYPE CHAR 4 0
ISADVANCEPAYMENT Condition Is Advance Payment Condition RECDADVANCEPAYMENT CHAR 1 0
X Yes
NULL No
FLOWTYPE Flow Type RECDFLOWTYPE TIVCDFLOWTYPE CHAR 4 0
DCINDICATOR Debit/Credit Indicator RERADCINDICATOR CHAR 1 0
C Credit
D Debit
TAXGROUPID Group Indicator for Tax Line Items RERATAXGROUPID NUMC 3 0
TAXDATE Date of Tax Calculation RERATAXDATE DATS 8 0
TERMNOOA Term Number RETMTERMNO CHAR 4 0
GSBER Business Area GSBER CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
ADDOBJNR Object Number for Additional Account Assignment RERAADDOBJNR CHAR 22 0
FUND Fund RERAFUND CHAR 24 0
FUNDSCENTER Funds Center RERAFUNDSCENTER CHAR 24 0
COMMITMENTITEM Commitment Item RERACOMMITMENTITEM CHAR 24 0
FUNCTIONALAREA Functional Area RERAFUNCTIONALAREA CHAR 24 0
GRANTNUMBER Grant RERAGRANTNUMBER CHAR 24 0
MEASURE Program in Funds Management RERAMEASURE CHAR 24 0
BUDGETPERIOD FM: Budget Period RERABUDGETPERIOD CHAR 24 0
TERMNOPY Term Number RETMTERMNO CHAR 4 0
CDSPLITNO Number of Condition Split RETMCDSPLITNO NUMC 4 0
PYMTMETH Payment Method RERAPYMTMETH CHAR 4 0
PYMTMETHCRMO Payment Method for Credit Memos RERAPYMTMETHCRMO CHAR 4 0
PYMTBLOCK Payment block key RERAPYMTBLOCK CHAR 4 0
PYMTTERM Terms of Payment Key RERAPYMTTERM CHAR 4 0
HOUSEBKID Key for House Bank RERAHOUSEBKID CHAR 15 0
HOUSEBKACC Key for House Bank Account RERAHOUSEBKACC CHAR 15 0
BANKDETAILID Bank Details ID RERABANKDETAILID CHAR 15 0
NOTETOPAYEE Note to Payee RERANOTETOPAYEE CHAR 25 0
DUNNAREA Dunning Area RERADUNNAREA CHAR 4 0
DUNNKEY Dunning Keys RERADUNNKEY CHAR 4 0
DUNNBLOCK Dunning Block RERADUNNBLOCK CHAR 4 0
ACCDETKEY Account Determination Value RERAACCDETKEY CHAR 10 0
TAXTYPE Tax Type RERATAXTYPE TIVRATAXTYPE CHAR 4 0
TAXGROUP Tax Group RERATAXGROUP TIVRATAXGROUP CHAR 20 0
ISGROSS Condition Amount Is Gross Amount RECDISGROSS CHAR 1 0
X Yes
NULL No
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
PARTNEROBJNR Object Number for Internal Use RETMPARTNEROBJNR CHAR 22 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
ISCDSPLIT Condition Split RETMISCDSPLIT CHAR 1 0
X Yes
NULL No
CTRULE Currency Translation Rule RECACTRULE CHAR 20 0
ISPARTNERBLOCKED Lock of Partner Data in Posting Term RERAISPARTNERBLOCKED CHAR 1 0
X Yes
NULL No
SEPAMNDID SEPA Mandate: Unique Reference to Mandate per Vendor RETMSEPAMNDID CHAR 35 0
SEPARECCRDID SEPA Mandate: Creditor ID RETMSEPARECCRDID CHAR 35 0
TERMNOWT Term Number RETMTERMNO CHAR 4 0
ACCTYPE Account Type RERAACCTYPE CHAR 1 0
A Assets
D Customer
K Vendor
M Material
S G/L Accounts
GLACCSYMB Account Determination: Account Symbols RERAGLACCSYMB CHAR 15 0
GLACCOUNT General Ledger Account RERAGLACCOUNT CHAR 10 0
AMOUNT Amount in Transaction Currency RERAAMOUNT CURR 15 2
GROSSAMOUNT Gross Amount in Transaction Currency RERAGROSSAMOUNT CURR 15 2
NETAMOUNT Net Amount in Transaction Currency RERANETAMOUNT CURR 15 2
TAXAMOUNT Tax Amount in Transaction Currency RERATAXAMOUNT CURR 15 2
CURRENCY Currency Key WAERS CUKY 5 0
CTLCAMOUNT Amount in Local Currency RECACTLCAMOUNT CURR 15 2
CTLCGROSSAMOUNT Gross Amount in Local Currency RECACTLCGROSSAMOUNT CURR 15 2
CTLCNETAMOUNT Net Amount in Local Currency RECACTLCNETAMOUNT CURR 15 2
CTLCTAXAMOUNT Tax Amount in Local Currency RECACTLCTAXAMOUNT CURR 15 2
CTLCCURRKEY Local Currency RECACTLCCURRKEY CUKY 5 0
CTFCAMOUNT Amount in Foreign Currency RECACTFCAMOUNT CURR 15 2
CTFCGROSSAMOUNT Gross Amount in Foreign Currency RECACTFCGROSSAMOUNT CURR 15 2
CTFCNETAMOUNT Net Amount in Foreign Currency RECACTFCNETAMOUNT CURR 15 2
CTFCTAXAMOUNT Tax Amount in Foreign Currency RECACTFCTAXAMOUNT CURR 15 2
CTFCCURRKEY Foreign Currency RECACTFCCURRKEY CUKY 5 0
TAXRATE Tax Rate RERATAXRATE DEC 7 3
EXTTAXCODE Tax Code of the Accounting System RERATAXCODE CHAR 5 0
EXTREF1 External Reference 1 (Line Item) RERAEXTREF1 CHAR 60 0
EXTREF2 External Reference 2 (Line Item) RERAEXTREF2 CHAR 60 0
EXTREF3 External Reference 3 (Line Item) RERAEXTREF3 CHAR 60 0
EXTREF4 External Reference 4 (Line Item) RERAEXTREF4 CHAR 60 0
ITEMTXT Item Text SGTXT CHAR 50 0
VENDOR Vendor number RERAVENDORNO CHAR 10 0
CUSTOMER Customer Number RERACUSTOMERNO CHAR 10 0
VALUEDATE Value Date RERAVALUEDATE DATS 8 0
ALLOCATIONNUMBER Assignment Number RERAALLOCATIONNUMBER CHAR 18 0
REIPREFGUID Reference GUID RERAREFGUID RAW 16 0
ISFLATRATE Condition Is a Flat Rate Condition RECDFLATRATE CHAR 1 0
X Yes
NULL No
HASMANUALTAX Manual Entry of Tax? RERAHASMANUALTAX CHAR 1 0
X Yes
NULL No
TXJCD_DEEP Tax Jurisdiction TXJCD CHAR 15 0
TXJLV Tax jurisdiction code level TXJCD_LEVEL CHAR 1 0
CTRATE Exchange Rate RECACTRATE DEC 9 5
CTDATEREQ Planned Translation Date RECACTDATEREQ DATS 8 0
CTDATEACT Actual Translation Date RECACTDATEACT DATS 8 0
POSTCDCURR Post in Condition Currency RECACTPOSTCDCURR CHAR 1 0
X Yes
NULL No
QUANTITY Quantity MENGE_D QUAN 13 3
BASE_UOM Base Unit of Measure MEINS UNIT 3 0
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
COSTCENTER Cost Center KOSTL CHAR 10 0
ORDERID Order Number AUFNR CHAR 12 0
AMTRANSTYPE Transaction Type of Asset Postings REITAMTRANSTYPE CHAR 3 0
PARTNER_PRCTR Partner Profit Center RERAPARTNERPRCTR CHAR 10 0
PAROBJNR Partner Object RERAPARTNEROBJNR CHAR 22 0
CONDGUID GUID (RAW16) for Conditions RECDCONDGUID RAW 16 0
OBJNRCALC Object Number RECAOBJNR CHAR 22 0
FMDOCNO Document Number for Earmarked Funds KBLNR CHAR 10 0
FMDOCITEMNO Earmarked Funds: Document Item KBLPOS NUMC 3 0
FMDOCREVID Indicator for Reversed Documents RERAREVID CHAR 1 0
1 Reversed Document
2 Reversal Document
X Document has been reversed
GENDATA CHAR 60 0
MARKEDFORCLEARING Line Item Marked for Clearing RERAMARKEDFORCLEARING CHAR 1 0
X Yes
NULL No
ZEROTAX Dummy Zero Tax Item RERAZEROTAX CHAR 1 0
X Yes
NULL No
TCOBJNR Object Number RECAOBJNR CHAR 22 0
DATEOFSERVICE Date of Service REITTCDATEOFSERVICE DATS 8 0
HASDIFFOPTRATE Has Differing Option Rate REITHASDIFFOPTRATE CHAR 1 0
X Yes
NULL No
DIFFOPTRATE Differing Option Rate for Distribution REITDIFFOPTRATE DEC 9 6
NOTAXCORR Do Not Consider Item in Input Tax Correction REITNOTAXCORR CHAR 1 0
X Yes
NULL No
TAXCODE Tax on sales/purchases code MWSKZ CHAR 2 0
TAXCATEGORY Tax Category in Account Master Record SMWSK CHAR 2 0

REEX_DOC_ITEM_TAXCUM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
REEX_DOC_ITEM_TAXCUM CONDTYPE SYST MANDT TIVCDCONDTYPE Condition Type MANDT
REEX_DOC_ITEM_TAXCUM CONDTYPE REEX_DOC_ITEM_TAXCUM CONDTYPE TIVCDCONDTYPE Condition Type CONDTYPE
REEX_DOC_ITEM_TAXCUM DOCGUID SYST MANDT VIRADOC RE Document Header MANDT
REEX_DOC_ITEM_TAXCUM DOCGUID REEX_DOC_ITEM_TAXCUM DOCGUID VIRADOC RE Document Header .INCLUDE
REEX_DOC_ITEM_TAXCUM FLOWTYPE SYST MANDT TIVCDFLOWTYPE Flow Type MANDT
REEX_DOC_ITEM_TAXCUM FLOWTYPE REEX_DOC_ITEM_TAXCUM FLOWTYPE TIVCDFLOWTYPE Flow Type FLOWTYPE
REEX_DOC_ITEM_TAXCUM TAXGROUP SYST MANDT TIVRATAXGROUP Tax Group MANDT
REEX_DOC_ITEM_TAXCUM TAXGROUP REEX_DOC_ITEM_TAXCUM TAXGROUP TIVRATAXGROUP Tax Group TAXGROUP
REEX_DOC_ITEM_TAXCUM TAXTYPE SYST MANDT TIVRATAXTYPE Tax Types MANDT
REEX_DOC_ITEM_TAXCUM TAXTYPE * TIVRATAXTYPE Tax Types COUNTRY
REEX_DOC_ITEM_TAXCUM TAXTYPE REEX_DOC_ITEM_TAXCUM TAXTYPE TIVRATAXTYPE Tax Types TAXTYPE