SAP Table RFPSD

Line Item Data and Additional Data

RFPSD (Line Item Data and Additional Data) 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 RFPSD to other SAP tables.

RFPSD table fields

Field Data element Checktable Datatype Length Decimals
ACTIV List Level in which the Line Item is Active ACTIV NUMC 2 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 New asset subnumber, 4 characters ANLN2_4 CHAR 4 0
AUFNR Order Number AUFNR CHAR 12 0
AUGBL Document Number of the Clearing Document AUGBL CHAR 10 0
AUGDT Clearing Date AUGDT DATS 8 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BLART Document Type BLART T003 CHAR 2 0
BLDAT Document Date in Document BLDAT DATS 8 0
BSCHL Posting Key BSCHL TBSL CHAR 2 0
BSTAT Document Status BSTAT_D CHAR 1 0
NULL Normal document
A Clearing Document
B Reset clearing document
D Recurring entry document
L Posting Not in Leading Ledger
M Sample document
S Noted items
V Parked document
W Parked document with change of document ID
Z Parked document which was deleted
C Balance Carryforward Line Items
BUDAT Posting Date in the Document BUDAT DATS 8 0
BUKRS Company Code BUKRS T001 CHAR 4 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
BWWRT Amount Valuated in Local Currency BWWRT CURR 13 2
BWWR2 Amount Valuated in Local Currency 2 BWWR2 CURR 13 2
BWWR3 Amount Valuated in Local Currency 3 BWWR3 CURR 13 2
DMSHB Amount in Local Currency with +/- Signs DMSHB CURR 13 2
HWAER Local Currency HWAER TCURC CUKY 5 0
DMBE2 Amount in Second Local Currency with +/- Sign DMBE2_VZ CURR 13 2
HWAE2 Currency Key of Second Local Currency HWAE2 CUKY 5 0
DMBE3 Amount in Third Local Currency with +/- Sign DMBE3_VZ CURR 13 2
HWAE3 Currency Key of Third Local Currency HWAE3 CUKY 5 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
ETEN2 Delivery Schedule Line Number ETENR NUMC 4 0
FAEDT Net Due Date FAEDT_FPOS DATS 8 0
FILKD Account Number of the Branch FILKD CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
GSBER Business Area GSBER TGSB CHAR 4 0
JAMON Fiscal Year/Posting Period from Posting Date JAMON_XPO CHAR 7 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
KONTO Account Number KTONR_AV CHAR 10 0
KOSTL Cost Center KOSTL CHAR 10 0
MABER Dunning Area MABER CHAR 2 0
MADAT Last dunned on MADAT DATS 8 0
MANSP Dunning block MANSP T040S CHAR 1 0
MANST Dunning level MAHNS_D NUMC 1 0
MONAT Fiscal Period MONAT NUMC 2 0
MSCHL Dunning key MSCHL T040 CHAR 1 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
POSN2 Sales Document Item POSNR_VA NUMC 6 0
PRCTR Profit Center PRCTR CHAR 10 0
QBSHB Withholding Tax Amount (in Doc. Currency) with +/- Sign QBSHB_VZ CURR 13 2
QSFBT Amount Free of Withhld.Tax (in Doc.Curr.) with +/- Sign QSFBT_VZ CURR 13 2
QSSHB Withholding Tax Base Amount with +/- Sign QSSHB_VZ CURR 13 2
REBZG Number of the Invoice the Transaction Belongs to REBZG CHAR 10 0
SAMNR Invoice List Number SAMNR NUMC 8 0
SGTXT Item Text SGTXT CHAR 50 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
SKFBT Amount Subject to Discount in Document Curr. with +/- Sign SKFBT_VZ CURR 13 2
SKNTO Cash Discount Amount (+/-) in Local Currency SKNTO_VZ CURR 13 2
STAKZ Indicator: Statistical document ? XSTKZ CHAR 1 0
X Yes
NULL No
UMSKS Special G/L Transaction Type UMSKS CHAR 1 0
UMSKZ Special G/L Indicator UMSKZ CHAR 1 0
UZAWE Payment Method Supplement UZAWE CHAR 2 0
VALUT Value date VALUT DATS 8 0
VBEL2 Sales Document VBELN_VA CHAR 10 0
VBELN Billing Document VBELN_VF CHAR 10 0
VBEWA Flow Type SBEWART CHAR 4 0
VBUND Company ID of trading partner RASSC CHAR 6 0
VERTN Contract Number RANL CHAR 13 0
VERTT Contract Type RANTYP CHAR 1 0
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
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
VERZ1 Days in Arrears for Cash Discount Terms 1 VERZ1 DEC 5 0
VERZN Days in Arrears by Net Due Date VERZN DEC 5 0
WERKS Plant WERKS_D CHAR 4 0
WRSHB Foreign Currency Amount with Signs (+/-) WRSHB CURR 13 2
WAERS Currency Key WAERS TCURC CUKY 5 0
WSKTO Cash discount amount in document currency with +/- sign WSKTO_VZ CURR 13 2
WVERW Bill of exchange usage type WVERW CHAR 1 0
D Discounting
F Forfeiting
I Collection
XBLNR Reference Document Number XBLNR1 CHAR 16 0
XSTRP Indicator: Disputed item? XSTRP CHAR 1 0
X Yes
NULL No
XZAHL Indicator: Is the posting key used in a payment transaction? XZAHL CHAR 1 0
X Yes
NULL No
ZALDT Probable Payment Date (Cash Discount 1 Due) DZALDT DATS 8 0
ZBD1P Cash Discount Percentage 1 DZBD1P DEC 5 3
ZBD1T Cash discount days 1 DZBD1T DEC 3 0
ZBD2P Cash Discount Percentage 2 DZBD2P DEC 5 3
ZBD2T Cash discount days 2 DZBD2T DEC 3 0
ZBD3T Net Payment Terms Period DZBD3T DEC 3 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
ZINSZ Interest Calculation Numerator (Days in Arrears * Amount) DZINSZ CURR 15 2
ZLSCH Payment Method DZLSCH T042Z CHAR 1 0
ZLSPR Payment Block Key DZLSPR CHAR 1 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZUONR Assignment Number DZUONR CHAR 18 0
XREF1 Business partner reference key XREF1 CHAR 12 0
XREF2 Business partner reference key XREF2 CHAR 12 0
XARCH Indicator: Document already archived ? XARCH CHAR 1 0
X Yes
NULL No
RSTGR Reason Code for Payments RSTGR CHAR 3 0
ASKTO Current Cash Disc. Amount in Document Currency with +/- Sign ASKTO_VZ CURR 13 2
KURSE Effective Exchange Rate in the Line Item KURSE DEC 9 5
REBZT Follow-On Document Type REBZT CHAR 1 0
PSWSL Update Currency for General Ledger Transaction Figures PSWSL TCURC CUKY 5 0
PSWBT Amount for Updating in General Ledger PSWBT CURR 13 2
HKONT General Ledger Account HKONT CHAR 10 0
XNEGP Indicator: Negative posting XNEGP CHAR 1 0
X Yes
NULL No
ZBFIX Fixed Payment Terms DZBFIX CHAR 1 0
NULL No fixing
1 1st cash disc.percentage rate or cash disc.amount is fixed
2 2nd cash discount percentage rate is fixed
RFZEI Payment Card Item RFZEI_CC NUMC 3 0
CCBTC Payment cards: Settlement run CCBTC CHAR 10 0
KKBER Credit control area KKBER T014 CHAR 4 0
XREF3 Reference key for line item XREF3 CHAR 20 0
DTWS1 Instruction key 1 DTAT16 NUMC 2 0
DTWS2 Instruction key 2 DTAT17 NUMC 2 0
DTWS3 Instruction key 3 DTAT18 NUMC 2 0
DTWS4 Instruction key 4 DTAT19 NUMC 2 0
ABSBT Credit management: Hedged amount ABSBT CURR 13 2
KKBWR Currency of Credit Control Area KKBWR CUKY 5 0
PROJK Individual Structural Element (WBS Element) in Ext. Format PROJK_EXT CHAR 24 0
XPYPR Indicator: Items from Payment Program Blocked XPYPR CHAR 1 0
X Yes
NULL No
KIDNO Payment Reference KIDNO CHAR 30 0
XAUGP Indicator: Item has been cleared? XAUGP CHAR 1 0
X Yes
NULL No
BUPLA Business Place BUPLA CHAR 4 0
SECCO Section Code SECCO CHAR 4 0
GKART Offsetting Account Type GKART CHAR 1 0
GKONT Offsetting Account Number GKONT CHAR 10 0
PYCUR Currency for Automatic Payment PYCUR CUKY 5 0
PYAMT Amount in Payment Currency PYAMT CURR 13 2
PYORD Payment Order PYORD CHAR 10 0
XTEXT Indicator: Texts exist ? XTEXT_F02L CHAR 1 0
X Yes
NULL No
TDID Text ID TDID CHAR 4 0
XDUEN Indicator: Item is due net? XDUEN CHAR 1 0
X Yes
NULL No
XDUE1 Indicator: Cash discount term 1 is due on item? XDUE1 CHAR 1 0
X Yes
NULL No
XRAGL Indicator: Clearing was Reversed XRAGL CHAR 1 0
X Yes
NULL No
XSELP Item selected (selected, chosen, ...) XSELP CHAR 1 0
X Yes
NULL No
CESSION_KZ Accounts Receivable Pledging Indicator CESSION_KZ CHAR 2 0
BUZID Identification of the Line Item BUZID CHAR 1 0
AUGGJ Fiscal Year of Clearing Document AUGGJ NUMC 4 0
AGZEI Clearing Item AGZEI DEC 5 0
LONGNUM Smart Number /SAPPSPRO/LONGNUM CHAR 40 0
RUNID MCA Run ID GLE_MCA_DTE_RUNID NUMC 12 0
/SAPF15/STATUS /SAPF15/STATUS CHAR 1 0
/SAPF15/BEWIRTSCHAFTER /SAPF15/BEWIRTSCHAFTER CHAR 8 0
/SAPF15/HAUSHALTSSTELLE /SAPF15/HAUSHALTSSTELLE CHAR 10 0
/SAPF15/OBJEKTNUMMER /SAPF15/OBJEKTNUMMER CHAR 10 0
/SAPF15/BELNR /SAPF15/BELNR CHAR 8 0
/SAPF15/VSL /SAPF15/VSL CHAR 5 0
/SAPF15/ZUV /SAPF15/ZUV CHAR 1 0
X Yes
NULL No
/SAPF15/KASSENZEICHEN /SAPF15/KASSENZEICHEN CHAR 12 0
/SAPF15/DATENTRAEGER /SAPF15/DATENTRAEGER CHAR 8 0
/SAPF15/BETRAG Amount in Local Currency DMBTR CURR 13 2
/SAPF15/STATUS_ELKO /SAPF15/STATUS_ELKO CHAR 1 0
/SAPF15/HKR_BETRAG Amount in Local Currency DMBTR CURR 13 2
/SAPF15/HKR_STATUS /SAPF15/HKR_STATUS CHAR 1 0
/SAPF15/ERSDA Created On ERSDA DATS 8 0
/SAPF15/ERZET Entry time ERZET TIMS 6 0
/SAPF15/ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
/SAPF15/LAEDA Date of Last Change LAEDA DATS 8 0
/SAPF15/AEZET Time last change was made AEZET TIMS 6 0
/SAPF15/AENAM Name of Person Who Changed Object AENAM CHAR 12 0
EXT_KEY Case ID FDM_EXT_KEY CHAR 12 0
PROCESSOR Processor FDM_PROCESSOR CHAR 12 0
PRIORITY_TEXT Priority of Dispute Case FDM_PRIORITY_TEXT CHAR 40 0
STAT_ORDERNO_TEXT Status of Dispute Case FDM_STAT_ORDERNO_TEXT CHAR 40 0
CDIS_BELNR Related Invoice Is Customer-Disputed FDM_CDIS_BELNR CHAR 10 0
PRODPER JVA_PROD_MONTH ACCP 6 0
VNAME Joint Venture JV_NAME T8JV CHAR 6 0
EGRUP Equity group JV_EGROUP T8JF CHAR 3 0
BTYPE Payroll Type JV_BILIND T8JA CHAR 2 0
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 0
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC CHAR 1 0
PROPMANO Mandate, Mandate-Opening Contract REHORECNNRM CHAR 13 0
KTEXT Short Text for G/L Account or Customer/Vendor Account TXT35_KONTO CHAR 35 0
KTEXT_GL G/L Account Short Text TXT20_SKAT_RFPSD CHAR 20 0

