SAP ABAP Table FAGLPOSBW (Fields for LI Extractor: New General Ledger Accounting)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ FI-GL (Application Component) General Ledger Accounting
⤷ GBIW_ERP_LI (Package) Line Item Extractors for General Ledger ERP
⤷ FI-GL (Application Component) General Ledger Accounting
⤷ GBIW_ERP_LI (Package) Line Item Extractors for General Ledger ERP
Basic Data
Table Category | INTTAB | Structure |
Structure | FAGLPOSBW | Table Relationship Diagram |
Short Description | Fields for LI Extractor: New General Ledger Accounting |
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 | Core Fields for Reading Data of Line Items in New GL | |||||
2 | ANLN1 | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
3 | ANLN2 | ANLN2_4 | ANLN2_4 | CHAR | 4 | 0 | New asset subnumber, 4 characters | ||
4 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
5 | AUGBL | AUGBL | BELNR | CHAR | 10 | 0 | Document Number of the Clearing Document | ||
6 | AUGDT | AUGDT | DATUM | DATS | 8 | 0 | Clearing Date | ||
7 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
8 | BLART | BLART | BLART | CHAR | 2 | 0 | Document type | T003 | |
9 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
10 | BSCHL | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
11 | BSTAT | BSTAT_D | BSTAT | CHAR | 1 | 0 | Document Status | ||
12 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
13 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
14 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
15 | BWWRT | BWWRT_X8 | WRTV8 | CURR | 15 | 2 | Valuated Amount in Local Currency | ||
16 | BWWR2 | BWWR2_X8 | WRTV8 | CURR | 15 | 2 | Amount Valuated in Local Currency 2 | ||
17 | BWWR3 | BWWR3_X8 | WRTV8 | CURR | 15 | 2 | Amount Valuated in Local Currency 3 | ||
18 | DMSHB | DMSHB_X8 | WRTV8 | CURR | 15 | 2 | Amount in Local Currency with +/- Signs | ||
19 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | TCURC | |
20 | DMBE2 | DMBE2_X8 | WRTV8 | CURR | 15 | 2 | Amount in Second Local Currency | ||
21 | HWAE2 | HWAE2 | WAERS | CUKY | 5 | 0 | Currency Key of Second Local Currency | * | |
22 | DMBE3 | DMBE3_X8 | WRTV8 | CURR | 15 | 2 | Amount in Third Local Currency | ||
23 | HWAE3 | HWAE3 | WAERS | CUKY | 5 | 0 | Currency Key of Third Local Currency | * | |
24 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
25 | EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
26 | ETEN2 | ETENR | ETENR | NUMC | 4 | 0 | Schedule line | * | |
27 | FAEDT | FAEDT_FPOS | DATUM | DATS | 8 | 0 | Net Due Date | ||
28 | FILKD | FILKD | MAXKK | CHAR | 10 | 0 | Account Number of the Branch | ||
29 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
30 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
31 | JAMON | JAMON_XPO | JAMON_XPO | CHAR | 7 | 0 | Fiscal Year/Posting Period from Posting Date | ||
32 | KOART | KOART | KOART | CHAR | 1 | 0 | Account type | ||
33 | KONTO | KTONR_AV | KTONR | CHAR | 10 | 0 | Account Number | ||
34 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | CSKS | |
35 | MABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | T047M | |
36 | MADAT | MADAT | DATUM | DATS | 8 | 0 | Date of Last Dunning Notice | ||
37 | MANSP | MANSP | MANSP | CHAR | 1 | 0 | Dunning block | T040S | |
38 | MANST | MAHNS_D | MAHNS | NUMC | 1 | 0 | Dunning Level | ||
39 | MONAT | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
40 | MSCHL | MSCHL | MSCHL | CHAR | 1 | 0 | Dunning key | T040 | |
41 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
42 | POSN2 | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | * | |
43 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
44 | QBSHB | QBSHB_X8 | WRTV8 | CURR | 15 | 2 | Withholding Tax Amount in Document Currency | ||
45 | QSFBT | QSFBT_X8 | WRTV8 | CURR | 15 | 2 | Withholding Tax Exempt Amount in Document Currency | ||
46 | QSSHB | QSSHB_X8 | WRTV8 | CURR | 15 | 2 | Withholding Tax Base Amount in Document Currency | ||
47 | REBZG | REBZG | BELNR | CHAR | 10 | 0 | Number of the Invoice the Transaction Belongs to | ||
48 | SAMNR | SAMNR | SAMNR | NUMC | 8 | 0 | Invoice List Number | ||
49 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
50 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
51 | SKFBT | SKFBT_X8 | WRTV8 | CURR | 15 | 2 | Amount Eligible for Cash Discount in Document Currency | ||
52 | WSKTO | WSKTO_X8 | WRTV8 | CURR | 15 | 2 | Cash Discount Amount in Document Currency | ||
53 | SKNTO | SKNTO_X8 | WRTV8 | CURR | 15 | 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 | T074U | |
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 | T880 | |
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 | T001W | |
68 | WRSHB | WRSHB_X8 | WRTV8 | CURR | 15 | 2 | Amount in Document Currency (Foreign Currency) | ||
69 | WAERS | WAER_DOC | WAERS | CUKY | 5 | 0 | Document Currency (Key) | TCURC | |
70 | WVERW | WVERW | WVERW | CHAR | 1 | 0 | Bill of Exchange Usage Type | ||
71 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
72 | XSTRP | XSTRP | XFELD | CHAR | 1 | 0 | Indicator: Disputed item? | ||
73 | XZAHL | XZAHL | XFELD | CHAR | 1 | 0 | Indicator: Is Posting Key Used in a Payment Transaction? | ||
74 | ZALDT | DZALDT | DATUM | DATS | 8 | 0 | Probable Payment Date (Cash Discount 1 Due) | ||
75 | ZBD1P | DZBD1P | PRZ23 | DEC | 5 | 3 | Cash discount percentage 1 | ||
76 | ZBD1T | DZBD1T | ZBDXT | DEC | 3 | 0 | Cash discount days 1 | ||
77 | ZBD2P | DZBD2P | PRZ23 | DEC | 5 | 3 | Cash Discount Percentage 2 | ||
78 | ZBD2T | DZBD2T | ZBDXT | DEC | 3 | 0 | Cash discount days 2 | ||
79 | ZBD3T | DZBD3T | ZBDXT | DEC | 3 | 0 | Net Payment Terms Period | ||
80 | ZFBDT | DZFBDT | DATUM | DATS | 8 | 0 | Baseline date for due date calculation | ||
81 | ZINSZ | DZINSZ | WRTV8 | CURR | 15 | 2 | Interest Calculation Numerator (Days in Arrears * Amount) | ||
82 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | T042Z | |
83 | ZLSPR | DZLSPR | ZAHLS | CHAR | 1 | 0 | Payment Block Key | T008 | |
84 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
85 | ZUONR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
86 | XREF1 | XREF1 | CHAR12 | CHAR | 12 | 0 | Business partner reference key | ||
87 | XREF2 | XREF2 | CHAR12 | CHAR | 12 | 0 | Business partner reference key | ||
88 | XARCH | XARCH | XFELD | CHAR | 1 | 0 | Indicator: Document already archived ? | ||
89 | RSTGR | RSTGR | RSTGR | CHAR | 3 | 0 | Reason Code for Payments | T053R | |
90 | ASKTO | ASKTO_X8 | WRTV8 | CURR | 15 | 2 | Current Cash Discount Amount in Document Currency | ||
91 | KURSE | KURSE | KURSF | DEC | 9 | 5 | Effective Exchange Rate in the Line Item | ||
92 | REBZT | REBZT | REBZT | CHAR | 1 | 0 | Follow-On Document Type | ||
93 | PSWSL | PSWSL | WAERS | CUKY | 5 | 0 | Update Currency for General Ledger Transaction Figures | TCURC | |
94 | PSWBT | PSWBT_X8 | WERT8 | CURR | 15 | 2 | Amount for General Ledger Update (Absolute) | ||
95 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
96 | XNEGP | XNEGP | XFELD | CHAR | 1 | 0 | Indicator: Negative posting | ||
97 | ZBFIX | DZBFIX | ZBFIX | CHAR | 1 | 0 | Fixed Payment Terms | ||
98 | RFZEI | RFZEI_CC | NUM03 | NUMC | 3 | 0 | Payment Card Item | ||
99 | CCBTC | CCBTC | CCBTC | CHAR | 10 | 0 | Payment cards: Settlement run | ||
100 | KKBER | KKBER | KKBER | CHAR | 4 | 0 | Credit control area | T014 | |
101 | XREF3 | XREF3 | CHAR20 | CHAR | 20 | 0 | Reference key for line item | ||
102 | DTWS1 | DTAT16 | DTWSX | NUMC | 2 | 0 | Instruction key 1 | * | |
103 | DTWS2 | DTAT17 | DTWSX | NUMC | 2 | 0 | Instruction key 2 | * | |
104 | DTWS3 | DTAT18 | DTWSX | NUMC | 2 | 0 | Instruction key 3 | * | |
105 | DTWS4 | DTAT19 | DTWSX | NUMC | 2 | 0 | Instruction key 4 | * | |
106 | ABSBT | ABSBT_X8 | WERT8 | CURR | 15 | 2 | Credit Management: Hedged Amount (Absolute) | ||
107 | KKBWR | KKBWR | WAERS | CUKY | 5 | 0 | Currency of Credit Control Area | * | |
108 | PROJK | PROJK_EXT | CHAR24 | CHAR | 24 | 0 | Individual Structural Element (WBS Element) in Ext. Format | ||
109 | XPYPR | XPYPR | XFELD | CHAR | 1 | 0 | Indicator: Items from Payment Program Blocked | ||
110 | KIDNO | KIDNO | CHAR30 | CHAR | 30 | 0 | Payment Reference | ||
111 | XAUGP | XAUGP | XFELD | CHAR | 1 | 0 | Indicator: Item has been cleared? | ||
112 | BUPLA | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | Business Place | * | |
113 | SECCO | SECCO | SECCO | CHAR | 4 | 0 | Section Code | * | |
114 | GKART | GKART | GKART | CHAR | 1 | 0 | Offsetting Account Type | ||
115 | GKONT | GKONT | GKONT | CHAR | 10 | 0 | Offsetting Account Number | ||
116 | PYCUR | PYCUR | WAERS | CUKY | 5 | 0 | Currency for Automatic Payment | * | |
117 | PYAMT | PYAMT_X8 | WERT8 | CURR | 15 | 2 | Amount in Automatic Payment Currency (Absolute) | ||
118 | PYORD | PYORD | PYORD | CHAR | 10 | 0 | Payment Order | ||
119 | XRAGL | XRAGL | XFELD | CHAR | 1 | 0 | Indicator: Clearing was Reversed | ||
120 | CESSION_KZ | CESSION_KZ | CESSION_KZ | CHAR | 2 | 0 | Accounts Receivable Pledging Indicator | TCESSION | |
121 | BUZID | BUZID | CHAR1 | CHAR | 1 | 0 | Identification of the Line Item | ||
122 | AUGGJ | AUGGJ | GJAHR | NUMC | 4 | 0 | Fiscal Year of Clearing Document | ||
123 | AGZEI | AGZEI | AGZEI | DEC | 5 | 0 | Clearing Item | ||
124 | LONGNUM | /SAPPSPRO/LONGNUM | /SAPPSPRO/LONGNUM | CHAR | 40 | 0 | Smart Number | ||
125 | AWSYS | LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | TBDLS | |
126 | AWTYP | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | TTYP | |
127 | BDIFF | BDIFF | WRTV7 | CURR | 13 | 2 | Valuation Difference | ||
128 | BDIF2 | BDIF2 | WRTV7 | CURR | 13 | 2 | Valuation Difference for the Second Local Currency | ||
129 | BDIF3 | BDIF3 | WRTV7 | CURR | 13 | 2 | Valuation Difference for the Third Local Currency | ||
130 | BEWAR | RMVCT | RMVCT | CHAR | 3 | 0 | Transaction type | T856 | |
131 | DABRZ | DABRBEZ | DDAT | DATS | 8 | 0 | Reference date for settlement | ||
132 | DMBTR | DMBTR_X8 | WRTV8 | CURR | 15 | 2 | Amount in Local Currency | ||
133 | DOCNR | BELNR_D_POS | BELNR | CHAR | 10 | 0 | Document Number of a General Ledger Document | ||
134 | DOCLN | DOCLN6_POS | DOCLN6 | CHAR | 6 | 0 | Six-Character Posting Item for Ledger | ||
135 | FKBER | FKBER_SHORT | FKBER_SHORT | CHAR | 4 | 0 | Functional Area | ||
136 | FKBER_LONG | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | TFKB | |
137 | GLVOR | GLVOR | CHAR4 | CHAR | 4 | 0 | Business Transaction | ||
138 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
139 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
140 | KSTAR | KSTAR | KSTAR | CHAR | 10 | 0 | Cost Element | CSKB | |
141 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
142 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
143 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
144 | MENGE | MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
145 | PARGB | PARGB | GSBER | CHAR | 4 | 0 | Trading partner's business area | TGSB | |
146 | PERIO | JAHRPER | JAHRPER | NUMC | 7 | 0 | Period/year | ||
147 | PFKBER | SFKBER | FKBER | CHAR | 16 | 0 | Partner Functional Area | TFKB | |
148 | PKOSTL | PKOSTL | KOSTL | CHAR | 10 | 0 | Partner cost center | CSKS | |
149 | POPER | POPER | POPER | NUMC | 3 | 0 | Posting period | ||
150 | PPRCT | PPRCTR | PRCTR | CHAR | 10 | 0 | Partner Profit Center | CEPC | |
151 | PSEGMENT | FB_PSEGMENT | FB_SEGMENT | CHAR | 10 | 0 | Partner Segment for Segmental Reporting | FAGL_SEGM | |
152 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
153 | RLDNR | RLDNR | RLDNR | CHAR | 2 | 0 | Ledger | V_FAGL_T881_DBAL | |
154 | RYEAR | GJAHR_POS | GJAHR | NUMC | 4 | 0 | General Ledger Fiscal Year | ||
155 | SAKNR | SAKNR | SAKNR | CHAR | 10 | 0 | G/L Account Number | SKB1 | |
156 | SEGMENT | FB_SEGMENT | FB_SEGMENT | CHAR | 10 | 0 | Segment for Segmental Reporting | FAGL_SEGM | |
157 | WRBTR | WRBTR_X8 | WRTV8 | CURR | 15 | 2 | Amount in Document Currency | ||
158 | XOPVW | XOPVW | XFELD | CHAR | 1 | 0 | Indicator: Open Item Management? | ||
159 | LDGRP | FAGL_LDGRP | FAGL_LDGRP | CHAR | 4 | 0 | Ledger Group | * | |
160 | XLGCLR | XLGCLR | XFELD | CHAR | 1 | 0 | Clearing Specific to Ledger Groups | ||
161 | XREORG | FAGL_R_XDOC_REORG | FLAG | CHAR | 1 | 0 | Doc. Contains Open Item that Was Transferred During Reorg. | ||
162 | .INCLUDE | 0 | 0 | ||||||
163 | AWKEY | AWKEY | AWKEY | CHAR | 20 | 0 | Object key | ||
164 | CPUDT | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
165 | TIMESTAMP | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
166 | MWART | MWART | MWART | CHAR | 1 | 0 | Tax Type | ||
167 | .INCLUDE | 0 | 0 | BW Fields for LI Extractor: New General Ledger Accounting | |||||
168 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
169 | UPMOD | RODMUPDMOD | RODMUPDMOD | CHAR | 1 | 0 | BW Delta Process: Record Mode | ||
170 | RRCTY | RRCTY | RRCTY | CHAR | 1 | 0 | Record Type | ||
171 | RVERS | RVERS | RVERS | CHAR | 3 | 0 | Version | * | |
172 | FISCVAR | RSFISCVAR | RSFISCVAR | CHAR | 2 | 0 | Fiscal year variant | ||
173 | FISCPER | RSFISCPER | RSFISCPER | NUMC | 7 | 0 | Fiscal year / period | ||
174 | RFISCVAR | RSFISCVAR | RSFISCVAR | CHAR | 2 | 0 | Fiscal year variant | ||
175 | RFISCPER | RSFISCPER | RSFISCPER | NUMC | 7 | 0 | Fiscal year / period | ||
176 | KTOPL | KTOPL | KTOPL | CHAR | 4 | 0 | Chart of Accounts | * | |
177 | PS_POSID | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
178 | CURT2 | CURT2 | CURTP | CHAR | 2 | 0 | Currency Type of Second Local Currency | ||
179 | CURT3 | CURT3 | CURTP | CHAR | 2 | 0 | Currency Type of Third Local Currency | ||
180 | DMHAB | DMHAB | WERT7 | CURR | 13 | 2 | Credit Amount in Local Currency | ||
181 | DMHA2 | DMHA2 | WERT7 | CURR | 13 | 2 | Credit Amount in Second Local Currency | ||
182 | DMHA3 | DMHA3 | WERT7 | CURR | 13 | 2 | Credit Amount in Third Local Currency | ||
183 | DMSOL | DMSOL | WERT7 | CURR | 13 | 2 | Debit Amount in Local Currency | ||
184 | DMSO2 | DMSO2 | WERT7 | CURR | 13 | 2 | Debit Amount in Second Local Currency | ||
185 | DMSO3 | DMSO3 | WERT7 | CURR | 13 | 2 | Debit Amount in Third Local Currency | ||
186 | DMSH2 | DMSH2 | WRTV7 | CURR | 13 | 2 | Amount in Second Local Currency with +/- Sign | ||
187 | DMSH3 | DMSH3 | WRTV7 | CURR | 13 | 2 | Amount in Third Local Currency with +/- Sign | ||
188 | WRHAB | WRHAB | WERT7 | CURR | 13 | 2 | Credit Amount in Document Currency | ||
189 | WRSOL | WRSOL | WERT7 | CURR | 13 | 2 | Debit Amount in Document Currency |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 700 |