FAGL_S_LINE_ITEM_UI SAP (General Line Items (Screen Display)) Structure details

Dictionary Type: Structure
Description: General Line Items (Screen Display)




ABAP Code to SELECT data from FAGL_S_LINE_ITEM_UI
Related tables to FAGL_S_LINE_ITEM_UI
Access table FAGL_S_LINE_ITEM_UI




Structure field list including key, data, relationships and ABAP select examples

FAGL_S_LINE_ITEM_UI 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 "General Line Items (Screen Display)" 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_FAGL_S_LINE_ITEM_UI TYPE FAGL_S_LINE_ITEM_UI.

The FAGL_S_LINE_ITEM_UI table consists of various fields, each holding specific information or linking keys about General Line Items (Screen Display) data available in SAP. These include POS_ID_UI (Item Number), LINETYPE (Administration Information for List Line (Internal)), CURR_NO (Currency Number: 1 = Document, 2 = Local, from 3 Parallel), BSCHL (Posting Key).. 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 FAGL_S_LINE_ITEM_UI 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
OBJECT_KEYCharacter 100 CHAR100CHAR100CHAR100
POS_ID_UIItem Number FAGL_POS_ID_UICHAR6CHAR6
LINETYPEAdministration Information for List Line (Internal) FAGL_LINE_TYPE_TEXTCHAR20FAGL_LINE_TYPE_TEXT_DOM
CURR_NO Currency Number: 1 = Document, 2 = Local, from 3 Parallel0
BSCHLPosting Key FAGL_BSCHLCHAR2Assigned to domainBSCHL
ACCOUNTAccount or Matchcode for the Next Line Item NEWKOCHAR17ALPHAKTO17
GL_ACCOUNTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
CURR_TYPECurrency Type and Valuation View CURTPCHAR2CURTP
CURRENCY_LOCCURCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
CURRENCY_LOCCUR2Currency Key WAERSCUKY5Assigned to domainWAERSFWS
CURRENCY_LOCCUR3Currency Key WAERSCUKY5Assigned to domainWAERSFWS
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
AMT_LOCCUR2Amount in Second Local Currency DMBE2CURR13(2) WERT7
AMT_LOCCUR3Amount in Third Local Currency DMBE3CURR13(2) WERT7
AMT_LOCCURAmount in Local Currency DMBTRCURR13(2) WERT7
AMT_DOCCURAmount in document currency WRBTRCURR13(2) WERT7
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
EXCH_RATEExchange rate KURSFDEC9(5) EXCRTKURSF
EXCH_RATE_VIndirect Quoted Exchange Rate UKURSMDEC9(5) PKURS
AMT_BASETax Base Amount in Document Currency BAPIFWBASDEC23(4) BAPICURR
DISC_BASEAmount Eligible for Cash Discount in Document Currency BAPISKFBTDEC23(4) BAPICURR
DISC_AMTAmount Eligible for Cash Discount in Document Currency BAPISKFBTDEC23(4) BAPICURR
ITEM_TEXTItem Text SGTXTCHAR50TEXT50
AC_DOC_NOAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
REF_KEY_1Business partner reference key XREF1CHAR12CHAR12
REF_KEY_2Business partner reference key XREF2CHAR12CHAR12
REF_KEY_3Reference key for line item XREF3CHAR20CHAR20
ACCT_KEYTransaction Key KTOSLCHAR3CHAR3
ACCT_TYPEAccount Type KOARTCHAR1KOART
DOC_TYPEDocument Type BLARTCHAR2Assigned to domainBLARTBAR
COMP_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BUS_AREABusiness Area GSBERCHAR4Assigned to domainGSBERGSB
FUNC_AREAFunctional Area FKBER_SHORTCHAR4FKBER_SHORTFBE
PLANTPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
SEGMENTSegment for Segmental Reporting FB_SEGMENTCHAR10Assigned to domainALPHAFB_SEGMENT
PSEGMENTPartner Segment for Segmental Reporting FB_PSEGMENTCHAR10Assigned to domainALPHAFB_SEGMENT
FIS_PERIODFiscal Period MONATNUMC2MONAT
FISC_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
PSTNG_DATEPosting Date in the Document BUDATDATS8DATUM
VALUE_DATEValue date VALUTDATS8DATUM
FM_AREAFinancial Management Area FIKRSCHAR4Assigned to domainFIKRSFIK
CSHDIS_INDIndicator: Line item not liable to cash discount? XSKRLCHAR1XFELD
ALLOC_NMBRAssignment Number DZUONRCHAR18ZUONR
TAX_CODETax Code FAGL_MWSKZCHAR2Assigned to domainMWSKZ
TAXJURCODETax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
COSTOBJECTCost Object KSTRGCHAR12Assigned to domainKSTRGKTR
COSTCENTERCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
ACTTYPEActivity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
PROFIT_CTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PART_PRCTRPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
NETWORKNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
WBS_ELEMENTWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
ORDERIDOrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
ORDER_ITNOOrder Item Number CO_POSNRNUMC4CO_POSNR
ROUTING_NORouting number of operations in the order CO_AUFPLNUMC10AUFPL
ACTIVITYOperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
COND_TYPECondition type KSCHACHAR4Assigned to domainKSCHLVKS
COND_COUNTCondition counter DZAEHKNUMC2ZAEHK
COND_ST_NOStep number STUNRNUMC3Assigned to domainSTUNR
FUNDFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
FUNDS_CTRFunds Center FISTLCHAR16Assigned to domainFISTLFIS
CMMT_ITEMCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
CO_BUSPROCBusiness Process CO_PRZNRCHAR12Assigned to domainALPHACO_PRZNRKWP
ASSET_NOMain Asset Number ANLN1CHAR12Assigned to domainALPHAANLN1AN1
SUB_NUMBERAsset Subnumber ANLN2CHAR4Assigned to domainALPHAANLN2AN2
SALES_ORDSales Order Number KDAUFCHAR10Assigned to domainALPHAVBELNAUN
S_ORD_ITEMItem Number in Sales Order KDPOSNUMC6NUM06KPO
DE_CRE_INDIndicator: subsequent debit/credit TBTKZCHAR1TBTKZ
QUANTITYQuantity MENGE_DQUAN13(3) MENG13
BASE_UOMBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
MATERIALMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
SERIAL_NOSequential Number of Account Assignment DZEKKNNUMC2NUM02
PART_ACCTPartner account number JV_PARTCHAR10Assigned to domainALPHAKUNNR
TR_PART_BATrading partner's business area PARGBCHAR4Assigned to domainGSBERGSB
TRADE_IDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
VAL_AREAValuation Area BWKEYCHAR4Assigned to domainBWKEYBWK
VAL_TYPEValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
ASVAL_DATEReference Date BF_BZDATDATS8DATUM
PO_NUMBERPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
PO_ITEMItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
CMMT_ITEM_LONGCommitment Item FM_FIPEXCHAR24Assigned to domainFM_FIPEXFPS
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
KURSRHedged Exchange Rate KURSRDEC9(5) KURSP
GBETRAmount in document currency BAPIWRBTRDEC23(4) BAPICURR
PMNTTRMSTerms of Payment Key DZTERMCHAR4ZTERM
BLINE_DATEBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
DSCT_DAYS1Cash discount days 1 DZBD1TDEC3ZBDXT
DSCT_DAYS2Cash discount days 2 DZBD2TDEC3ZBDXT
NETTERMSNet Payment Terms Period DZBD3TDEC3ZBDXT
DSCT_PCT1Cash Discount Percentage 1 DZBD1PDEC5(3) PRZ23
DSCT_PCT2Cash Discount Percentage 2 DZBD2PDEC5(3) PRZ23
PYMT_METHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
PMTMTHSUPLPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
PAYMT_REFPayment Reference KIDNOCHAR30CHAR30
DUNN_KEYDunning key MSCHLCHAR1Assigned to domainMSCHL
DUNN_BLOCKDunning block MANSPCHAR1Assigned to domainMANSP
PMNT_BLOCKPayment Block Key DZLSPRCHAR1Assigned to domainZAHLSSPE
VAT_REG_NOVAT Registration Number STCEGCHAR20STCEG
PARTNER_BKPartner Bank Type BVTYPCHAR4BVTYP
SCBANK_INDState Central Bank Indicator LZBKZCHAR3Assigned to domainLZBKZ
BUSINESSPLACEBusiness Place BUPLACHAR4Assigned to domainJ_1BBRANCH
SECTIONCODESection Code SECCOCHAR4Assigned to domainSECCOSECCO_ABA
BRANCHAccount Number of the Branch FILKDCHAR10ALPHAMAXKK
PYMT_CURCurrency for Automatic Payment PYCURCUKY5Assigned to domainWAERS
C_CTR_AREACredit control area KKBERCHAR4Assigned to domainKKBERKKB
BANK_IDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
SUPCOUNTRYSupplying Country LANDLCHAR3Assigned to domainLAND1
SP_GL_INDSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
ALT_PAYEEAlternative payee VVABWZECHAR10Assigned to domainALPHAKUNNR
ALT_PAYEE_BANKBank type of alternative payer VVBVTYPABWCHAR4BVTYP
DUNN_AREADunning Area MABERCHAR2Assigned to domainMABER
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
REBZTFollow-On Document Type REBZTCHAR1REBZT
INSTR1Instruction key 1 DTAT16NUMC2Assigned to domainDTWSX
INSTR2Instruction key 2 DTAT17NUMC2Assigned to domainDTWSX
INSTR3Instruction key 3 DTAT18NUMC2Assigned to domainDTWSX
INSTR4Instruction key 4 DTAT19NUMC2Assigned to domainDTWSX
CESSION_KZAccounts Receivable Pledging Indicator CESSION_KZCHAR2Assigned to domainCESSION_KZ
RSTGRReason Code for Payments RSTGRCHAR3Assigned to domainRSTGR
DIEKZService Indicator (Foreign Payment) DIEKZCHAR1DIEKZ
ZINKZExempted from interest calculation DZINKZCHAR2ZINKZ
FDLENPlanning level FDLEVCHAR2Assigned to domainFDLEVFFE
FDTAGPlanning date FDTAGDATS8DATUMFDT
XEGDRIndicator: Triangular deal within the EU ? XEGDRCHAR1XFELD
HZUONAssignment Number for Special G/L Accounts HZUONCHAR18ZUONR
VERTNContract Number RANLCHAR13ALPHARANLRAN
VERTTContract Type RANTYPCHAR1RANTYP
VBEWAFlow Type SBEWARTCHAR4Assigned to domainSBEWART
SAMNRInvoice List Number SAMNRNUMC8SAMNR
EGRUPEquity group JV_EGROUPCHAR3Assigned to domainALPHAJV_EGROUPGJE
BTYPEBranching Type BTYPECHAR1CHAR1
VNAMELayout VNAMECHAR3CHAR3
VRSKZInsurance indicator VRSKZCHAR1CHAR1
VRSDTInsurance date VRSDTDATS8DATUM
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
FKBERFunctional Area FKBER_LONGCHAR16Assigned to domainFKBER_LONGFBE
KBLNRDocument Number for Earmarked Funds KBLNRCHAR10Assigned to domainALPHAKBLNRKBL
KBLPOSEarmarked Funds: Document Item KBLPOSNUMC3Assigned to domainKBLPOSKBP
ERLKZCompleted Indicator for Open Items ERLKZCHAR1ERLKZ
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
FIPOSCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
IDXSPInflation Index J_1AINDXSPCHAR5Assigned to domainJ_1AINDXP
ACCOUNT_TEXTG/L Account Long Text TXT50_SKATCHAR50TEXT50

Key field Non-key field



How do I retrieve data from SAP structure FAGL_S_LINE_ITEM_UI using ABAP code?

As FAGL_S_LINE_ITEM_UI 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 FAGL_S_LINE_ITEM_UI as there is no data to select.

How to access SAP table FAGL_S_LINE_ITEM_UI

Within an ECC or HANA version of SAP you can also view further information about FAGL_S_LINE_ITEM_UI and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!