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
⤷ 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 |