SAP Table VIRAADVPAY - OBSOLETE: Advance Payment

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
OBJNR X RECAOBJNR CHAR 3 22 0 ONR00 Object Number
ADD_OBJNR X RERAADDOBJNR CHAR 25 22 0 ONR00 Object Number for Additional Account Assignment
CONDTYPE X RECDCONDTYPE CHAR 47 4 0 Condition Type
VALIDTO X RECADATETO DATS 51 8 0 Date: Valid To
PARTNER X BU_PARTNER CHAR 59 10 0 Business Partner Number
PARTNEROBJNR X RETMPARTNEROBJNR CHAR 69 22 0 ONR00 Object Number for Internal Use
PROCESSGUID RECAPROCESSGUID RAW 91 16 0 VICAPROCESSID Generic Key of Process
OBJGUID RERAOBJGUID RAW 107 16 0 VICAPROCESSID GUID of Account Assignment Object, Assigned by Process
VALIDFROM RECAPERIODFROM DATS 123 8 0 Period Start Date
CURRENCY WAERS CUKY 131 5 0 TCURC Currency Key
FLOWTYPE RECDFLOWTYPE CHAR 136 4 0 TIVCDFLOWTYPE Flow Type
TAXTYPE RERATAXTYPE CHAR 140 4 0 TIVRATAXTYPE Tax Type
TAXGROUP RERATAXGROUP CHAR 144 20 0 TIVRATAXGROUP Tax Group
TXJCD TXJCD CHAR 164 15 0 TTXJ Tax Jurisdiction
TAXDATE TXDAT DATS 179 8 0 Date for Defining Tax Rates
NET_AMOUNT RERAADVPAYNET CURR 187 15 2 Net Amount of Advanced Payment
TAX_AMOUNT RERAADVPAYTAX CURR 195 15 2 Tax Amount of Advance Payment
NET_AMOUNT_PAY RERAADVPAYNETAMOUNT CURR 203 15 2 Amount of Net Advance Payment Made (for Settlement)
TAX_AMOUNT_PAY RERAADVPAYTAXAMOUNT CURR 211 15 2 Tax Amount of Advance Payment Made (for Settlement)
NET_AMOUNT_EXT RERAADVPAYNETEXT CURR 219 15 2 Legacy Data Transfer: Net Amount of Advanced Payment
TAX_AMOUNT_EXT RERAADVPAYTAXEXT CURR 227 15 2 Legacy Data Transfer: Tax Amount of Advanced Payment
TERMTYPE RETMTERMTYPE CHAR 235 4 0 TIVTMTERMTYPE Term Category
TERMNO RETMTERMNO CHAR 239 4 0 Term Number
CONDGUID RECDCONDGUID RAW 243 16 0 VICAPROCESSID GUID (RAW16) for Conditions
TERMNOPY RECDTERMNOPY CHAR 259 4 0 Number of Posting Term
CDSPLITNO RETMCDSPLITNO NUMC 263 4 0 Number of Condition Split
HASLEGACYDATA RECAHASLEGACYDATA CHAR 267 1 0 Uses Legacy Data
PROCESSMODE RECAPROCESSMODE CHAR 268 1 0 Execution Mode of Process
STATUS RERASEAPSTATUS CHAR 269 1 0 Status of Advance Payment Relevant to SCS
CTRULE RECACTRULE CHAR 270 20 0 TIVCACTRULE Currency Translation Rule
CTRATE RECACTRATE DEC 290 9 5 Exchange Rate
CTFCCURRKEY RECACTFCCURRKEY CUKY 295 5 0 TCURC Foreign Currency
CTFCNETAMOUNT RERAAPCTFCNETAMOUNT CURR 300 15 2 Net Amount of Advance Payment in Foreign Currency
CTFCTAXAMOUNT RERAAPCTFCTAXAMOUNT CURR 308 15 2 Tax Amount of Advance Payment in Foreign Currency
CTFCNETAMOUNTPAY RERAAPCTFCNETAMOUNTPAY CURR 316 15 2 Net Amount of Advance Payment Made in Foreign Currency
CTFCTAXAMOUNTPAY RERAAPCTFCTAXAMOUNTPAY CURR 324 15 2 Tax Amount of Advance Payment Made in Foreign Currency
CTFCNETAMOUNTEXT RERAAPCTFCNETAMOUNTEXT CURR 332 15 2 Legacy Data Transfer: AP Net Amount in Foreign Currency
CTFCTAXAMOUNTEXT RERAAPCTFCTAXAMOUNTEXT CURR 340 15 2 Legacy Data Transfer: AP Tax Amount in Foreign Currency
CTFCPOST RECACTFCPOST CHAR 348 1 0 Post in Foreign Currency

851477VIRAADVPAY table not fully deleted
844713Update in VIRAADVPAY table when final settlement performed