RFPSD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RFPSD BLART SYST MANDT T003 Document Types MANDT
RFPSD BLART RFPSD BLART T003 Document Types BLART
RFPSD BSCHL SYST MANDT TBSL Posting Key MANDT
RFPSD BSCHL RFPSD BSCHL TBSL Posting Key BSCHL
RFPSD BTYPE * T8JA Payroll Type MANDT
RFPSD BTYPE RFPSD BTYPE T8JA Payroll Type BILIND
RFPSD BUKRS SYST MANDT T001 Company Codes MANDT
RFPSD BUKRS RFPSD BUKRS T001 Company Codes BUKRS
RFPSD EGRUP RFPSD BUKRS T8JF Investment Group BUKRS
RFPSD EGRUP RFPSD VNAME T8JF Investment Group VNAME
RFPSD EGRUP RFPSD EGRUP T8JF Investment Group EGRUP
RFPSD EGRUP * T8JF Investment Group MANDT
RFPSD GSBER SYST MANDT TGSB Business Areas MANDT
RFPSD GSBER RFPSD GSBER TGSB Business Areas GSBER
RFPSD HWAER SYST MANDT TCURC Currency Codes MANDT
RFPSD HWAER RFPSD HWAER TCURC Currency Codes WAERS
RFPSD KKBER SYST MANDT T014 Credit control areas MANDT
RFPSD KKBER RFPSD KKBER T014 Credit control areas KKBER
RFPSD MANSP SYST MANDT T040S Blocking reasons for dunning notices MANDT
RFPSD MANSP RFPSD MANSP T040S Blocking reasons for dunning notices MANSP
RFPSD MSCHL SYST MANDT T040 Dunning keys MANDT
RFPSD MSCHL RFPSD MSCHL T040 Dunning keys MSCHL
RFPSD PSWSL RFPSD PSWSL TCURC Currency Codes WAERS
RFPSD PSWSL SYST MANDT TCURC Currency Codes MANDT
RFPSD VNAME * T8JV Joint Venture MANDT
RFPSD VNAME RFPSD BUKRS T8JV Joint Venture BUKRS
RFPSD VNAME RFPSD VNAME T8JV Joint Venture VNAME
RFPSD WAERS SYST MANDT TCURC Currency Codes MANDT
RFPSD WAERS RFPSD WAERS TCURC Currency Codes WAERS
RFPSD ZLSCH T001 LAND1 T042Z Payment Methods for Automatic Payment LAND1
RFPSD ZLSCH RFPSD ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH
RFPSD ZLSCH SYST MANDT T042Z Payment Methods for Automatic Payment MANDT