SAP ABAP Table FAGLBSIS (Accounting: Secondary Index for G/L Accounts)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ FI-GL (Application Component) General Ledger Accounting
⤷ FAGL_POSTING_SERV_EHP3_SFWC_DD (Package) Posting Services: DDIC Switch
⤷ FI-GL (Application Component) General Ledger Accounting
⤷ FAGL_POSTING_SERV_EHP3_SFWC_DD (Package) Posting Services: DDIC Switch
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | FAGLBSIS | Table Relationship Diagram |
Short Description | Accounting: Secondary Index for G/L Accounts |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
4 | AUGDT | AUGDT | DATUM | DATS | 8 | 0 | Clearing Date | ||
5 | AUGBL | AUGBL | BELNR | CHAR | 10 | 0 | Document Number of the Clearing Document | ||
6 | ZUONR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
7 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
8 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
9 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
10 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
11 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
12 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
13 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
14 | BLART | BLART | BLART | CHAR | 2 | 0 | Document type | T003 | |
15 | MONAT | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
16 | BSCHL | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | TBSL | |
17 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
18 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
19 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | T007A | |
20 | FKONT | FIPLS | FIPLS | NUMC | 3 | 0 | Financial Budget Item | ||
21 | DMBTR | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
22 | WRBTR | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
23 | MWSTS | MWSTS | WERT7 | CURR | 13 | 2 | Tax Amount in Local Currency | ||
24 | WMWST | WMWST | WERT7 | CURR | 13 | 2 | Tax amount in document currency | ||
25 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
26 | PROJN | PROJN | PROJN | CHAR | 16 | 0 | Old: Project number : No longer used --> PS_POSNR | ||
27 | AUFNR | AUFNR_NEU | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
28 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
29 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
30 | ZFBDT | DZFBDT | DATUM | DATS | 8 | 0 | Baseline date for due date calculation | ||
31 | XOPVW | XOPVW | XFELD | CHAR | 1 | 0 | Indicator: Open Item Management? | ||
32 | VALUT | VALUT | DATUM | DATS | 8 | 0 | Fixed Value Date | ||
33 | BSTAT | BSTAT_D | BSTAT | CHAR | 1 | 0 | Document Status | ||
34 | BDIFF | BDIFF | WRTV7 | CURR | 13 | 2 | Valuation Difference | ||
35 | BDIF2 | BDIF2 | WRTV7 | CURR | 13 | 2 | Valuation Difference for the Second Local Currency | ||
36 | VBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | T880 | |
37 | PSWSL | PSWSL | WAERS | CUKY | 5 | 0 | Update Currency for General Ledger Transaction Figures | TCURC | |
38 | WVERW | WVERW | WVERW | CHAR | 1 | 0 | Bill of Exchange Usage Type | ||
39 | DMBE2 | DMBE2 | WERT7 | CURR | 13 | 2 | Amount in Second Local Currency | ||
40 | DMBE3 | DMBE3 | WERT7 | CURR | 13 | 2 | Amount in Third Local Currency | ||
41 | MWST2 | MWST2 | WERT7 | CURR | 13 | 2 | Tax Amount in Second Local Currency | ||
42 | MWST3 | MWST3 | WERT7 | CURR | 13 | 2 | Tax Amount in Third Local Currency | ||
43 | BDIF3 | BDIF3 | WRTV7 | CURR | 13 | 2 | Valuation Difference for the Third Local Currency | ||
44 | RDIF3 | RDIF3 | WRTV7 | CURR | 13 | 2 | Exchange Rate Difference Realized for Third Local Currency | ||
45 | XRAGL | XRAGL | XFELD | CHAR | 1 | 0 | Indicator: Clearing was Reversed | ||
46 | PROJK | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | PRPS | |
47 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
48 | XSTOV | XSTOV | XFELD | CHAR | 1 | 0 | Indicator: Document is flagged for reversal | ||
49 | XARCH | XARCH | XFELD | CHAR | 1 | 0 | Indicator: Document already archived ? | ||
50 | PSWBT | PSWBT | WERT7 | CURR | 13 | 2 | Amount for Updating in General Ledger | ||
51 | XNEGP | XNEGP | XFELD | CHAR | 1 | 0 | Indicator: Negative posting | ||
52 | RFZEI | RFZEI_CC | NUM03 | NUMC | 3 | 0 | Payment Card Item | ||
53 | CCBTC | CCBTC | CCBTC | CHAR | 10 | 0 | Payment cards: Settlement run | ||
54 | XREF3 | XREF3 | CHAR20 | CHAR | 20 | 0 | Reference key for line item | ||
55 | BUPLA | BUPLA | J_1BBRANCH | CHAR | 4 | 0 | Business Place | J_1BBRANCH | |
56 | PPDIFF | PPDIFF | WRTV7 | CURR | 13 | 2 | Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) | ||
57 | PPDIF2 | PPDIF2 | WRTV7 | CURR | 13 | 2 | Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) | ||
58 | PPDIF3 | PPDIF3 | WRTV7 | CURR | 13 | 2 | Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) | ||
59 | BEWAR | RMVCT | RMVCT | CHAR | 3 | 0 | Transaction type | T856 | |
60 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
61 | DABRZ | DABRBEZ | DDAT | DATS | 8 | 0 | Reference date for settlement | ||
62 | INTRENO | VVINTRENO | VVINTRENO | CHAR | 13 | 0 | Internal Real Estate Master Data Code | ||
63 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
64 | FKBER | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | * | |
65 | FIPOS | FIPOS | FIPOS | CHAR | 14 | 0 | Commitment Item | * | |
66 | FISTL | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
67 | GEBER | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
68 | PPRCT | PPRCTR | PRCTR | CHAR | 10 | 0 | Partner Profit Center | * | |
69 | BUZID | BUZID | CHAR1 | CHAR | 1 | 0 | Identification of the Line Item | ||
70 | AUGGJ | AUGGJ | GJAHR | NUMC | 4 | 0 | Fiscal Year of Clearing Document | ||
71 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | * | |
72 | SEGMENT | FB_SEGMENT | FB_SEGMENT | CHAR | 10 | 0 | Segment for Segmental Reporting | * | |
73 | PSEGMENT | FB_PSEGMENT | FB_SEGMENT | CHAR | 10 | 0 | Partner Segment for Segmental Reporting | * | |
74 | PRODPER | JVA_PROD_MONTH | BUPER | ACCP | 6 | 0 | Produktionsmonat | ||
75 | QSSKZ | QSSKZ | QSSKZ | CHAR | 2 | 0 | Withholding Tax Code | * | |
76 | LDGRP | FAGL_LDGRP | FAGL_LDGRP | CHAR | 4 | 0 | Ledger Group | * | |
77 | REBZG | REBZG | BELNR | CHAR | 10 | 0 | Number of the Invoice the Transaction Belongs to | ||
78 | REBZJ | REBZJ | GJAHR | NUMC | 4 | 0 | Fiscal Year of the Relevant Invoice (for Credit Memo) | ||
79 | REBZZ | REBZZ | BUZEI | NUMC | 3 | 0 | Line Item in the Relevant Invoice | ||
80 | REBZT | REBZT | REBZT | CHAR | 1 | 0 | Follow-On Document Type | ||
81 | BUDGET_PD | FM_BUDGET_PERIOD | FM_BUDGET_PERIOD | CHAR | 10 | 0 | FM: Budget Period | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FAGLBSIS | AUFNR | AUFK | AUFNR | REF | C | CN |
2 | FAGLBSIS | BEWAR | T856 | TRTYP | REF | C | CN |
3 | FAGLBSIS | BLART | T003 | BLART | REF | 1 | CN |
4 | FAGLBSIS | BSCHL | TBSL | BSCHL | REF | 1 | CN |
5 | FAGLBSIS | BUPLA | J_1BBRANCH | BRANCH | KEY | 1 | CN |
6 | FAGLBSIS | GSBER | TGSB | GSBER | REF | C | CN |
7 | FAGLBSIS | MWSKZ | T007A | MWSKZ | REF | C | CN |
8 | FAGLBSIS | PROJK | PRPS | PSPNR | REF | C | CN |
9 | FAGLBSIS | PSWSL | TCURC | WAERS | REF | 1 | CN |
10 | FAGLBSIS | VBUND | T880 | RCOMP | REF | C | CN |
11 | FAGLBSIS | WAERS | TCURC | WAERS | REF | 1 | CN |
12 | FAGLBSIS | WERKS | T001W | WERKS | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |