SAP table RFPOS (Line Item data for Customer/Vendor/G/L Account)

Field Description Data Type Length Decimals Checktable Data Element
ACTIV List Level in Which the Line Item Is Active NUMC 2 0 ACTIV
ANLN1 Main Asset Number CHAR 12 0 ANLN1
ANLN2 New asset subnumber, 4 characters CHAR 4 0 ANLN2_4
AUFNR Order Number CHAR 12 0 AUFNR
AUGBL Document Number of the Clearing Document CHAR 10 0 AUGBL
AUGDT Clearing Date DATS 8 0 AUGDT
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
BLART Document Type CHAR 2 0 T003 BLART
BLDAT Document Date in Document DATS 8 0 BLDAT
BSCHL Posting Key CHAR 2 0 TBSL BSCHL
BSTAT Document Status CHAR 1 0 BSTAT_D
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BUKRS Company Code CHAR 4 0 T001 BUKRS
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
BWWRT Amount Valuated in Local Currency CURR 23 2 BWWRT
BWWR2 Amount Valuated in Local Currency 2 CURR 23 2 BWWR2
BWWR3 Amount Valuated in Local Currency 3 CURR 23 2 BWWR3
DMSHB Amount in Local Currency with +/- Signs CURR 23 2 DMSHB
HWAER Local Currency CUKY 5 0 TCURC HWAER
DMBE2 Amount in Second Local Currency with +/- Sign CURR 23 2 DMBE2_VZ
HWAE2 Currency Key of Second Local Currency CUKY 5 0 HWAE2
DMBE3 Amount in Third Local Currency with +/- Sign CURR 23 2 DMBE3_VZ
HWAE3 Currency Key of Third Local Currency CUKY 5 0 HWAE3
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
ETEN2 Schedule Line Number NUMC 4 0 ETENR
FAEDT Net Due Date DATS 8 0 FAEDT_FPOS
FILKD Account Number of the Branch CHAR 10 0 FILKD
GJAHR Fiscal Year NUMC 4 0 GJAHR
GSBER Business Area CHAR 4 0 TGSB GSBER
JAMON Fiscal Year/Posting Period from Posting Date CHAR 7 0 JAMON_XPO
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
KONTO Account Number CHAR 10 0 KTONR_AV
KOSTL Cost Center CHAR 10 0 KOSTL
MABER Dunning Area CHAR 2 0 MABER
MADAT Date of Last Dunning Notice DATS 8 0 MADAT
MANSP Dunning Block CHAR 1 0 T040S MANSP
MANST Dunning Level NUMC 1 0 MAHNS_D
MONAT Fiscal period NUMC 2 0 MONAT
MSCHL Dunning Key CHAR 1 0 T040 MSCHL
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
POSN2 Sales Document Item NUMC 6 0 POSNR_VA
PRCTR Profit Center CHAR 10 0 PRCTR
QBSHB Withholding Tax Amount (in Doc. Currency) with +/- Sign CURR 23 2 QBSHB_VZ
QSFBT Withholding Tax-Exempt Amount (in Doc. Crcy) with +/- Sign CURR 23 2 QSFBT_VZ
QSSHB Withholding Tax Base Amount with +/- Sign CURR 23 2 QSSHB_VZ
REBZG Document No. of the Invoice to Which the Transaction Belongs CHAR 10 0 REBZG
SAMNR Invoice List Number NUMC 8 0 SAMNR
SGTXT Item Text CHAR 50 0 SGTXT
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
SKFBT Amount Subject to Discount in Document Curr. with +/- Sign CURR 23 2 SKFBT_VZ
SKNTO Cash Discount Amount (+/-) in Local Currency CURR 23 2 SKNTO_VZ
STAKZ Indicator: Statistical Document? CHAR 1 0 XSTKZ
UMSKS Special G/L Transaction Type CHAR 1 0 UMSKS
UMSKZ Special G/L Indicator CHAR 1 0 UMSKZ
UZAWE Payment method supplement CHAR 2 0 UZAWE
VALUT Value date DATS 8 0 VALUT
VBEL2 Sales Document CHAR 10 0 VBELN_VA
VBELN Billing Document CHAR 10 0 VBELN_VF
VBEWA Flow Type CHAR 4 0 SBEWART
VBUND Company ID of Trading Partner CHAR 6 0 RASSC
VERTN Contract Number CHAR 13 0 RANL
VERTT Contract Type CHAR 1 0 RANTYP
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
VERZ1 Days in Arrears for Cash Discount Terms 1 DEC 5 0 VERZ1
VERZN Days in Arrears by Net Due Date DEC 5 0 VERZN
WERKS Plant CHAR 4 0 WERKS_D
WRSHB Foreign Currency Amount with Signs (+/-) CURR 23 2 WRSHB
WAERS Currency Key CUKY 5 0 TCURC WAERS
WSKTO Cash Discount Amount in Document Currency with +/- Sign CURR 23 2 WSKTO_VZ
WVERW Bill of Exchange Usage Type CHAR 1 0 WVERW
D Discounting
F Forfeiting
I Collection
XBLNR Reference Document Number CHAR 16 0 XBLNR1
XSTRP Indicator: Disputed Item? CHAR 1 0 XSTRP
XZAHL Indicator: Is Posting Key Used in a Payment Transaction? CHAR 1 0 XZAHL
ZALDT Probable Payment Date (Cash Discount 1 Due) DATS 8 0 DZALDT
ZBD1P Cash discount percentage 1 DEC 5 3 DZBD1P
ZBD1T Cash discount days 1 DEC 3 0 DZBD1T
ZBD2P Cash Discount Percentage 2 DEC 5 3 DZBD2P
ZBD2T Cash discount days 2 DEC 3 0 DZBD2T
ZBD3T Net Payment Terms Period DEC 3 0 DZBD3T
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
ZINSZ Interest Calculation Numerator (Days in Arrears * Amount) CURR 23 2 DZINSZ
ZLSCH Payment Method CHAR 1 0 T042Z DZLSCH
ZLSPR Payment Block Key CHAR 1 0 DZLSPR
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZUONR Assignment number CHAR 18 0 DZUONR
XREF1 Business Partner Reference Key CHAR 12 0 XREF1
XREF2 Business Partner Reference Key CHAR 12 0 XREF2
XARCH Indicator: Document Already Archived? CHAR 1 0 XARCH
RSTGR Reason Code for Payments CHAR 3 0 RSTGR
ASKTO Current Cash Disc. Amount in Document Currency with +/- Sign CURR 23 2 ASKTO_VZ
KURSE Effective Exchange Rate in the Line Item DEC 9 5 KURSE
REBZT Follow-On Document Type CHAR 1 0 REBZT
PSWSL Update Currency for General Ledger Transaction Figures CUKY 5 0 TCURC PSWSL
PSWBT Amount for Updating in General Ledger CURR 23 2 PSWBT
HKONT General Ledger Account CHAR 10 0 HKONT
XNEGP Indicator: Negative Posting CHAR 1 0 XNEGP
ZBFIX Fixed Payment Terms CHAR 1 0 DZBFIX
RFZEI Payment Card Item NUMC 3 0 RFZEI_CC
CCBTC Payment cards: Settlement run CHAR 10 0 CCBTC
KKBER Credit control area CHAR 4 0 T014 KKBER
XREF3 Reference key for line item CHAR 20 0 XREF3
DTWS1 Instruction Key 1 NUMC 2 0 DTAT16
DTWS2 Instruction Key 2 NUMC 2 0 DTAT17
DTWS3 Instruction key 3 NUMC 2 0 DTAT18
DTWS4 Instruction key 4 NUMC 2 0 DTAT19
ABSBT Credit Management: Hedged Amount CURR 23 2 ABSBT
KKBWR Currency of Credit Control Area CUKY 5 0 KKBWR
PROJK Individual Structural Element (WBS Element) in Ext. Format CHAR 24 0 PROJK_EXT
XPYPR Indicator: Items from Payment Program Blocked CHAR 1 0 XPYPR
KIDNO Payment Reference CHAR 30 0 KIDNO
XAUGP Indicator: Item Has Been Cleared? CHAR 1 0 XAUGP
BUPLA Business Place CHAR 4 0 BUPLA
SECCO Section Code CHAR 4 0 SECCO
GKART Offsetting Account Type CHAR 1 0 GKART
GKONT Offsetting Account Number CHAR 10 0 GKONT
PYCUR Currency for Automatic Payment CUKY 5 0 PYCUR
PYAMT Amount in Payment Currency CURR 23 2 PYAMT
PYORD Payment Order CHAR 10 0 PYORD
XTEXT Indicator: Texts Exist? CHAR 1 0 XTEXT_F02L
TDID Text ID CHAR 4 0 TDID
XDUEN Indicator: Item Is Due Net? CHAR 1 0 XDUEN
XDUE1 Indicator: Cash Discount Term 1 Is Due on Item? CHAR 1 0 XDUE1
XRAGL Indicator: Clearing Was Reversed CHAR 1 0 XRAGL
XSELP Item selected (selected, chosen, ...) CHAR 1 0 XSELP
CESSION_KZ Accounts Receivable Pledging Indicator CHAR 2 0 CESSION_KZ
BUZID Identification of the Line Item CHAR 1 0 BUZID
AUGGJ Fiscal Year of Clearing Document NUMC 4 0 AUGGJ
AGZEI Clearing Item DEC 5 0 AGZEI
LONGNUM Smart Number CHAR 40 0 /SAPPSPRO/LONGNUM
RUNID MCA Run ID NUMC 12 0 GLE_MCA_DTE_RUNID
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
/SAPF15/STATUS Document Status CHAR 1 0 /SAPF15/STATUS
/SAPF15/BEWIRTSCHAFTER CHAR 8 0 /SAPF15/BEWIRTSCHAFTER
/SAPF15/HAUSHALTSSTELLE CHAR 10 0 /SAPF15/HAUSHALTSSTELLE
/SAPF15/OBJEKTNUMMER CHAR 10 0 /SAPF15/OBJEKTNUMMER
/SAPF15/BELNR CHAR 8 0 /SAPF15/BELNR
/SAPF15/VSL CHAR 5 0 /SAPF15/VSL
/SAPF15/ZUV CHAR 1 0 /SAPF15/ZUV
/SAPF15/KASSENZEICHEN CHAR 12 0 /SAPF15/KASSENZEICHEN
/SAPF15/DATENTRAEGER CHAR 8 0 /SAPF15/DATENTRAEGER
/SAPF15/BETRAG Amount in Local Currency CURR 13 2 DMBTR_CS
/SAPF15/STATUS_ELKO CHAR 1 0 /SAPF15/STATUS_ELKO
/SAPF15/HKR_BETRAG Amount in Local Currency CURR 13 2 DMBTR_CS
/SAPF15/HKR_STATUS CHAR 1 0 /SAPF15/HKR_STATUS
/SAPF15/ERSDA Created On DATS 8 0 ERSDA
/SAPF15/ERZET Entry time TIMS 6 0 ERZET
/SAPF15/ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
/SAPF15/LAEDA Date of Last Change DATS 8 0 LAEDA
/SAPF15/AEZET Time last change was made TIMS 6 0 AEZET
/SAPF15/AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
EXT_KEY Case ID CHAR 12 0 FDM_EXT_KEY
PROCESSOR Processor CHAR 12 0 FDM_PROCESSOR
PRIORITY_TEXT Priority of Dispute Case CHAR 40 0 FDM_PRIORITY_TEXT
STAT_ORDERNO_TEXT Status of Dispute Case CHAR 40 0 FDM_STAT_ORDERNO_TEXT
CDIS_BELNR Related Invoice Is Customer-Disputed CHAR 10 0 FDM_CDIS_BELNR
PINR Payer Invoice Number CHAR 10 0 ISJPPINR
MINR Monthly Invoice Number CHAR 10 0 ISJPMINR
VIRTACCTNR Virtual Account Number CHAR 10 0 * ISJPVIRTACCTNR
INVSUMPAYER Invoice Summary Payer CHAR 10 0 ISJPINVSUMPAYER
INVSUMRECIP Invoice Summary Recipient CHAR 10 0 ISJPINVSUMRECIP
INVCSMMRYPAYERNAME Invoice Summary Payer Name CHAR 80 0 ISJP_PAYERNAME
INVCSMMRYRECIPIENTNAME Invoice Summary Recipient Name CHAR 80 0 ISJP_RECPTNAME
PRODPER Production Month ACCP 6 0 JVA_PROD_MONTH
VNAME Joint venture CHAR 6 0 T8JV JV_NAME
EGRUP Equity group CHAR 3 0 T8JF JV_EGROUP
BTYPE Billing Indicator CHAR 2 0 T8JA JV_BILIND
PROPMANO Mandate, Mandate-Opening Contract CHAR 13 0 REHORECNNRM

