SAP ABAP Table RBINVPRNT (Invoice Documents for Output)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       MRM (Package) Appl.development R/3 decentralized invoice verification
Basic Data
Table Category INTTAB    Structure 
Structure RBINVPRNT   Table Relationship Diagram
Short Description Invoice Documents for Output    
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   Generated Table for View  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 BELNR RE_BELNR BELNR CHAR 10   0   Document Number of an Invoice Document  
4 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
5 BLART BLART BLART CHAR 2   0   Document type T003
6 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
7 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
8 USNAM USNAM XUBNAME CHAR 12   0   User name *
9 TCODE TCODE TCODE CHAR 20   0   Transaction Code TSTC
10 CPUDT CPUDT DATUM DATS 8   0   Accounting document entry date  
11 CPUTM CPUTM UZEIT TIMS 6   0   Time of data entry  
12 VGART M8VGA M8VGA CHAR 2   0   Transaction Type in AG08 (Internal Document Type)  
13 XBLNR XBLNR1 XBLNR1 CHAR 16   0   Reference Document Number  
14 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
15 LIFNR LIFRE LIFNR CHAR 10   0   Different Invoicing Party LFA1
16 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
17 KURSF KURSF KURSF DEC 9   5   Exchange rate  
18 RMWWR RMWWR WERT7 CURR 13   2   Gross invoice amount in document currency  
19 BEZNK BEZNK ANLKWERT CURR 13   2   Unplanned delivery costs  
20 WMWST1 FWSTEV WERTV7 CURR 13   2   Tax Amount in Document Currency with +/- Sign  
21 MWSKZ1 MWSKZ_MRM1 MRM_MWSKZ CHAR 2   0   Tax code TMRM007A
22 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
23 ZBD1T DZBD1T ZBDXT DEC 3   0   Cash discount days 1  
24 ZBD1P DZBD1P PRZ23 DEC 5   3   Cash discount percentage 1  
25 ZBD2T DZBD2T ZBDXT DEC 3   0   Cash discount days 2  
26 ZBD2P DZBD2P PRZ23 DEC 5   3   Cash Discount Percentage 2  
27 ZBD3T DZBD3T ZBDXT DEC 3   0   Net Payment Terms Period  
28 WSKTO WSKTO WERT7 CURR 13   2   Cash Discount Amount in Document Currency  
29 XRECH XRECH XRADI CHAR 1   0   Indicator: post invoice  
30 BKTXT BKTXT TEXT25 CHAR 25   0   Document Header Text  
31 SAPRL SAPRL SAPRL CHAR 4   0   SAP Release  
32 LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system *
33 XMWST XMWST XFELD CHAR 1   0   Calculate tax automatically  
34 STBLG RE_STBLG BELNR CHAR 10   0   Reversal document number  
35 STJAH RE_STJAH GJAHR NUMC 4   0   Fiscal year of reversal document  
36 MWSKZ_BNK MWSKZ_MRM MWSKZ CHAR 2   0   Tax Code T007A
37 TXJCD_BNK TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
38 IVTYP IVTYP IVTYP CHAR 1   0   Origin of a Logistics Invoice Verification Document  
39 XRBTX XRBTX XFELD CHAR 1   0   Indicator: more than one tax code  
40 REPART REPART REPART CHAR 1   0   Indicator: Invoice Verification Type  
41 RBSTAT RBSTAT RBSTAT CHAR 1   0   Invoice document status  
42 KNUMVE KNUMVE KNUMV CHAR 10   0   Document condition - own conditions  
43 KNUMVL KNUMVL KNUMV CHAR 10   0   Document condition - vendor error  
44 ARKUEN ARKUEN WERTV7 CURR 13   2   Automatic Invoice Reduction Amount (Net)  
45 ARKUEMW ARKUEMW WERTV7 CURR 13   2   Sales Tax Portion of Automatic Invoice Reduction Amount  
46 MAKZN MAKZN WERTV7 CURR 13   2   Manually accepted net difference amount  
47 MAKZMW MAKZMW WERTV7 CURR 13   2   Tax Amount Accepted Manually  
48 LIEFFN LIEFFN WERTV7 CURR 13   2   Vendor error (exclusive of tax)  
49 LIEFFMW LIEFFMW WERTV7 CURR 13   2   Tax in vendor error  
50 XAUTAKZ XAUTAKZ XFELD CHAR 1   0   Indicates automatically accepted invoices  
51 ESRNR ESRNR ESRNR CHAR 11   0   POR subscriber number  
52 ESRPZ ESRPZ CHAR2 CHAR 2   0   POR check digit  
53 ESRRE ESRRE ESRRE CHAR 27   0   POR reference number  
54 QSSHB QSSHB WERT7 CURR 13   2   Withholding Tax Base Amount  
55 QSFBT QSFBT WERT7 CURR 13   2   Withholding Tax-Exempt Amount (in Document Currency)  
56 QSSKZ QSSKZ QSSKZ CHAR 2   0   Withholding Tax Code T059Q
57 DIEKZ DIEKZ DIEKZ CHAR 1   0   Service indicator (foreign payment)  
58 LANDL LANDL LAND1 CHAR 3   0   Supplying Country T005
59 LZBKZ LZBKZ LZBKZ CHAR 3   0   State central bank indicator T015L
60 TXKRS TXKRS_BKPF KURSF DEC 9   5   Exchange Rate for Taxes  
61 EMPFB EMPFB MAXKK CHAR 10   0   Payee/Payer  
62 BVTYP BVTYP BVTYP CHAR 4   0   Partner bank type  
63 HBKID HBKID HBKID CHAR 5   0   Short key for a house bank T012
64 ZUONR DZUONR ZUONR CHAR 18   0   Assignment number  
65 ZLSPR DZLSPR ZAHLS CHAR 1   0   Payment Block Key T008
66 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method T042Z
67 ZFBDT DZFBDT DATUM DATS 8   0   Baseline date for due date calculation  
68 KIDNO KIDNO CHAR30 CHAR 30   0   Payment Reference  
69 REBZG AWREF_REB AWREF CHAR 10   0   Invoice reference: Document number for invoice reference  
70 REBZJ REBZJ GJAHR NUMC 4   0   Fiscal Year of the Relevant Invoice (for Credit Memo)  
71 VATDATE VATDATE DATUM DATS 8   0   Tax Reporting Date  
72 J_1BNFTYPE J_1BNFTYPE J_1BNFTYPE CHAR 2   0   Nota Fiscal Type J_1BAA
73 BRNCH J_1ABRNCH J_1BBRANCH CHAR 4   0   Branch number J_1BBRANCH
74 ERFPR ERFPR ERFPR CHAR 12   0   Entry profile: Logistics Invoice Verification T169H
75 SECCO SECCO SECCO CHAR 4   0   Section Code SECCODE
76 NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
77 NAME2 NAME2_GP NAME CHAR 35   0   Name 2  
78 NAME3 NAME3_GP NAME CHAR 35   0   Name 3  
79 NAME4 NAME4_GP NAME CHAR 35   0   Name 4  
80 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
81 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
82 LAND1 LAND1_GP LAND1 CHAR 3   0   Country Key *
83 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
84 PFACH PFACH PFACH CHAR 10   0   PO Box  
85 PSTL2 PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
86 PSKTO PSKTO PSKTO CHAR 16   0   Account Number of Bank Account At Post Office  
87 BANKN BANKN BANKN CHAR 18   0   Bank account number  
88 BANKL BANKL BANKL CHAR 15   0   Bank number  
89 BANKS BANKS LAND1 CHAR 3   0   Bank country key *
90 STCD1 STCD1 STCD1 CHAR 16   0   Tax Number 1  
91 STCD2 STCD2 STCD2 CHAR 11   0   Tax Number 2  
92 STKZU STKZU XFELD CHAR 1   0   Liable for VAT  
93 STKZA STKZA STKZA CHAR 1   0   Indicator: Business Partner Subject to Equalization Tax?  
94 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) *
95 BKONT BKONT BKONT CHAR 2   0   Bank Control Key  
96 DTAWS DTAWS DTAWS CHAR 2   0   Instruction key for data medium exchange *
97 DTAMS DTAMS DTAMS CHAR 1   0   Report key for data medium exchange  
98 SPRAS CHAR_LG_01 CHAR_LG_01 CHAR 1   0   Character field of length 1  
99 XCPDK XCPDK XFELD CHAR 1   0   Indicator: Is the account a one-time account?  
100 EMPFG EMPFG EMPFG CHAR 16   0   Payee code  
101 FITYP J_1AFITP_D J_1AFITP CHAR 2   0   Tax type *
102 STCDT J_1ATOID J_1ATOID CHAR 2   0   Tax Number Type *
103 STKZN STKZN STKZN CHAR 1   0   Natural Person  
104 STCD3 STCD3 CHAR18 CHAR 18   0   Tax Number 3  
105 STCD4 STCD4 CHAR18 CHAR 18   0   Tax Number 4  
106 BKREF BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
107 J_1KFREPRE REPRES REPRES CHAR 10   0   Name of Representative  
108 J_1KFTBUS GESTYP GESTYP CHAR 30   0   Type of Business *
109 J_1KFTIND INDTYP INDTYP CHAR 30   0   Type of Industry *
110 ANRED ANRED TEXT15 CHAR 15   0   Title  
111 ERNAME ERNAME SBNAM CHAR 12   0   Entered by external system user  
112 REINDAT REINDAT DATUM DATS 8   0   Invoice Receipt Date  
113 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement *
114 FDLEV FDLEV FDLEV CHAR 2   0   Planning Level *
115 FDTAG FDTAG DATUM DATS 8   0   Planning Date  
116 ZBFIX DZBFIX ZBFIX CHAR 1   0   Fixed Payment Terms  
117 FRGKZ DFRGKZ XFELD CHAR 1   0   Indicator: Release Required  
118 ERFNAM ERFNAM USNAM CHAR 12   0   Name of the Processor Who Entered the Object  
119 XERFB XZUORD XFELD CHAR 1   0   Checkbox: Allocations  
120 ANZRPV ANZRPV NUMC3 NUMC 3   0   No. of invoice verification attempts  
121 REPDAT REPDAT DATUM DATS 8   0   Invoice Verification date  
122 ANZUNF ANZUNF NUMC6 NUMC 6   0   Number of unsolved errors  
123 ANZLIF ANZLIF NUMC6 NUMC 6   0   Number of vendor errors  
124 ANZRPO ANZRPO NUMC6 NUMC 6   0   Number of selected invoice items  
125 LFDATABLI LFDAT DATUM DATS 8   0   Delivery date  
126 LFDATBISLI LFDAT DATUM DATS 8   0   Delivery date  
127 LFDATABRT LFDATRET DATUM DATS 8   0   Delivery date of return  
128 LFDATBISRT LFDATRET DATUM DATS 8   0   Delivery date of return  
129 XZUORDLI XZUORDLI XFELD CHAR 1   0   Indicates delivery item allocation  
130 XZUORDRT XZUORDRT XFELD CHAR 1   0   Indicates returns allocation  
131 XBNK XBNK CHAR1 CHAR 1   0   Planned Delivery Costs Indicator  
132 XWARE XWARE XFELD CHAR 1   0   Goods Invoice/Service Indicator  
133 TBTKZ TBTKZ TBTKZ CHAR 1   0   Indicator: Subsequent Debit/Credit  
134 XBEST XZUORD XFELD CHAR 1   0   Checkbox: Allocations  
135 XLIFS XZUORD XFELD CHAR 1   0   Checkbox: Allocations  
136 XFRBR XZUORD XFELD CHAR 1   0   Checkbox: Allocations  
137 XWERK XZUORD XFELD CHAR 1   0   Checkbox: Allocations  
138 SELIF SELIF LIFNR CHAR 10   0   Number of the selection vendor *
139 BNKSEL BNKSEL BNKSEL CHAR 1   0   Type of delivery cost selection  
140 RPZIELN RPZIELN WERTV7 CURR 13   2   Total of Items Selected  
141 RPZIELMW RPZIELMW WERTV7 CURR 13   2   VAT Portion of Target Invoice Amount in Document Currency  
142 DIFFN RPDIFN WERTV7 CURR 13   2   Document Balance  
143 DIFFMW DIFFMW WERTV7 CURR 13   2   Sales Tax Portion of the Invoice Verification Difference  
144 UBNKMW UBNKMW WERTV7 CURR 13   2   Sales tax portion of unplanned delivery costs  
145 NUMPG J_1ANOPG J_1ANOPG NUMC 3   0   Number of pages of invoice  
146 REPTIM REPTIM SYTIME TIMS 6   0   Invoice Verification time  
147 XRECHL XRECHL XRECH CHAR 1   0   Posting logic for delivery items (invoice/credit memo)  
148 XRECHR XRECHR XRECH CHAR 1   0   Posting logic for returns items (invoice/credit memo)  
149 XKORREKT XKORREKT XFELD CHAR 1   0   Indicates if the invoice is correct  
150 XNOTIZ XNOTIZ XFELD CHAR 1   0   Indicates Whether a Note Exists  
151 ANZLSM ANZLSM XFELD CHAR 1   0   Indicator: More Than One Item with Different Del. Note. Qty  
152 XNEGDIFF EDINEGDIFF XFELD CHAR 1   0   EDI: Indicator for Check for Negative Unclarified Errors  
153 XTRAN XZUORD XFELD CHAR 1   0   Checkbox: Allocations  
154 XTMTRAN XZUORD XFELD CHAR 1   0   Checkbox: Allocations  
155 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place *
156 XINVE XINVE XFELD CHAR 1   0   Indicator: Capital Goods Affected?  
157 FILKD FILKD MAXKK CHAR 10   0   Account Number of the Branch  
158 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
159 GSBER GSBER GSBER CHAR 4   0   Business Area *
160 LOTKZ LOTKZ LOTKZ CHAR 10   0   Lot Number for Documents  
161 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
162 EGMLD EGMLD_BSEZ LAND1 CHAR 3   0   Reporting Country for Delivery of Goods within the EU *
163 XEGDR XEGDR XFELD CHAR 1   0   Indicator: Triangular deal within the EU ?  
164 COPY_BY_BELNR COPY_BY_BELNR BELNR CHAR 10   0   Invoice Document Number of Original Invoice  
165 COPY_BY_YEAR COPY_BY_YEAR GJAHR NUMC 4   0   Fiscal Year of Original Invoice  
166 COPY_TO_BELNR COPY_TO_BELNR BELNR CHAR 10   0   Invoice Document Number of Copied Invoice  
167 COPY_TO_YEAR COPY_TO_YEAR GJAHR NUMC 4   0   Fiscal Year of Copied Invoice  
168 COPY_USER COPY_USER USNAM CHAR 12   0   User That Reversed and Copied the Invoice  
169 INV_TRAN INV_TRAN MRM_VORGANG CHAR 1   0   Transaction in Logistics Invoice Verification  
170 RET_DUE_PROP RET_DUE_PROP DATUM DATS 8   0   Due Date for Retention (Default)  
171 XCONTRACT XSRMCONTRACT XFELD CHAR 1   0   Contract Selection with SRM Contract Number  
172 XTM XZUORD XFELD CHAR 1   0   Checkbox: Allocations  
173 XREF3 XREF3 CHAR20 CHAR 20   0   Reference key for line item  
174 ASSIGN_STATUS WRF_MRM_ASSIGN_STATUS WRF_MRM_ASSIGN_STATUS CHAR 1   0   Is the invoice in the assignment test process?  
175 ASSIGN_NEXT_DATE WRF_MRM_ASSIGN_NEXT_DATE   DATS 8   0   Date of Next Assignment Test  
176 ASSIGN_END_DATE WRF_MRM_ASSIGN_END_DATE   DATS 8   0   End Date of Assignment Test Period  
177 PREPAY_STATUS WRF_PREPAY_STATUS WRF_PREPAY_STATUS CHAR 1   0   Prepayment Status  
178 PREPAY_AWKEY WRF_PREPAY_AWKEY AWKEY CHAR 20   0   Invoice Document Number Created for Prepayment  
179 PREPAY_AREWR WRF_PREPAY_AREWR WERT7 CURR 13   2   Clearing Value to Prepayment Clearing Account in LC  
180 PREPAY_HWAER WRF_PREPAY_HWAER WAERS CUKY 5   0   Local Currency *
181 PREPAY_AREWW WRF_PREPAY_AREWW WERT7 CURR 13   2   Clearing Value to Prepayment Clearing Account in TC  
182 PREPAY_WAERS WRF_PREPAY_WAERS WAERS CUKY 5   0   Document Currency *
183 PREPAY_KURSF WRF_PREPAY_KURSF KURSF DEC 9   5   Exchange Rate of Prepayment Document  
184 PREPAY_KUFIX WRF_PREPAY_KUFIX XFELD CHAR 1   0   Flag: Fixed Exchange Rate in Prepayment Document  
185 PREPAY_LIFNR WRF_PREPAY_LIFNR LIFNR CHAR 10   0   Vendor Account Number in Prepayment Document *
186 .INCLUDE       0   0   Invoice Document Header for Invoice Verification Processing  
187 LNAME1 NAME1_GP NAME CHAR 35   0   Name 1  
188 XRKUE XRKUE XFELD CHAR 1   0   Invoice Automatically Reduced  
189 TAKZPB TAKZPB WERT7 CURR 13   2   Absolute positive upper acceptance limit  
190 TAKZPP TAKZPP PRZ22 DEC 4   2   Percentage positive upper acceptance limit  
191 TAKZNB TAKZNB WERTV7 CURR 13   2   Negative small difference  
192 TAKZNP TAKZNP PRZ22 DEC 4   2   Percentage negative lower acceptance limit  
193 TRKPB TRKPB WERT7 CURR 13   2   Autom. invoice reduction: absolute upper limit  
194 TRKPP TRKPP PRZ22 DEC 4   2   Autom. invoice reduction: percentage upper limit  
195 XLOCK XFELD XFELD CHAR 1   0   Checkbox  
196 XCHANGE MARKE CHAR1 CHAR 1   0   Select  
197 XKPFCHG MARKE CHAR1 CHAR 1   0   Select  
198 XKONCHG MARKE CHAR1 CHAR 1   0   Select  
199 XPOSCHG MARKE CHAR1 CHAR 1   0   Select  
200 XERL KZERL XFELD CHAR 1   0   Indicates that Invoice Verification has been completed  
201 XERLALT KZERL XFELD CHAR 1   0   Indicates that Invoice Verification has been completed  
202 REPARTALT REPART REPART CHAR 1   0   Indicator: Invoice Verification Type  
203 RBSTATALT RBSTAT RBSTAT CHAR 1   0   Invoice document status  
204 ANZRPVALT ANZRPV NUMC3 NUMC 3   0   No. of invoice verification attempts  
205 MARKE MARKE CHAR1 CHAR 1   0   Select  
206 SKTODAT RM08_SKDAT DATUM DATS 8   0   Latest date when full cash discount still possible  
207 XRECHC XRECHC XFELD CHAR 1   0   Indicator: post invoice  
208 XMANRK XMANRK XFELD CHAR 1   0   Indicator for manually reduced invoices  
209 XUNFEH XUNFEH XFELD CHAR 1   0   Indicator for unclarified errors  
210 AMPEL ICONNAME ICONNAME CHAR 30   0   Name of an Icon  
211 AGGR_LIST_VERSION MRM_ITEM_LIST_VERSION MRM_ITEM_LIST_VERSION CHAR 30   0   Invoice Items Layout  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RBINVPRNT BLART T003 BLART    
2 RBINVPRNT BRNCH J_1BBRANCH BRANCH KEY 1 CN
3 RBINVPRNT BUKRS T001 BUKRS    
4 RBINVPRNT ERFPR T169H ERFPR    
5 RBINVPRNT HBKID T012 HBKID    
6 RBINVPRNT J_1BNFTYPE J_1BAA NFTYPE KEY 1 CN
7 RBINVPRNT LANDL T005 LAND1    
8 RBINVPRNT LIFNR LFA1 LIFNR    
9 RBINVPRNT LZBKZ T015L LZBKZ    
10 RBINVPRNT MANDT T000 MANDT    
11 RBINVPRNT MWSKZ1 TMRM007A MWSKZ    
12 RBINVPRNT MWSKZ_BNK T007A MWSKZ    
13 RBINVPRNT QSSKZ T059Q QSSKZ    
14 RBINVPRNT SECCO SECCODE SECCODE KEY 1 CN
15 RBINVPRNT TCODE TSTC TCODE    
16 RBINVPRNT WAERS TCURC WAERS    
17 RBINVPRNT ZLSCH T042Z ZLSCH REF C CN
18 RBINVPRNT ZLSPR T008 ZAHLS REF C CN
History
Last changed by/on SAP  20130603 
SAP Release Created in