SAP ABAP Table RFZUA_SORT_NO_DATE_BSID (Sort Fields for Automatic Postprocessing and BSID Entry)
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FS-CML-AC-RPM (Application Component) Receivables/Payment Management
     FVVCL_PAYMENT (Package) Payment Transactions for Consumer Loans
Basic Data
Table Category INTTAB    Structure 
Structure RFZUA_SORT_NO_DATE_BSID   Table Relationship Diagram
Short Description Sort Fields for Automatic Postprocessing and BSID Entry    
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   Sort Fields for Automatic Payment Clearing Without Date  
2 XBUKRS BUKRS BUKRS CHAR 4   0   Company Code *
3 XSZKEY VVSZKEY VVSZKEY NUMC 2   0   Indicator for Control of Incoming Payment Distribution *
4 XVALSZKEY CHAR13 CHAR13 CHAR 13   0   Character field 13 digits  
5 XKUNNR KUNNR KUNNR CHAR 10   0   Customer Number *
6 XWAERS WAERS WAERS CUKY 5   0   Currency Key *
7 .INCLUDE       0   0   Accounting: Secondary Index for Customers  
8 MANDT MANDT MANDT CLNT 3   0   Client *
9 BUKRS BUKRS BUKRS CHAR 4   0   Company Code KNB1
10 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
11 UMSKS UMSKS UMSKS CHAR 1   0   Special G/L Transaction Type  
12 UMSKZ UMSKZ UMSKZ CHAR 1   0   Special G/L Indicator T074U
13 AUGDT AUGDT DATUM DATS 8   0   Clearing Date  
14 AUGBL AUGBL BELNR CHAR 10   0   Document Number of the Clearing Document  
15 ZUONR DZUONR ZUONR CHAR 18   0   Assignment number  
16 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
17 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
18 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
19 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
20 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
21 CPUDT CPUDT DATUM DATS 8   0   Accounting document entry date  
22 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
23 XBLNR XBLNR1 XBLNR1 CHAR 16   0   Reference Document Number  
24 BLART BLART BLART CHAR 2   0   Document type T003
25 MONAT MONAT MONAT NUMC 2   0   Fiscal period  
26 BSCHL BSCHL BSCHL CHAR 2   0   Posting Key TBSL
27 ZUMSK DZUMSK UMSKZ CHAR 1   0   Target Special G/L Indicator *
28 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
29 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
30 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code T007A
31 DMBTR DMBTR WERT7 CURR 13   2   Amount in local currency  
32 WRBTR WRBTR WERT7 CURR 13   2   Amount in document currency  
33 MWSTS MWSTS WERT7 CURR 13   2   Tax Amount in Local Currency  
34 WMWST WMWST WERT7 CURR 13   2   Tax amount in document currency  
35 BDIFF BDIFF WRTV7 CURR 13   2   Valuation Difference  
36 BDIF2 BDIF2 WRTV7 CURR 13   2   Valuation Difference for the Second Local Currency  
37 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
38 PROJN PROJN PROJN CHAR 16   0   Old: Project number : No longer used --> PS_POSNR  
39 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
40 ANLN1 ANLN1 ANLN1 CHAR 12   0   Main Asset Number *
41 ANLN2 ANLN2 ANLN2 CHAR 4   0   Asset Subnumber *
42 SAKNR SAKNR SAKNR CHAR 10   0   G/L Account Number *
43 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account *
44 FKONT FIPLS FIPLS NUMC 3   0   Financial Budget Item  
45 FILKD FILKD MAXKK CHAR 10   0   Account Number of the Branch  
46 ZFBDT DZFBDT DATUM DATS 8   0   Baseline date for due date calculation  
47 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
48 ZBD1T DZBD1T ZBDXT DEC 3   0   Cash discount days 1  
49 ZBD2T DZBD2T ZBDXT DEC 3   0   Cash discount days 2  
50 ZBD3T DZBD3T ZBDXT DEC 3   0   Net Payment Terms Period  
51 ZBD1P DZBD1P PRZ23 DEC 5   3   Cash discount percentage 1  
52 ZBD2P DZBD2P PRZ23 DEC 5   3   Cash Discount Percentage 2  
53 SKFBT SKFBT WERT7 CURR 13   2   Amount Eligible for Cash Discount in Document Currency  
54 SKNTO SKNTO WERT7 CURR 13   2   Cash discount amount in local currency  
55 WSKTO WSKTO WERT7 CURR 13   2   Cash Discount Amount in Document Currency  
56 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method T042Z
57 ZLSPR DZLSPR ZAHLS CHAR 1   0   Payment Block Key T008
58 ZBFIX DZBFIX ZBFIX CHAR 1   0   Fixed Payment Terms  
59 HBKID HBKID HBKID CHAR 5   0   Short key for a house bank T012
60 BVTYP BVTYP BVTYP CHAR 4   0   Partner bank type  
61 REBZG REBZG BELNR CHAR 10   0   Number of the Invoice the Transaction Belongs to  
62 REBZJ REBZJ GJAHR NUMC 4   0   Fiscal Year of the Relevant Invoice (for Credit Memo)  
63 REBZZ REBZZ BUZEI NUMC 3   0   Line Item in the Relevant Invoice  
64 SAMNR SAMNR SAMNR NUMC 8   0   Invoice List Number  
65 ANFBN ANFBN BELNR CHAR 10   0   Document Number of the Bill of Exchange Payment Request  
66 ANFBJ ANFBJ GJAHR NUMC 4   0   Fiscal Year of the Bill of Exchange Payment Request Document  
67 ANFBU ANFBU BUKRS CHAR 4   0   Company Code in Which Bill of Exch.Payment Request Is Posted T001
68 ANFAE ANFAE DATUM DATS 8   0   Bill of Exchange Payment Request Due Date  
69 MANSP MANSP MANSP CHAR 1   0   Dunning block T040S
70 MSCHL MSCHL MSCHL CHAR 1   0   Dunning key T040
71 MADAT MADAT DATUM DATS 8   0   Date of Last Dunning Notice  
72 MANST MAHNS_D MAHNS NUMC 1   0   Dunning Level  
73 MABER MABER MABER CHAR 2   0   Dunning Area *
74 XNETB XNETB XFELD CHAR 1   0   Indicator: Document posted net ?  
75 XANET XANET XFELD CHAR 1   0   Indicator: Down Payment in Net Procedure?  
76 XCPDD XCPDD XFELD CHAR 1   0   Indicator: Address and Bank Data Set Individually  
77 XINVE XINVE XFELD CHAR 1   0   Indicator: Capital Goods Affected?  
78 XZAHL XZAHL XFELD CHAR 1   0   Indicator: Is Posting Key Used in a Payment Transaction?  
79 MWSK1 MWSKX MWSKZ CHAR 2   0   Tax Code for Distribution *
80 DMBT1 DMBTX WRTV7 CURR 13   2   Amount in Local Currency for Tax Distribution  
81 WRBT1 WRBTX WRTV7 CURR 13   2   Amount in foreign currency for tax breakdown  
82 MWSK2 MWSKX MWSKZ CHAR 2   0   Tax Code for Distribution *
83 DMBT2 DMBTX WRTV7 CURR 13   2   Amount in Local Currency for Tax Distribution  
84 WRBT2 WRBTX WRTV7 CURR 13   2   Amount in foreign currency for tax breakdown  
85 MWSK3 MWSKX MWSKZ CHAR 2   0   Tax Code for Distribution *
86 DMBT3 DMBTX WRTV7 CURR 13   2   Amount in Local Currency for Tax Distribution  
87 WRBT3 WRBTX WRTV7 CURR 13   2   Amount in foreign currency for tax breakdown  
88 BSTAT BSTAT_D BSTAT CHAR 1   0   Document Status  
89 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner T880
90 VBELN VBELN_VF VBELN CHAR 10   0   Billing document *
91 REBZT REBZT REBZT CHAR 1   0   Follow-On Document Type  
92 INFAE INFAE CHAR08 CHAR 8   0   Inverted Date for Net Due Date  
93 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
94 EGBLD EGBLD LAND1 CHAR 3   0   Country of Destination for Delivery of Goods T005
95 EGLLD EGLLD LAND1 CHAR 3   0   Supplying Country for Delivery of Goods T005
96 RSTGR RSTGR RSTGR CHAR 3   0   Reason Code for Payments T053R
97 XNOZA XNOZA XFELD CHAR 1   0   Indicator: Account is not counted  
98 VERTT RANTYP RANTYP CHAR 1   0   Contract Type  
99 VERTN RANL RANL CHAR 13   0   Contract Number  
100 VBEWA SBEWART SBEWART CHAR 4   0   Flow Type *
101 WVERW WVERW WVERW CHAR 1   0   Bill of Exchange Usage Type  
102 PROJK PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
103 FIPOS FIPOS FIPOS CHAR 14   0   Commitment Item *
104 NPLNR NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment *
105 AUFPL CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
106 APLZL CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
107 XEGDR XEGDR XFELD CHAR 1   0   Indicator: Triangular deal within the EU ?  
108 DMBE2 DMBE2 WERT7 CURR 13   2   Amount in Second Local Currency  
109 DMBE3 DMBE3 WERT7 CURR 13   2   Amount in Third Local Currency  
110 DMB21 DMB2X WRTV7 CURR 13   2   Amount in Second Local Currency for Tax Breakdown  
111 DMB22 DMB2X WRTV7 CURR 13   2   Amount in Second Local Currency for Tax Breakdown  
112 DMB23 DMB2X WRTV7 CURR 13   2   Amount in Second Local Currency for Tax Breakdown  
113 DMB31 DMB3X WRTV7 CURR 13   2   Amount in Third Local Currency for Tax Breakdown  
114 DMB32 DMB3X WRTV7 CURR 13   2   Amount in Third Local Currency for Tax Breakdown  
115 DMB33 DMB3X WRTV7 CURR 13   2   Amount in Third Local Currency for Tax Breakdown  
116 BDIF3 BDIF3 WRTV7 CURR 13   2   Valuation Difference for the Third Local Currency  
117 XRAGL XRAGL XFELD CHAR 1   0   Indicator: Clearing was Reversed  
118 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement T042F
119 XSTOV XSTOV XFELD CHAR 1   0   Indicator: Document is flagged for reversal  
120 MWST2 MWST2 WERT7 CURR 13   2   Tax Amount in Second Local Currency  
121 MWST3 MWST3 WERT7 CURR 13   2   Tax Amount in Third Local Currency  
122 SKNT2 SKNT2 WERT7 CURR 13   2   Cash Discount Amount in Second Local Currency  
123 SKNT3 SKNT3 WERT7 CURR 13   2   Cash Discount Amount in Third Local Currency  
124 XREF1 XREF1 CHAR12 CHAR 12   0   Business partner reference key  
125 XREF2 XREF2 CHAR12 CHAR 12   0   Business partner reference key  
126 XARCH XARCH XFELD CHAR 1   0   Indicator: Document already archived ?  
127 PSWSL PSWSL WAERS CUKY 5   0   Update Currency for General Ledger Transaction Figures TCURC
128 PSWBT PSWBT WERT7 CURR 13   2   Amount for Updating in General Ledger  
129 LZBKZ LZBKZ LZBKZ CHAR 3   0   State central bank indicator T015L
130 LANDL LANDL LAND1 CHAR 3   0   Supplying Country T005
131 IMKEY IMKEY IMKEY CHAR 8   0   Internal Key for Real Estate Object  
132 VBEL2 VBELN_VA VBELN CHAR 10   0   Sales Document *
133 VPOS2 NUM06 NUM06 NUMC 6   0   Numeric field: Length 6  
134 POSN2 POSNR_VA POSNR NUMC 6   0   Sales Document Item *
135 ETEN2 ETENR ETENR NUMC 4   0   Schedule line *
136 FISTL FISTL FISTL CHAR 16   0   Funds Center *
137 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund *
138 DABRZ DABRBEZ DDAT DATS 8   0   Reference date for settlement  
139 XNEGP XNEGP XFELD CHAR 1   0   Indicator: Negative posting  
140 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
141 RFZEI RFZEI_CC NUM03 NUMC 3   0   Payment Card Item  
142 KKBER KKBER KKBER CHAR 4   0   Credit control area T014
143 EMPFB EMPFB MAXKK CHAR 10   0   Payee/Payer  
144 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
145 XREF3 XREF3 CHAR20 CHAR 20   0   Reference key for line item  
146 QSSKZ QSSKZ QSSKZ CHAR 2   0   Withholding Tax Code T059Q
147 ZINKZ DZINKZ ZINKZ CHAR 2   0   Exempted from Interest Calculation  
148 DTWS1 DTAT16 DTWSX NUMC 2   0   Instruction key 1 *
149 DTWS2 DTAT17 DTWSX NUMC 2   0   Instruction key 2 *
150 DTWS3 DTAT18 DTWSX NUMC 2   0   Instruction key 3 *
151 DTWS4 DTAT19 DTWSX NUMC 2   0   Instruction key 4 *
152 XPYPR XPYPR XFELD CHAR 1   0   Indicator: Items from Payment Program Blocked  
153 KIDNO KIDNO CHAR30 CHAR 30   0   Payment Reference  
154 ABSBT ABSBT WERT7 CURR 13   2   Credit Management: Hedged Amount  
155 CCBTC CCBTC CCBTC CHAR 10   0   Payment cards: Settlement run  
156 PYCUR PYCUR WAERS CUKY 5   0   Currency for Automatic Payment TCURC
157 PYAMT PYAMT WERT7 CURR 13   2   Amount in Payment Currency  
158 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place J_1BBRANCH
159 SECCO SECCO SECCO CHAR 4   0   Section Code SECCODE
160 CESSION_KZ CESSION_KZ CESSION_KZ CHAR 2   0   Accounts Receivable Pledging Indicator TCESSION
161 PPDIFF PPDIFF WRTV7 CURR 13   2   Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)  
162 PPDIF2 PPDIF2 WRTV7 CURR 13   2   Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)  
163 PPDIF3 PPDIF3 WRTV7 CURR 13   2   Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)  
164 KBLNR KBLNR_FI KBLNR CHAR 10   0   Document number for earmarked funds *
165 KBLPOS KBLPOS KBLPOS NUMC 3   0   Earmarked Funds: Document Item *
166 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
167 GMVKZ FM_GMVKZ FM_GMVKZ CHAR 1   0   Item is in Execution  
168 SRTYPE FM_SRTYPE FM_SRTYPE CHAR 2   0   Type of Additional Receivable  
169 LOTKZ PSO_LOTKZ LOTKZ CHAR 10   0   Lot Number for Requests  
170 FKBER FKBER FKBER CHAR 16   0   Functional Area *
171 INTRENO VVINTRENO VVINTRENO CHAR 13   0   Internal Real Estate Master Data Code  
172 PPRCT PPRCTR PRCTR CHAR 10   0   Partner Profit Center *
173 BUZID BUZID CHAR1 CHAR 1   0   Identification of the Line Item  
174 AUGGJ AUGGJ GJAHR NUMC 4   0   Fiscal Year of Clearing Document  
175 HKTID HKTID HKTID CHAR 5   0   ID for account details *
176 BUDGET_PD FM_BUDGET_PERIOD FM_BUDGET_PERIOD CHAR 10   0   FM: Budget Period *
177 PAYS_PROV COM_WEC_PAYMENT_SRV_PROVIDER COM_WEC_PAYMENT_SRV_PROVIDER CHAR 4   0   Payment Service Provider *
178 PAYS_TRAN FPS_TRANSACTION COM_WEC_PSP_TRANSACTION_ID CHAR 35   0   Payment Reference of Payment Service Provider  
179 MNDID SEPA_MNDID ID035 CHAR 35   0   Unique Referene to Mandate per Payment Recipient  
180 .INCLU--AP       0   0   IS-PS: Data appendix of open items customers  
181 KONTT KONTT_FI KONTT_FI CHAR 2   0   Account Assignment Category for Industry Solution  
182 KONTL KONTL_FI CHAR50 CHAR 50   0   Acct assignment string for industry-specific acct assignmnts  
183 UEBGDAT UEBGDAT DATUM DATS 8   0   Transfer date of an item to legal dunning proceeding  
184 .INCLU--AP       0   0   Joint Venture Fields  
185 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture T8JV
186 EGRUP JV_EGROUP JV_EGROUP CHAR 3   0   Equity group T8JF
187 BTYPE JV_BILIND JV_BILIND CHAR 2   0   Payroll Type T8JA
188 .INCLU--AP       0   0   Append zur Mandatsverwaltung BSID  
189 .INCLUDE       0   0   Append Struktur für die Mandatsnummer  
190 PROPMANO REHORECNNRM RECNNR CHAR 13   0   Mandate, Mandate-Opening Contract  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RFZUA_SORT_NO_DATE_BSID ANFBU T001 BUKRS REF C CN
2 RFZUA_SORT_NO_DATE_BSID AUFNR AUFK AUFNR REF C CN
3 RFZUA_SORT_NO_DATE_BSID BLART T003 BLART REF 1 CN
4 RFZUA_SORT_NO_DATE_BSID BSCHL TBSL BSCHL REF C CN
5 RFZUA_SORT_NO_DATE_BSID BTYPE T8JA BILIND REF C CN
6 RFZUA_SORT_NO_DATE_BSID BUKRS KNB1 BUKRS KEY 1 CN
7 RFZUA_SORT_NO_DATE_BSID BUPLA J_1BBRANCH BRANCH KEY 1 CN
8 RFZUA_SORT_NO_DATE_BSID CESSION_KZ TCESSION CESSION_KZ    
9 RFZUA_SORT_NO_DATE_BSID EGBLD T005 LAND1 REF C CN
10 RFZUA_SORT_NO_DATE_BSID EGLLD T005 LAND1 REF C CN
11 RFZUA_SORT_NO_DATE_BSID EGRUP T8JF EGRUP REF C CN
12 RFZUA_SORT_NO_DATE_BSID GSBER TGSB GSBER REF C CN
13 RFZUA_SORT_NO_DATE_BSID HBKID T012 HBKID REF C CN
14 RFZUA_SORT_NO_DATE_BSID KKBER T014 KKBER REF 1 CN
15 RFZUA_SORT_NO_DATE_BSID KUNNR KNA1 KUNNR KEY 1 CN
16 RFZUA_SORT_NO_DATE_BSID LANDL T005 LAND1 REF C CN
17 RFZUA_SORT_NO_DATE_BSID LZBKZ T015L LZBKZ REF C CN
18 RFZUA_SORT_NO_DATE_BSID MANSP T040S MANSP REF C CN
19 RFZUA_SORT_NO_DATE_BSID MSCHL T040 MSCHL REF C CN
20 RFZUA_SORT_NO_DATE_BSID MWSKZ T007A MWSKZ REF C CN
21 RFZUA_SORT_NO_DATE_BSID PSWSL TCURC WAERS    
22 RFZUA_SORT_NO_DATE_BSID PYCUR TCURC WAERS 1 CN
23 RFZUA_SORT_NO_DATE_BSID QSSKZ T059Q QSSKZ REF C CN
24 RFZUA_SORT_NO_DATE_BSID RSTGR T053R RSTGR REF C CN
25 RFZUA_SORT_NO_DATE_BSID SECCO SECCODE SECCODE KEY 1 CN
26 RFZUA_SORT_NO_DATE_BSID UMSKZ T074U UMSKZ REF C CN
27 RFZUA_SORT_NO_DATE_BSID UZAWE T042F UZAWE REF C CN
28 RFZUA_SORT_NO_DATE_BSID VBUND T880 RCOMP REF C CN
29 RFZUA_SORT_NO_DATE_BSID VNAME T8JV VNAME REF C CN
30 RFZUA_SORT_NO_DATE_BSID WAERS TCURC WAERS REF 1 CN
31 RFZUA_SORT_NO_DATE_BSID ZLSCH T042Z ZLSCH REF C CN
32 RFZUA_SORT_NO_DATE_BSID ZLSPR T008 ZAHLS REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 600