RFPOS foreign key relationships

Table Field Check Table Check Field
0 RFPOS BLART T003 Document Types MANDT
1 RFPOS BSCHL TBSL Posting Key MANDT
1 RFPOS BSCHL TBSL Posting Key BSCHL
0 RFPOS BTYPE T8JA Payroll Type MANDT
0 RFPOS BTYPE T8JA Payroll Type BILIND
1 RFPOS BUKRS T001 Company Codes BUKRS
0 RFPOS EGRUP T8JF Investment Group MANDT
0 RFPOS EGRUP T8JF Investment Group BUKRS
0 RFPOS EGRUP T8JF Investment Group VNAME
0 RFPOS EGRUP T8JF Investment Group EGRUP
1 RFPOS GSBER TGSB Business Areas MANDT
1 RFPOS GSBER TGSB Business Areas GSBER
0 RFPOS HWAER TCURC Currency Codes MANDT
0 RFPOS HWAER TCURC Currency Codes WAERS
1 RFPOS KKBER T014 Credit control areas KKBER
0 RFPOS MSCHL T040 Dunning keys MSCHL
1 RFPOS PSWSL TCURC Currency Codes MANDT
1 RFPOS PSWSL TCURC Currency Codes WAERS
0 RFPOS VNAME T8JV Joint Venture MANDT
0 RFPOS VNAME T8JV Joint Venture BUKRS
0 RFPOS VNAME T8JV Joint Venture VNAME
1 RFPOS WAERS TCURC Currency Codes MANDT
1 RFPOS WAERS TCURC Currency Codes WAERS
0 RFPOS ZLSCH T042Z Payment Methods for Automatic Payment MANDT
0 RFPOS ZLSCH T042Z Payment Methods for Automatic Payment LAND1
0 RFPOS ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH