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