FAGLPOSA SAP (Basic Data for Line Items: New General Ledger Accounting) Structure details
Description: Basic Data for Line Items: New General Ledger Accounting
Structure field list including key, data, relationships and ABAP select examples
FAGLPOSA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Basic Data for Line Items: New General Ledger Accounting" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_FAGLPOSA TYPE FAGLPOSA.
The FAGLPOSA table consists of various fields, each holding specific information or linking keys about Basic Data for Line Items: New General Ledger Accounting data available in SAP. These include ANLN2 (New asset subnumber, 4 characters), AUFNR (Order Number), AUGBL (Document Number of the Clearing Document), AUGDT (Clearing Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FAGLPOSA structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
ANLN2 | New asset subnumber, 4 characters | ANLN2_4 | CHAR | 4 | ALPHA | ANLN2_4 | AN2 | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 10 | ALPHA | BELNR | |||
AUGDT | Clearing Date | AUGDT | DATS | 8 | DATUM | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BSCHL | Posting Key | BSCHL | CHAR | 2 | TBSL | BSCHL | |||
BSTAT | Document Status | BSTAT_D | CHAR | 1 | BSTAT | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
BWWRT | Valuated Amount in Local Currency | BWWRT_X8 | CURR | 15(2) | WRTV8 | ||||
BWWR2 | Amount Valuated in Local Currency 2 | BWWR2_X8 | CURR | 15(2) | WRTV8 | ||||
BWWR3 | Amount Valuated in Local Currency 3 | BWWR3_X8 | CURR | 15(2) | WRTV8 | ||||
DMSHB | Amount in Local Currency with +/- Signs | DMSHB_X8 | CURR | 15(2) | WRTV8 | ||||
HWAER | Local Currency | HWAER | CUKY | 5 | TCURC | WAERS | |||
DMBE2 | Amount in Second Local Currency | DMBE2_X8 | CURR | 15(2) | WRTV8 | ||||
HWAE2 | Currency Key of Second Local Currency | HWAE2 | CUKY | 5 | Assigned to domain | WAERS | |||
DMBE3 | Amount in Third Local Currency | DMBE3_X8 | CURR | 15(2) | WRTV8 | ||||
HWAE3 | Currency Key of Third Local Currency | HWAE3 | CUKY | 5 | Assigned to domain | WAERS | |||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
ETEN2 | Delivery Schedule Line Number | ETENR | NUMC | 4 | Assigned to domain | ETENR | |||
FAEDT | Net Due Date | FAEDT_FPOS | DATS | 8 | DATUM | ||||
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
JAMON | Fiscal Year/Posting Period from Posting Date | JAMON_XPO | CHAR | 7 | JAMON_XPO | ||||
KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
KONTO | Account Number | KTONR_AV | CHAR | 10 | ALPHA | KTONR | |||
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
MABER | Dunning Area | MABER | CHAR | 2 | T047M | MABER | |||
MADAT | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
MANST | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
MSCHL | Dunning key | MSCHL | CHAR | 1 | T040 | MSCHL | |||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
POSN2 | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
QBSHB | Withholding Tax Amount in Document Currency | QBSHB_X8 | CURR | 15(2) | WRTV8 | ||||
QSFBT | Withholding Tax Exempt Amount in Document Currency | QSFBT_X8 | CURR | 15(2) | WRTV8 | ||||
QSSHB | Withholding Tax Base Amount in Document Currency | QSSHB_X8 | CURR | 15(2) | WRTV8 | ||||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
SAMNR | Invoice List Number | SAMNR | NUMC | 8 | SAMNR | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT_X8 | CURR | 15(2) | WRTV8 | ||||
WSKTO | Cash Discount Amount in Document Currency | WSKTO_X8 | CURR | 15(2) | WRTV8 | ||||
SKNTO | Cash Discount Amount in Local Currency | SKNTO_X8 | CURR | 15(2) | WRTV8 | ||||
STAKZ | Indicator: Statistical document ? | XSTKZ | CHAR | 1 | XFELD | ||||
UMSKS | Special G/L Transaction Type | UMSKS | CHAR | 1 | UMSKS | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | T074U | UMSKZ | |||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | Assigned to domain | UZAWE | |||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
VBEL2 | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
VBELN | Billing Document | VBELN_VF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
VBEWA | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | PGS | |
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
VERTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
VERZ1 | Days in Arrears for Cash Discount Terms 1 | VERZ1 | DEC | 5 | WRTV3 | ||||
VERZN | Days in Arrears by Net Due Date | VERZN | DEC | 5 | WRTV3 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
WRSHB | Amount in Document Currency (Foreign Currency) | WRSHB_X8 | CURR | 15(2) | WRTV8 | ||||
WAERS | Document Currency (Key) | WAER_DOC | CUKY | 5 | TCURC | WAERS | FWS | ||
WVERW | Bill of exchange usage type | WVERW | CHAR | 1 | WVERW | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
XSTRP | Indicator: Disputed item? | XSTRP | CHAR | 1 | XFELD | ||||
XZAHL | Indicator: Is the posting key used in a payment transaction? | XZAHL | CHAR | 1 | XFELD | ||||
ZALDT | Probable Payment Date (Cash Discount 1 Due) | DZALDT | DATS | 8 | DATUM | ||||
ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
ZINSZ | Interest Calculation Numerator (Days in Arrears * Amount) | DZINSZ | CURR | 15(2) | WRTV8 | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | T008 | ZAHLS | SPE | ||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
XARCH | Indicator: Document already archived ? | XARCH | CHAR | 1 | XFELD | ||||
RSTGR | Reason Code for Payments | RSTGR | CHAR | 3 | T053R | RSTGR | |||
ASKTO | Current Cash Discount Amount in Document Currency | ASKTO_X8 | CURR | 15(2) | WRTV8 | ||||
KURSE | Effective Exchange Rate in the Line Item | KURSE | DEC | 9(5) | EXCRT | KURSF | |||
REBZT | Follow-On Document Type | REBZT | CHAR | 1 | REBZT | ||||
PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL | CUKY | 5 | TCURC | WAERS | |||
PSWBT | Amount for General Ledger Update (Absolute) | PSWBT_X8 | CURR | 15(2) | WERT8 | ||||
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
XNEGP | Indicator: Negative posting | XNEGP | CHAR | 1 | XFELD | ||||
ZBFIX | Fixed Payment Terms | DZBFIX | CHAR | 1 | ZBFIX | ||||
RFZEI | Payment Card Item | RFZEI_CC | NUMC | 3 | NUM03 | ||||
CCBTC | Payment cards: Settlement run | CCBTC | CHAR | 10 | ALPHA | CCBTC | |||
KKBER | Credit control area | KKBER | CHAR | 4 | T014 | KKBER | KKB | ||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
DTWS1 | Instruction key 1 | DTAT16 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS2 | Instruction key 2 | DTAT17 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS3 | Instruction key 3 | DTAT18 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS4 | Instruction key 4 | DTAT19 | NUMC | 2 | Assigned to domain | DTWSX | |||
ABSBT | Credit Management: Hedged Amount (Absolute) | ABSBT_X8 | CURR | 15(2) | WERT8 | ||||
KKBWR | Currency of Credit Control Area | KKBWR | CUKY | 5 | Assigned to domain | WAERS | |||
PROJK | Individual Structural Element (WBS Element) in Ext. Format | PROJK_EXT | CHAR | 24 | CHAR24 | ||||
XPYPR | Indicator: Items from Payment Program Blocked | XPYPR | CHAR | 1 | XFELD | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
XAUGP | Indicator: Item has been cleared? | XAUGP | CHAR | 1 | XFELD | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
SECCO | Section Code | SECCO | CHAR | 4 | Assigned to domain | SECCO | SECCO_ABA | ||
GKART | Offsetting Account Type | GKART | CHAR | 1 | GKART | ||||
GKONT | Offsetting Account Number | GKONT | CHAR | 10 | ALPHA | GKONT | GKONT | ||
PYCUR | Currency for Automatic Payment | PYCUR | CUKY | 5 | Assigned to domain | WAERS | |||
PYAMT | Amount in Automatic Payment Currency (Absolute) | PYAMT_X8 | CURR | 15(2) | WERT8 | ||||
PYORD | Payment Order | PYORD | CHAR | 10 | ALPHA | PYORD | |||
XRAGL | Indicator: Clearing was Reversed | XRAGL | CHAR | 1 | XFELD | ||||
CESSION_KZ | Accounts Receivable Pledging Indicator | CESSION_KZ | CHAR | 2 | TCESSION | CESSION_KZ | |||
BUZID | Identification of the Line Item | BUZID | CHAR | 1 | CHAR1 | ||||
AUGGJ | Fiscal Year of Clearing Document | AUGGJ | NUMC | 4 | GJAHR | GJAHR | |||
AGZEI | Clearing Item | AGZEI | DEC | 5 | AGZEI | ||||
LONGNUM | Smart Number | /SAPPSPRO/LONGNUM | CHAR | 40 | /SAPPSPRO/LONGNUM | /SAPPSPRO/LONG_BES | /SAPPSPRO/MEKK |
Key field | Non-key field |
How do I retrieve data from SAP structure FAGLPOSA using ABAP code?
As FAGLPOSA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FAGLPOSA as there is no data to select.How to access SAP table FAGLPOSA
Within an ECC or HANA version of SAP you can also view further information about FAGLPOSA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects