SAP ABAP Table RFPSD (Line Item Data and Additional Data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FBAS (Package) Financial accounting 'Basis'
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FBAS (Package) Financial accounting 'Basis'
Basic Data
Table Category | INTTAB | Structure |
Structure | RFPSD | Table Relationship Diagram |
Short Description | Line Item Data and Additional Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Line Item data for Customer/Vendor/G/L Account | |||||
2 | ACTIV | ACTIV | NUM02 | NUMC | 2 | 0 | List Level in which the Line Item is Active | ||
3 | ANLN1 | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
4 | ANLN2 | ANLN2_4 | ANLN2_4 | CHAR | 4 | 0 | New asset subnumber, 4 characters | ||
5 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
6 | AUGBL | AUGBL | BELNR | CHAR | 10 | 0 | Document Number of the Clearing Document | ||
7 | AUGDT | AUGDT | DATUM | DATS | 8 | 0 | Clearing Date | ||
8 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
9 | BLART | BLART | BLART | CHAR | 2 | 0 | Document type | T003 | |
10 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
11 | BSCHL | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
12 | BSTAT | BSTAT_D | BSTAT | CHAR | 1 | 0 | Document Status | ||
13 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
14 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
15 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
16 | BWWRT | BWWRT | WRTV7 | CURR | 13 | 2 | Amount Valuated in Local Currency | ||
17 | BWWR2 | BWWR2 | WRTV7 | CURR | 13 | 2 | Amount Valuated in Local Currency 2 | ||
18 | BWWR3 | BWWR3 | WRTV7 | CURR | 13 | 2 | Amount Valuated in Local Currency 3 | ||
19 | DMSHB | DMSHB | WRTV7 | CURR | 13 | 2 | Amount in Local Currency with +/- Signs | ||
20 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | TCURC | |
21 | DMBE2 | DMBE2_VZ | WRTV7 | CURR | 13 | 2 | Amount in Second Local Currency with +/- Sign | ||
22 | HWAE2 | HWAE2 | WAERS | CUKY | 5 | 0 | Currency Key of Second Local Currency | * | |
23 | DMBE3 | DMBE3_VZ | WRTV7 | CURR | 13 | 2 | Amount in Third Local Currency with +/- Sign | ||
24 | HWAE3 | HWAE3 | WAERS | CUKY | 5 | 0 | Currency Key of Third Local Currency | * | |
25 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
26 | EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
27 | ETEN2 | ETENR | ETENR | NUMC | 4 | 0 | Schedule line | * | |
28 | FAEDT | FAEDT_FPOS | DATUM | DATS | 8 | 0 | Net Due Date | ||
29 | FILKD | FILKD | MAXKK | CHAR | 10 | 0 | Account Number of the Branch | ||
30 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
31 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
32 | JAMON | JAMON_XPO | JAMON_XPO | CHAR | 7 | 0 | Fiscal Year/Posting Period from Posting Date | ||
33 | KOART | KOART | KOART | CHAR | 1 | 0 | Account type | ||
34 | KONTO | KTONR_AV | KTONR | CHAR | 10 | 0 | Account Number | ||
35 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
36 | MABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | * | |
37 | MADAT | MADAT | DATUM | DATS | 8 | 0 | Date of Last Dunning Notice | ||
38 | MANSP | MANSP | MANSP | CHAR | 1 | 0 | Dunning block | T040S | |
39 | MANST | MAHNS_D | MAHNS | NUMC | 1 | 0 | Dunning Level | ||
40 | MONAT | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
41 | MSCHL | MSCHL | MSCHL | CHAR | 1 | 0 | Dunning key | T040 | |
42 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
43 | POSN2 | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | * | |
44 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
45 | QBSHB | QBSHB_VZ | WRTV7 | CURR | 13 | 2 | Withholding Tax Amount (in Doc. Currency) with +/- Sign | ||
46 | QSFBT | QSFBT_VZ | WRTV7 | CURR | 13 | 2 | Amount Free of Withhld.Tax (in Doc.Curr.) with +/- Sign | ||
47 | QSSHB | QSSHB_VZ | WRTV7 | CURR | 13 | 2 | Withholding Tax Base Amount with +/- Sign | ||
48 | REBZG | REBZG | BELNR | CHAR | 10 | 0 | Number of the Invoice the Transaction Belongs to | ||
49 | SAMNR | SAMNR | SAMNR | NUMC | 8 | 0 | Invoice List Number | ||
50 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
51 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
52 | SKFBT | SKFBT_VZ | WRTV7 | CURR | 13 | 2 | Amount Subject to Discount in Document Curr. with +/- Sign | ||
53 | SKNTO | SKNTO_VZ | WRTV7 | CURR | 13 | 2 | Cash Discount Amount (+/-) in Local Currency | ||
54 | STAKZ | XSTKZ | XFELD | CHAR | 1 | 0 | Indicator: Statistical document ? | ||
55 | UMSKS | UMSKS | UMSKS | CHAR | 1 | 0 | Special G/L Transaction Type | ||
56 | UMSKZ | UMSKZ | UMSKZ | CHAR | 1 | 0 | Special G/L Indicator | * | |
57 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | * | |
58 | VALUT | VALUT | DATUM | DATS | 8 | 0 | Fixed Value Date | ||
59 | VBEL2 | VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | * | |
60 | VBELN | VBELN_VF | VBELN | CHAR | 10 | 0 | Billing document | * | |
61 | VBEWA | SBEWART | SBEWART | CHAR | 4 | 0 | Flow Type | * | |
62 | VBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | * | |
63 | VERTN | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
64 | VERTT | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
65 | VERZ1 | VERZ1 | WRTV3 | DEC | 5 | 0 | Days in Arrears for Cash Discount Terms 1 | ||
66 | VERZN | VERZN | WRTV3 | DEC | 5 | 0 | Days in Arrears by Net Due Date | ||
67 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
68 | WRSHB | WRSHB | WRTV7 | CURR | 13 | 2 | Foreign Currency Amount with Signs (+/-) | ||
69 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
70 | WSKTO | WSKTO_VZ | WRTV7 | CURR | 13 | 2 | Cash discount amount in document currency with +/- sign | ||
71 | WVERW | WVERW | WVERW | CHAR | 1 | 0 | Bill of Exchange Usage Type | ||
72 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
73 | XSTRP | XSTRP | XFELD | CHAR | 1 | 0 | Indicator: Disputed item? | ||
74 | XZAHL | XZAHL | XFELD | CHAR | 1 | 0 | Indicator: Is Posting Key Used in a Payment Transaction? | ||
75 | ZALDT | DZALDT | DATUM | DATS | 8 | 0 | Probable Payment Date (Cash Discount 1 Due) | ||
76 | ZBD1P | DZBD1P | PRZ23 | DEC | 5 | 3 | Cash discount percentage 1 | ||
77 | ZBD1T | DZBD1T | ZBDXT | DEC | 3 | 0 | Cash discount days 1 | ||
78 | ZBD2P | DZBD2P | PRZ23 | DEC | 5 | 3 | Cash Discount Percentage 2 | ||
79 | ZBD2T | DZBD2T | ZBDXT | DEC | 3 | 0 | Cash discount days 2 | ||
80 | ZBD3T | DZBD3T | ZBDXT | DEC | 3 | 0 | Net Payment Terms Period | ||
81 | ZFBDT | DZFBDT | DATUM | DATS | 8 | 0 | Baseline date for due date calculation | ||
82 | ZINSZ | DZINSZ | WRTV8 | CURR | 15 | 2 | Interest Calculation Numerator (Days in Arrears * Amount) | ||
83 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | T042Z | |
84 | ZLSPR | DZLSPR | ZAHLS | CHAR | 1 | 0 | Payment Block Key | * | |
85 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
86 | ZUONR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
87 | XREF1 | XREF1 | CHAR12 | CHAR | 12 | 0 | Business partner reference key | ||
88 | XREF2 | XREF2 | CHAR12 | CHAR | 12 | 0 | Business partner reference key | ||
89 | XARCH | XARCH | XFELD | CHAR | 1 | 0 | Indicator: Document already archived ? | ||
90 | RSTGR | RSTGR | RSTGR | CHAR | 3 | 0 | Reason Code for Payments | * | |
91 | ASKTO | ASKTO_VZ | WRTV7 | CURR | 13 | 2 | Current Cash Disc. Amount in Document Currency with +/- Sign | ||
92 | KURSE | KURSE | KURSF | DEC | 9 | 5 | Effective Exchange Rate in the Line Item | ||
93 | REBZT | REBZT | REBZT | CHAR | 1 | 0 | Follow-On Document Type | ||
94 | PSWSL | PSWSL | WAERS | CUKY | 5 | 0 | Update Currency for General Ledger Transaction Figures | TCURC | |
95 | PSWBT | PSWBT | WERT7 | CURR | 13 | 2 | Amount for Updating in General Ledger | ||
96 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
97 | XNEGP | XNEGP | XFELD | CHAR | 1 | 0 | Indicator: Negative posting | ||
98 | ZBFIX | DZBFIX | ZBFIX | CHAR | 1 | 0 | Fixed Payment Terms | ||
99 | RFZEI | RFZEI_CC | NUM03 | NUMC | 3 | 0 | Payment Card Item | ||
100 | CCBTC | CCBTC | CCBTC | CHAR | 10 | 0 | Payment cards: Settlement run | ||
101 | KKBER | KKBER | KKBER | CHAR | 4 | 0 | Credit control area | T014 | |
102 | XREF3 | XREF3 | CHAR20 | CHAR | 20 | 0 | Reference key for line item | ||
103 | DTWS1 | DTAT16 | DTWSX | NUMC | 2 | 0 | Instruction key 1 | * | |
104 | DTWS2 | DTAT17 | DTWSX | NUMC | 2 | 0 | Instruction key 2 | * | |
105 | DTWS3 | DTAT18 | DTWSX | NUMC | 2 | 0 | Instruction key 3 | * | |
106 | DTWS4 | DTAT19 | DTWSX | NUMC | 2 | 0 | Instruction key 4 | * | |
107 | ABSBT | ABSBT | WERT7 | CURR | 13 | 2 | Credit Management: Hedged Amount | ||
108 | KKBWR | KKBWR | WAERS | CUKY | 5 | 0 | Currency of Credit Control Area | * | |
109 | PROJK | PROJK_EXT | CHAR24 | CHAR | 24 | 0 | Individual Structural Element (WBS Element) in Ext. Format | ||
110 | XPYPR | XPYPR | XFELD | CHAR | 1 | 0 | Indicator: Items from Payment Program Blocked | ||
111 | KIDNO | KIDNO | CHAR30 | CHAR | 30 | 0 | Payment Reference | ||
112 | XAUGP | XAUGP | XFELD | CHAR | 1 | 0 | Indicator: Item has been cleared? | ||
113 | BUPLA | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | Business Place | * | |
114 | SECCO | SECCO | SECCO | CHAR | 4 | 0 | Section Code | * | |
115 | GKART | GKART | GKART | CHAR | 1 | 0 | Offsetting Account Type | ||
116 | GKONT | GKONT | GKONT | CHAR | 10 | 0 | Offsetting Account Number | ||
117 | PYCUR | PYCUR | WAERS | CUKY | 5 | 0 | Currency for Automatic Payment | * | |
118 | PYAMT | PYAMT | WERT7 | CURR | 13 | 2 | Amount in Payment Currency | ||
119 | PYORD | PYORD | PYORD | CHAR | 10 | 0 | Payment Order | ||
120 | XTEXT | XTEXT_F02L | XFELD | CHAR | 1 | 0 | Indicator: Texts exist ? | ||
121 | TDID | TDID | TDID | CHAR | 4 | 0 | Text ID | * | |
122 | XDUEN | XDUEN | XFELD | CHAR | 1 | 0 | Indicator: Item is due net? | ||
123 | XDUE1 | XDUE1 | XFELD | CHAR | 1 | 0 | Indicator: Cash discount term 1 is due on item? | ||
124 | XRAGL | XRAGL | XFELD | CHAR | 1 | 0 | Indicator: Clearing was Reversed | ||
125 | XSELP | XSELP | XFELD | CHAR | 1 | 0 | Item selected (selected, chosen, ...) | ||
126 | CESSION_KZ | CESSION_KZ | CESSION_KZ | CHAR | 2 | 0 | Accounts Receivable Pledging Indicator | * | |
127 | BUZID | BUZID | CHAR1 | CHAR | 1 | 0 | Identification of the Line Item | ||
128 | AUGGJ | AUGGJ | GJAHR | NUMC | 4 | 0 | Fiscal Year of Clearing Document | ||
129 | AGZEI | AGZEI | AGZEI | DEC | 5 | 0 | Clearing Item | ||
130 | LONGNUM | /SAPPSPRO/LONGNUM | /SAPPSPRO/LONGNUM | CHAR | 40 | 0 | Smart Number | ||
131 | RUNID | GLE_MCA_DTE_RUNID | NUMC12 | NUMC | 12 | 0 | MCA Run ID | ||
132 | .INCLU--AP | 0 | 0 | F15 Append RFPOS | |||||
133 | /SAPF15/STATUS | /SAPF15/STATUS | /SAPF15/STATUS | CHAR | 1 | 0 | Document Status | ||
134 | /SAPF15/BEWIRTSCHAFTER | /SAPF15/BEWIRTSCHAFTER | /SAPF15/BEWIRTSCHAFTER | CHAR | 8 | 0 | Bewirtschafter | * | |
135 | /SAPF15/HAUSHALTSSTELLE | /SAPF15/HAUSHALTSSTELLE | CHAR10 | CHAR | 10 | 0 | Haushaltsstelle | ||
136 | /SAPF15/OBJEKTNUMMER | /SAPF15/OBJEKTNUMMER | CHAR10 | CHAR | 10 | 0 | Objektnummer/Unterteil | ||
137 | /SAPF15/BELNR | /SAPF15/BELNR | CHAR8 | CHAR | 8 | 0 | Bewirtschafterbelegnummer | ||
138 | /SAPF15/VSL | /SAPF15/VSL | /SAPF15/VSL | CHAR | 5 | 0 | Verarbeitungsschlüssel | * | |
139 | /SAPF15/ZUV | /SAPF15/ZUV | XFELD | CHAR | 1 | 0 | ZÜV Verarbeitungschlüssel | ||
140 | /SAPF15/KASSENZEICHEN | /SAPF15/KASSENZEICHEN | CHAR12 | CHAR | 12 | 0 | Kassenzeichen | ||
141 | /SAPF15/DATENTRAEGER | /SAPF15/DATENTRAEGER | CHAR8 | CHAR | 8 | 0 | Datenträgerkennzeichen | ||
142 | /SAPF15/BETRAG | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
143 | /SAPF15/STATUS_ELKO | /SAPF15/STATUS_ELKO | /SAPF15/STATUS_ELKO | CHAR | 1 | 0 | ELKO Status | ||
144 | /SAPF15/HKR_BETRAG | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
145 | /SAPF15/HKR_STATUS | /SAPF15/HKR_STATUS | /SAPF15/HKR_STATUS | CHAR | 1 | 0 | HKR Status Teilzahlung/Restposten/Teilaufhebung/Kursabw. | ||
146 | /SAPF15/ERSDA | ERSDA | DATUM | DATS | 8 | 0 | Created On | ||
147 | /SAPF15/ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
148 | /SAPF15/ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
149 | /SAPF15/LAEDA | LAEDA | DATUM | DATS | 8 | 0 | Date of Last Change | ||
150 | /SAPF15/AEZET | AEZET | UZEIT | TIMS | 6 | 0 | Time last change was made | ||
151 | /SAPF15/AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
152 | .INCLU--AP | 0 | 0 | FSCM-DM: Enhancemt of Line Item Disp. with Dispute Case Flds | |||||
153 | EXT_KEY | FDM_EXT_KEY | FDM_EXT_KEY | CHAR | 12 | 0 | Case ID | ||
154 | PROCESSOR | FDM_PROCESSOR | XUBNAME | CHAR | 12 | 0 | Processor | * | |
155 | PRIORITY_TEXT | FDM_PRIORITY_TEXT | TEXT40 | CHAR | 40 | 0 | Priority of Dispute Case | ||
156 | STAT_ORDERNO_TEXT | FDM_STAT_ORDERNO_TEXT | TEXT40 | CHAR | 40 | 0 | Status of Dispute Case | ||
157 | CDIS_BELNR | FDM_CDIS_BELNR | BELNR | CHAR | 10 | 0 | Related Invoice Is Customer-Disputed | ||
158 | .INCLU--AP | 0 | 0 | Joint Venture Accounting | |||||
159 | PRODPER | JVA_PROD_MONTH | BUPER | ACCP | 6 | 0 | Produktionsmonat | ||
160 | .INCLU--AP | 0 | 0 | Joint Venture Fields | |||||
161 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | T8JV | |
162 | EGRUP | JV_EGROUP | JV_EGROUP | CHAR | 3 | 0 | Equity group | T8JF | |
163 | BTYPE | JV_BILIND | JV_BILIND | CHAR | 2 | 0 | Payroll Type | T8JA | |
164 | .INCLU--AP | 0 | 0 | Append zur Mandatsverwaltung RFPOS | |||||
165 | .INCLUDE | 0 | 0 | Append Struktur für die Mandatsnummer | |||||
166 | PROPMANO | REHORECNNRM | RECNNR | CHAR | 13 | 0 | Mandate, Mandate-Opening Contract | ||
167 | KTEXT | TXT35_KONTO | TEXT35 | CHAR | 35 | 0 | Short Text for G/L Account or Customer/Vendor Account | ||
168 | KTEXT_GL | TXT20_SKAT_RFPSD | TEXT20 | CHAR | 20 | 0 | G/L Account Short Text |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RFPSD | BLART | T003 | BLART | |||
2 | RFPSD | BSCHL | TBSL | BSCHL | |||
3 | RFPSD | BTYPE | T8JA | BILIND | REF | C | CN |
4 | RFPSD | BUKRS | T001 | BUKRS | |||
5 | RFPSD | EGRUP | T8JF | EGRUP | REF | C | CN |
6 | RFPSD | GSBER | TGSB | GSBER | |||
7 | RFPSD | HWAER | TCURC | WAERS | |||
8 | RFPSD | KKBER | T014 | KKBER | REF | 1 | CN |
9 | RFPSD | MANSP | T040S | MANSP | |||
10 | RFPSD | MSCHL | T040 | MSCHL | |||
11 | RFPSD | PSWSL | TCURC | WAERS | |||
12 | RFPSD | VNAME | T8JV | VNAME | REF | C | CN |
13 | RFPSD | WAERS | TCURC | WAERS | |||
14 | RFPSD | ZLSCH | T042Z | ZLSCH |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |