FAGL_EMU_S_KEY5 SAP (Key for an FI Line Item without Company Code) Structure details

Dictionary Type: Structure
Description: Key for an FI Line Item without Company Code




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




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

FAGL_EMU_S_KEY5 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 "Key for an FI Line Item without Company Code" 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_EMU_S_KEY5 TYPE FAGL_EMU_S_KEY5.

The FAGL_EMU_S_KEY5 table consists of various fields, each holding specific information or linking keys about Key for an FI Line Item without Company Code data available in SAP. These include BELNR (Accounting Document Number), GJAHR (Fiscal Year), BUZEI (Number of Line Item Within Accounting Document), LDGRP (Ledger Group).. 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 (Deep)


SAP FAGL_EMU_S_KEY5 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
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
LDGRPLedger Group FAGL_LDGRPCHAR4Assigned to domainFAGL_LDGRPGLDGRP_FLEX
BUDATPosting Date in the Document BUDATDATS8DATUM
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
AUGDTClearing Date AUGDTDATS8DATUM
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
PSWBTAmount for Updating in General Ledger PSWBTCURR13(2) WERT7
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
DMBE2Amount in Second Local Currency DMBE2CURR13(2) WERT7
DMBE3Amount in Third Local Currency DMBE3CURR13(2) WERT7
SPLINFO 0
S_BKPF 0
MANDTClient MANDTCLNT3MANDT
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BLARTDocument Type BLARTCHAR2BLARTBAR
BLDATDocument Date in Document BLDATDATS8DATUM
BUDATPosting Date in the Document BUDATDATS8DATUM
MONATFiscal Period MONATNUMC2MONAT
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
AEDATDate of the Last Document Change by Transaction AEDAT_BKPFDATS8DATUM
UPDDTDate of the Last Document Update UPDDTDATS8DATUM
WWERTTranslation Date WWERT_DDATS8DATUM
USNAMUser name USNAMCHAR12XUBNAMEUSR
TCODETransaction Code TCODECHAR20TCODETCD
BVORGNumber of Cross-Company Code Posting Transaction BVORGCHAR16BVORG
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
DBBLGRecurring Entry Document Number DBBLGCHAR10ALPHABELNR
STBLGReverse Document Number STBLGCHAR10ALPHABELNR
STJAHReverse document fiscal year STJAHNUMC4GJAHRGJAHR
BKTXTDocument Header Text BKTXTCHAR25TEXT25
WAERSCurrency Key WAERSCUKY5WAERSFWS
KURSFExchange rate KURSFDEC9(5) EXCRTKURSF
KZWRSCurrency Key for the Group Currency KZWRSCUKY5WAERS
KZKRSGroup Currency Exchange Rate KZKRSDEC9(5) KURSF
BSTATDocument Status BSTAT_DCHAR1BSTAT
XNETBIndicator: Document posted net ? XNETBCHAR1XFELD
FRATHUnplanned delivery costs FRATHCURR13(2) WERT7
XRUEBIndicator: Document is posted to a previous period XRUEBCHAR1XFELD
GLVORBusiness Transaction GLVORCHAR4CHAR4
GRPIDBatch Input Session Name GRPID_BKPFCHAR12CHAR12
DOKIDDocument Name in the Archive System DOKID_BKPFCHAR40CHAR40
ARCIDExtract ID Document Header EXTID_BKPFCHAR10CHAR10
IBLARInternal Document Type for Document Control IBLARCHAR2IBLAR
AWTYPReference Transaction AWTYPCHAR5AWTYP
AWKEYReference Key AWKEYCHAR20AWKEY
FIKRSFinancial Management Area FIKRSCHAR4FIKRSFIK
HWAERLocal Currency HWAERCUKY5WAERS
HWAE2Currency Key of Second Local Currency HWAE2CUKY5WAERS
HWAE3Currency Key of Third Local Currency HWAE3CUKY5WAERS
KURS2Exchange Rate for the Second Local Currency KURS2DEC9(5) KURSF
KURS3Exchange Rate for the Third Local Currency KURS3DEC9(5) KURSF
BASW2Source Currency for Currency Translation CURSRCHAR1CURSR
BASW3Source Currency for Currency Translation CURSRCHAR1CURSR
UMRD2Translation Date Type for Second Local Currency UMRD2CHAR1CURDT
UMRD3Translation Date Type for Third Local Currency UMRD3CHAR1CURDT
XSTOVIndicator: Document is flagged for reversal XSTOVCHAR1XFELD
STODTPlanned Date for the Reverse Posting STODTDATS8DATUM
XMWSTCalculate tax automatically XMWSTCHAR1XFELDXTX
CURT2Currency Type of Second Local Currency CURT2CHAR2CURTP
CURT3Currency Type of Third Local Currency CURT3CHAR2CURTP
KUTY2Exchange Rate Type KURSTCHAR4KURSTKUT
KUTY3Exchange Rate Type KURSTCHAR4KURSTKUT
XSNETG/L account amounts entered exclude tax XSNETCHAR1XFELD
AUSBKSource Company Code AUSBKCHAR4BUKRS
XUSVRIndicator: US taxes changed at detail level ? XUSVR_BKPFCHAR1XFELD
DUEFLStatus of Data Transfer into Subsequent Release DUEFL_BKPFCHAR1DUEFL_BKPF
AWSYSLogical System LOGSYSTEMCHAR10ALPHALOGSYS
TXKRSExchange Rate for Taxes TXKRS_BKPFDEC9(5) KURSF
LOTKZLot Number for Requests PSO_LOTKZCHAR10ALPHALOTKZLOT
XWVOFIndicator: Customer bill of exchange payment before due date XWVOFCHAR1XFELD
STGRDReason for Reversal STGRDCHAR2STGRDFSG
PPNAMName of User Who Parked this Document PPNAMCHAR12XUBNAME
BRNCHBranch Number J_1ABRNCHCHAR4J_1BBRANCHJEA
NUMPGNumber of pages of invoice J_1ANOPGNUMC3J_1ANOPG
ADISCIndicator: entry represents a discount document J_1ADISCCHAR1ADISC
XREF1_HDReference Key 1 Internal for Document Header XREF1_HDCHAR20CHAR20
XREF2_HDReference Key 2 Internal for Document Header XREF2_HDCHAR20CHAR20
XREVERSALSpecifies whether doc. is reversal doc. or reversed doc. XREVERSALCHAR1XREVERSAL
REINDATInvoice Receipt Date REINDATDATS8DATUM
RLDNRLedger in General Ledger Accounting FAGL_RLDNRCHAR2ALPHARLDNRGLN_FLEXFAGL_RLDNR
LDGRPLedger Group FAGL_LDGRPCHAR4FAGL_LDGRPGLDGRP_FLEX
PROPMANOReal Estate Management Mandate RE_MANDATCHAR13PRPMNRE_MANDAT
XBLNR_ALTAlternative Reference Number XBLNR_ALTCHAR26ODNITXBLNR_ALT
VATDATETax Reporting Date VATDATEDATS8DATUM
DOCCATClassification of an FI Document DOCUMENT_CATEGORYCHAR6DOCUMENT_CATEGORY
XSPLITFI Document Originates from Split Posting (Indicator) SPLIT_POSTINGCHAR1XFELD
CASH_ALLOCCash-Relevant Document FAGL_CASH_ALLOCCHAR1BOOLE
FOLLOW_ONFollow-on document indicator FAGL_FOLLOW_ONCHAR1FAGL_FOLLOW_ON
XREORGDoc. Contains Open Item that Was Transferred During Reorg. FAGL_R_XDOC_REORGCHAR1FLAG
SUBSETDefines subset of components for the FI/CO interface ACC_SUBSETCHAR4ACC_SUBSET
KURSTExchange Rate Type KURSTCHAR4KURSTKUT
KURSXMarket Data Exchange Rate GLE_FXR_DTE_RATEX28DEC28(14) EXCRXGLE_FXR_RATEX28
KUR2XMarket Data Exchange Rate 2 GLE_FXR_DTE_RATE2X28DEC28(14) EXCRXGLE_FXR_RATEX28
KUR3XMarket Data Exchange Rate 3 GLE_FXR_DTE_RATE3X28DEC28(14) EXCRXGLE_FXR_RATEX28
XMCADocument Originates from Multi Currency Accounting GLE_DTE_MCA_XMCACHAR1XFELD
.INCLU--AP 0
/SAPF15/STATUS /SAPF15/STATUSCHAR1/SAPF15/STATUS
.INCLU--AP 0
PSOTYDocument category payment requests PSOTY_DCHAR2PSOTY
PSOAKReason PSOAKCHAR10PSOAK
PSOKSRegion PSOKSCHAR10PSOKS
PSOSGReason for reversal - IS-PS requests PSOSGCHAR1PSOSG
PSOFNIS-PS: File number PSOFNCHAR30CHAR30
INTFORMInterest Formula FM_INTFORMCHAR4CHAR4
INTDATEInterest Calc. Date FM_INTDATEDATS8DATUM
PSOBTPosting Day PSOBTDATS8DATUM
PSOZLActual posting PSOZLCHAR1XFELD
PSODTChanged On AEDATDATS8DATUM
PSOTMLast changed at PSOTMTIMS6UZEIT
.INCLU--AP 0
FM_UMARTType of Payment Transfer FM_UMARTCHAR1FM_UMART
.INCLU--AP 0
CCINSPayment cards: Card type CCINS_30FCHAR4CCINS_30FCIN
CCNUMPayment cards: Card number CCNUM_30FCHAR25CCNUM_30FCNO
.INCLU--AP 0
SSBLKPayment Statistical Sampling Block SSBLKCHAR1SSBLK
BATCHLot Number for Documents LOTKZCHAR10ALPHALOTKZLOT
SNAMEUser Name UNAMECHAR12UNAME
SAMPLEDSampled Invoice by Payment Certification SAMPLEDCHAR1SSBLK
EXCLUDE_FLAGPPA Exclude Indicator EXCLUDE_FLGCHAR1XFELD
BLINDBudgetary Ledger Indicator FM_BLINDCHAR1FM_BLIND
OFFSET_STATUSTreasury Offset Status FMFG_OFFSET_STATUSCHAR2FMFG_OFFSET_STATUS
OFFSET_REFER_DATDate Record Referred to Treasury FMFG_REFERRED_OFFSET_DATDATS8DATUM
PENRCReason for late payment PENRCCHAR2CHAR2FM_PENRC
.INCLU--AP 0
KNUMVNumber of the document condition KNUMVCHAR10KNUMV
S_BSEG 0
MANDTClient MANDTCLNT3MANDT
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
BUZIDIdentification of the Line Item BUZIDCHAR1CHAR1
AUGDTClearing Date AUGDTDATS8DATUM
AUGCPClearing Entry Date AUGCPDATS8DATUM
AUGBLDocument Number of the Clearing Document AUGBLCHAR10ALPHABELNR
BSCHLPosting Key BSCHLCHAR2BSCHL
KOARTAccount Type KOARTCHAR1KOART
UMSKZSpecial G/L Indicator UMSKZCHAR1UMSKZ
UMSKSSpecial G/L Transaction Type UMSKSCHAR1UMSKS
ZUMSKTarget Special G/L Indicator DZUMSKCHAR1UMSKZ
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
GSBERBusiness Area GSBERCHAR4GSBERGSB
PARGBTrading partner's business area PARGBCHAR4GSBERGSB
MWSKZTax on sales/purchases code MWSKZCHAR2MWSKZ
QSSKZWithholding Tax Code QSSKZCHAR2QSSKZ
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
KZBTROriginal Reduction Amount in Local Currency KZBTR_FICURR13(2) WERT7
PSWBTAmount for Updating in General Ledger PSWBTCURR13(2) WERT7
PSWSLUpdate Currency for General Ledger Transaction Figures PSWSLCUKY5WAERS
TXBHWOriginal Tax Base Amount in Local Currency TXBHWCURR13(2) WERT7
TXBFWOriginal Tax Base Amount in Document Currency TXBFWCURR13(2) WERT7
MWSTSTax Amount in Local Currency MWSTSCURR13(2) WERT7
WMWSTTax amount in document currency WMWSTCURR13(2) WERT7
HWBASTax Base Amount in Local Currency HWBASCURR13(2) WERT7
FWBASTax Base Amount in Document Currency FWBASCURR13(2) WERT7
HWZUZProvision Amount in Local Currency HWZUZCURR13(2) WERT7
FWZUZAdditional Tax in Document Currency FWZUZCURR13(2) WERT7
SHZUZDebit/Credit Addition for Cash Discount SHZUZCHAR1CHAR1
STEKZVersion Number Component CHAR2CHAR2CHAR2
MWARTTax Type MWARTCHAR1MWART
TXGRPGroup Indicator for Tax Line Items TXGRPNUMC3NUM03
KTOSLTransaction Key KTOSLCHAR3CHAR3
QSSHBWithholding Tax Base Amount QSSHBCURR13(2) WERT7
KURSRHedged Exchange Rate KURSRDEC9(5) KURSP
GBETRHedged Amount in Foreign Currency GBETRCURR13(2) WERT7
BDIFFValuation Difference BDIFFCURR13(2) WRTV7
BDIF2Valuation Difference for the Second Local Currency BDIF2CURR13(2) WRTV7
VALUTValue date VALUTDATS8DATUM
ZUONRAssignment Number DZUONRCHAR18ZUONR
SGTXTItem Text SGTXTCHAR50TEXT50
ZINKZExempted from interest calculation DZINKZCHAR2ZINKZ
VBUNDCompany ID of trading partner RASSCCHAR6ALPHARCOMPPGS
BEWARTransaction Type RMVCTCHAR3RMVCT
ALTKTGroup account number BILKT_SKA1CHAR10ALPHASAKNR
VORGNTransaction Type for General Ledger VORGNCHAR4VORGN
FDLEVPlanning level FDLEVCHAR2FDLEVFFE
FDGRPPlanning Group FDGRPCHAR10ALPHAFDGRPFFG
FDWBTPlanning amount in document currency FDWBTCURR13(2) WERTV7
FDTAGPlanning date FDTAGDATS8DATUMFDT
FKONTFinancial Budget Item FIPLSNUMC3FIPLS
KOKRSControlling Area KOKRSCHAR4CACCDCAC
KOSTLCost Center KOSTLCHAR10ALPHAKOSTLKOS
PROJNOld: Project number : No longer used --> PS_POSNR PROJNCHAR16PROJN
AUFNROrder Number AUFNRCHAR12ALPHAAUFNRANR
VBELNBilling Document VBELN_VFCHAR10ALPHAVBELNVF
VBEL2Sales Document VBELN_VACHAR10ALPHAVBELNAUN
POSN2Sales Document Item POSNR_VANUMC6POSNRAPO
ETEN2Delivery Schedule Line Number ETENRNUMC4ETENR
ANLN1Main Asset Number ANLN1CHAR12ALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4ALPHAANLN2AN2
ANBWAAsset Transaction Type ANBWACHAR3BWASL
BZDATAsset value date BZDATDATS8DATUM
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
XUMSWIndicator: Sales-related item ? XUMSWCHAR1XFELD
XHRESIndicator: Resident G/L account? XHRESCHAR1XFELD
XKRESIndicator: Can Line Items Be Displayed by Account? XKRESCHAR1XFELD
XOPVWIndicator: Open item management? XOPVWCHAR1XFELD
XCPDDIndicator: Address and bank data set individually XCPDDCHAR1XFELD
XSKSTIndicator: Statistical posting to cost center XSKSTCHAR1XFELD
XSAUFIndicator: Posting to order is statistical XSAUFCHAR1XFELD
XSPROIndicator: Posting to project is statistical XSPROCHAR1XFELD
XSERGIndicator: Posting to prof.analysis is statistical XSERGCHAR1XFELD
XFAKTIndicator: Billing document update successful ? XFAKTCHAR1XFELD
XUMANIndicator: Transfer posting from down payment ? XUMANCHAR1XFELD
XANETIndicator: Down payment in net procedure ? XANETCHAR1XFELD
XSKRLIndicator: Line item not liable to cash discount? XSKRLCHAR1XFELD
XINVEIndicator: Capital Goods Affected? XINVECHAR1XFELD
XPANZDisplay item XPANZCHAR1XFELD
XAUTOIndicator: Line item automatically created XAUTOCHAR1XFELD
XNCOPIndicator: Items cannot be copied? XNCOPCHAR1XFELD
XZAHLIndicator: Is the posting key used in a payment transaction? XZAHLCHAR1XFELD
SAKNRG/L Account Number SAKNRCHAR10ALPHASAKNRSAKC_SAKNR
HKONTGeneral Ledger Account HKONTCHAR10ALPHASAKNR
KUNNRCustomer Numbers KUNNRCHAR10ALPHAKUNNRKUNC_KUNNR
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10ALPHALIFNRLIFKRED_C
FILKDAccount Number of the Branch FILKDCHAR10ALPHAMAXKK
XBILKIndicator: Account is a balance sheet account? XBILKCHAR1XFELD
GVTYPP&L statement account type GVTYPCHAR2CHAR2
HZUONAssignment Number for Special G/L Accounts HZUONCHAR18ZUONR
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZBD1TCash discount days 1 DZBD1TDEC3ZBDXT
ZBD2TCash discount days 2 DZBD2TDEC3ZBDXT
ZBD3TNet Payment Terms Period DZBD3TDEC3ZBDXT
ZBD1PCash Discount Percentage 1 DZBD1PDEC5(3) PRZ23
ZBD2PCash Discount Percentage 2 DZBD2PDEC5(3) PRZ23
SKFBTAmount Eligible for Cash Discount in Document Currency SKFBTCURR13(2) WERT7
SKNTOCash discount amount in local currency SKNTOCURR13(2) WERT7
WSKTOCash discount amount in document currency WSKTOCURR13(2) WERT7
ZLSCHPayment Method SCHZW_BSEGCHAR1ZLSCH
ZLSPRPayment Block Key DZLSPRCHAR1ZAHLSSPE
ZBFIXFixed Payment Terms DZBFIXCHAR1ZBFIX
HBKIDShort Key for a House Bank HBKIDCHAR5HBKID
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
NEBTRNet Payment Amount NEBTRCURR13(2) WERT7
MWSK1Tax Code for Distribution MWSKXCHAR2MWSKZ
DMBT1Amount in Local Currency for Tax Distribution DMBTXCURR13(2) WRTV7
WRBT1Amount in foreign currency for tax breakdown WRBTXCURR13(2) WRTV7
MWSK2Tax Code for Distribution MWSKXCHAR2MWSKZ
DMBT2Amount in Local Currency for Tax Distribution DMBTXCURR13(2) WRTV7
WRBT2Amount in foreign currency for tax breakdown WRBTXCURR13(2) WRTV7
MWSK3Tax Code for Distribution MWSKXCHAR2MWSKZ
DMBT3Amount in Local Currency for Tax Distribution DMBTXCURR13(2) WRTV7
WRBT3Amount in foreign currency for tax breakdown WRBTXCURR13(2) WRTV7
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
ZOLLTCustoms Tariff Number DZOLLTCHAR8ZOLLT
ZOLLDCustoms Date DZOLLDDATS8DATUM
LZBKZState Central Bank Indicator LZBKZCHAR3LZBKZ
LANDLSupplying Country LANDLCHAR3LAND1
DIEKZService Indicator (Foreign Payment) DIEKZCHAR1DIEKZ
SAMNRInvoice List Number SAMNRNUMC8SAMNR
ABPERSettlement period ABPER_RFACCP6BUPER
VRSKZInsurance indicator VRSKZCHAR1CHAR1
VRSDTInsurance date VRSDTDATS8DATUM
DISBNNumber of Bill of Exchange Usage Document (Discount Doc.) DISBNCHAR10ALPHABELNR
DISBJFiscal Year of Bill of Exchange Usage Document DISBJNUMC4GJAHRGJAHR
DISBZLine Item within the Bill of Exchange Usage Document DISBZNUMC3BUZEI
WVERWBill of exchange usage type WVERWCHAR1WVERW
ANFBNDocument Number of the Bill of Exchange Payment Request ANFBNCHAR10ALPHABELNR
ANFBJFiscal Year of the Bill of Exchange Payment Request Document ANFBJNUMC4GJAHRGJAHR
ANFBUCompany Code in Which Bill of Exch.Payment Request Is Posted ANFBUCHAR4BUKRS
ANFAEBill of Exchange Payment Request Due Date ANFAEDATS8DATUM
BLNBTBase Amount for Determining the Preference Amount BLNBTCURR13(2) WERT7
BLNKZSubsidy indicator for determining the reduction rates BLNKZCHAR2BLNKZ
BLNPZPreference Percentage Rate BLNPZDEC7(2) PRZ52
MSCHLDunning key MSCHLCHAR1MSCHL
MANSPDunning block MANSPCHAR1MANSP
MADATLast dunned on MADATDATS8DATUM
MANSTDunning level MAHNS_DNUMC1MAHNS
MABERDunning Area MABERCHAR2MABER
ESRNRISR Subscriber Number ESRNRCHAR11ESRNR
ESRREISR Reference Number ESRRECHAR27ALPHAESRRE
ESRPZISR Check Digit ESRPZCHAR2CHAR2
KLIBTCredit Control Amount KLIBTCURR13(2) WERT7
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
QBSHBWithholding Tax Amount (in Document Currency) QBSHBCURR13(2) WERT7
QSFBTWithholding Tax-Exempt Amount (in Document Currency) QSFBTCURR13(2) WERT7
NAVHWNon-Deductible Input Tax (in Local Currency) NAVHWCURR13(2) WERT7
NAVFWNon-Deductible Input Tax (in Document Currency) NAVFWCURR13(2) WERT7
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4WERKSWRKH_T001W_C
MENGEQuantity MENGE_DQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3CUNITMEINS
ERFMGQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
ERFMEUnit of Entry ERFMEUNIT3CUNITMEINS
BPMNGQuantity in Purchase Order Price Unit BPMNGQUAN13(3) MENG13
BPRMEOrder Price Unit (Purchasing) BPRMEUNIT3CUNITMEINS
EBELNPurchasing Document Number EBELNCHAR10ALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EBELPBSP
ZEKKNSequential Number of Account Assignment DZEKKNNUMC2NUM02
ELIKZ'Delivery Completed' Indicator ELIKZCHAR1XFELD
VPRSVPrice control indicator VPRSVCHAR1VPRSV
PEINHPrice Unit PEINHDEC5PACK3
BWKEYValuation Area BWKEYCHAR4BWKEYBWK
BWTARValuation Type BWTAR_DCHAR10BWTARBWT
BUSTWPosting string for values BUSTWCHAR4BUSTW
REWRTInvoice Value Entered (in Local Currency) REEWRCURR13(2) WRTV7
REWWRInvoice value in foreign currency REFWRCURR13(2) WRTV7
BONFBAmount Qualifying for Bonus in Local Currency BONFBCURR13(2) WERT7
BUALTAmount posted in alternative price control BUALTCURR13(2) WERTV7
PSALTAlternative Price Control PSALTCHAR1VPRSV
NPREINew price NPREICURR11(2) WERT11
TBTKZIndicator: subsequent debit/credit TBTKZCHAR1TBTKZ
SPGRPBlocking reason: price SPGRPCHAR1XFELD
SPGRMBlocking reason: quantity SPGRMCHAR1XFELD
SPGRTBlocking Reason: Date SPGRTCHAR1XFELD
SPGRGBlocking reason: order price quantity SPGRGCHAR1XFELD
SPGRVBlocking reason: project budget SPGRVCHAR1XFELD
SPGRQManual Blocking Reason SPGRQCHAR1XFELD
STCEGVAT Registration Number STCEGCHAR20STCEG
EGBLDCountry of Destination for Delivery of Goods EGBLDCHAR3LAND1
EGLLDSupplying Country for Delivery of Goods EGLLDCHAR3LAND1
RSTGRReason Code for Payments RSTGRCHAR3RSTGR
RYACQYear of acquisition RYACQCHAR4GJAHRCJAHR
RPACQPeriod of Acquisition RPACQNUMC3NUM03
RDIFFExchange Rate Gain/Loss Realized RDIFFCURR13(2) WRTV7
RDIF2Exchange Rate Difference Realized for Second Local Currency RDIF2CURR13(2) WRTV7
PRCTRProfit Center PRCTRCHAR10ALPHAPRCTRPRCPRCTR_EMPTY
XHKOMIndicator: G/L account assigned manually ? XHKOMCHAR1XFELD
VNAMEJoint Venture JV_NAMECHAR6ALPHAJV_NAMEJVV
RECIDRecovery Indicator JV_RECINDCHAR2ALPHAJV_RECIND
EGRUPEquity group JV_EGROUPCHAR3ALPHAJV_EGROUPGJE
VPTNRPartner account number JV_PARTCHAR10ALPHAKUNNR
VERTTContract Type RANTYPCHAR1RANTYP
VERTNContract Number RANLCHAR13ALPHARANLRAN
VBEWAFlow Type SBEWARTCHAR4SBEWART
DEPOTSecurities Account RLDEPOCHAR10RLDEPODEPACC_CCD_CORE
TXJCDTax Jurisdiction TXJCDCHAR15TXJCDTXJ
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
DABRZReference Date for Settlement DABRBEZDATS8DDAT
POPTSReal estate option rate POPTSATZDEC9(6) POPTSATZ
FIPOSCommitment Item FIPOSCHAR14FIPOSFIP
KSTRGCost Object KSTRGCHAR12KSTRGKTR
NPLNRNetwork Number for Account Assignment NPLNRCHAR12ALPHAAUFNRNET
AUFPLTask list number for operations in order AUFPL_CHNUMC10AUFPL
APLZLGeneral counter for order APLZL_CHNUMC8CO_APLZL
PROJKWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8KONPRPS_POSNR
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PASUBNRProfitability segment changes (CO-PA) RKESUBNRNUMC4RKESUBNR
SPGRSBlocking Reason: Item Amount SPGRSCHAR1XFELD
SPGRCBlock.reason: quality SPGRCCHAR1XFELD
BTYPEPayroll Type JV_BILINDCHAR2ALPHAJV_BILIND
ETYPEEquity type JV_ETYPECHAR3ALPHAJV_ETYPE
XEGDRIndicator: Triangular deal within the EU ? XEGDRCHAR1XFELD
LNRANSequence number of asset line items in fiscal year LNRANNUMC5LNRAN
HRKFTOrigin Group as Subdivision of Cost Element HRKFTCHAR4HRKFT
DMBE2Amount in Second Local Currency DMBE2CURR13(2) WERT7
DMBE3Amount in Third Local Currency DMBE3CURR13(2) WERT7
DMB21Amount in Second Local Currency for Tax Breakdown DMB2XCURR13(2) WRTV7
DMB22Amount in Second Local Currency for Tax Breakdown DMB2XCURR13(2) WRTV7
DMB23Amount in Second Local Currency for Tax Breakdown DMB2XCURR13(2) WRTV7
DMB31Amount in Third Local Currency for Tax Breakdown DMB3XCURR13(2) WRTV7
DMB32Amount in Third Local Currency for Tax Breakdown DMB3XCURR13(2) WRTV7
DMB33Amount in Third Local Currency for Tax Breakdown DMB3XCURR13(2) WRTV7
MWST2Tax Amount in Second Local Currency MWST2CURR13(2) WERT7
MWST3Tax Amount in Third Local Currency MWST3CURR13(2) WERT7
NAVH2Non-Deductible Input Tax in Second Local Currency NAVH2CURR13(2) WERT7
NAVH3Non-Deductible Input Tax in Third Local Currency NAVH3CURR13(2) WERT7
SKNT2Cash Discount Amount in Second Local Currency SKNT2CURR13(2) WERT7
SKNT3Cash Discount Amount in Third Local Currency SKNT3CURR13(2) WERT7
BDIF3Valuation Difference for the Third Local Currency BDIF3CURR13(2) WRTV7
RDIF3Exchange Rate Difference Realized for Third Local Currency RDIF3CURR13(2) WRTV7
HWMETMethod with Which the Local Currency Amount Was Determined HWMETCHAR1HWMET
GLUPMUpdate Method for FM - FI-CA Integration GLUPMCHAR1GLUPM
XRAGLIndicator: Clearing was Reversed XRAGLCHAR1XFELD
UZAWEPayment Method Supplement UZAWECHAR2UZAWE
LOKKTAlternative account number in company code ALTKT_SKB1CHAR10ALPHASAKNR
FISTLFunds Center FISTLCHAR16FISTLFIS
GEBERFund BP_GEBERCHAR10BP_GEBERFIC
STBUKTax Company Code STBUKCHAR4BUKRSBUK
TXBH2Tax Base/Original Tax Base in Second Local Currency TXBH2CURR13(2) WERT7
TXBH3Tax Base/Original Tax Base in Third Local Currency TXBH3CURR13(2) WERT7
PPRCTPartner Profit Center PPRCTRCHAR10ALPHAPRCTRPPC
XREF1Business partner reference key XREF1CHAR12CHAR12
XREF2Business partner reference key XREF2CHAR12CHAR12
KBLNRDocument Number for Earmarked Funds KBLNR_FICHAR10ALPHAKBLNRKBL
KBLPOSEarmarked Funds: Document Item KBLPOSNUMC3KBLPOSKBP
STTAXTax amount as statistical information in document currency STTAXCURR13(2) WERT7
FKBERFunctional Area FKBER_SHORTCHAR4FKBER_SHORTFBE
OBZEINumber of Line Item in Original Document OBZEINUMC3BUZEI
XNEGPIndicator: Negative posting XNEGPCHAR1XFELD
RFZEIPayment Card Item RFZEI_CCNUMC3NUM03
CCBTCPayment cards: Settlement run CCBTCCHAR10ALPHACCBTC
KKBERCredit control area KKBERCHAR4KKBERKKB
EMPFBPayee/Payer EMPFBCHAR10ALPHAMAXKK
XREF3Reference key for line item XREF3CHAR20CHAR20
DTWS1Instruction key 1 DTAT16NUMC2DTWSX
DTWS2Instruction key 2 DTAT17NUMC2DTWSX
DTWS3Instruction key 3 DTAT18NUMC2DTWSX
DTWS4Instruction key 4 DTAT19NUMC2DTWSX
GRICDActivity Code for Gross Income Tax J_1AGICD_DCHAR2J_1AGICD2
GRIRGSTATE (State, Province, County) REGIOCHAR3REGIO
GITYPDistribution Type for Employment Tax J_1ADTYP_DCHAR2J_1ADTYP
XPYPRIndicator: Items from Payment Program Blocked XPYPRCHAR1XFELD
KIDNOPayment Reference KIDNOCHAR30CHAR30
ABSBTCredit management: Hedged amount ABSBTCURR13(2) WERT7
IDXSPInflation Index J_1AINDXSPCHAR5J_1AINDXP
LINFVLast Adjustment Date J_1ALINFVLDATS8DATUM
KONTTAccount Assignment Category for Industry Solution KONTT_FICHAR2KONTT_FI
KONTLAcct assignment string for industry-specific acct assignmnts KONTL_FICHAR50CHAR50
TXDATDate for defining tax rates TXDATDATS8DATUM
AGZEIClearing Item AGZEIDEC5AGZEI
PYCURCurrency for Automatic Payment PYCURCUKY5WAERS
PYAMTAmount in Payment Currency PYAMTCURR13(2) WERT7
BUPLABusiness Place BUPLACHAR4J_1BBRANCH
SECCOSection Code SECCOCHAR4SECCOSECCO_ABA
LSTARActivity Type LSTARCHAR6LSTARLARLART_EMPTY
CESSION_KZAccounts Receivable Pledging Indicator CESSION_KZCHAR2CESSION_KZ
PRZNRBusiness Process CO_PRZNRCHAR12ALPHACO_PRZNRKWP
PPDIFFRealized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) PPDIFFCURR13(2) WRTV7
PPDIF2Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) PPDIF2CURR13(2) WRTV7
PPDIF3Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) PPDIF3CURR13(2) WRTV7
PENLC1Penalty charge amount in first local currency PENALTY1CURR13(2) WERT13
PENLC2Penalty charge amount in second local currency PENALTY2CURR13(2) WERT13
PENLC3Penalty Charge Amount in Third Local Currency PENALTY3CURR13(2) WERT13
PENFCPenalty charge amount in document currency PENALTYCURR13(2) WERT13
PENDAYSNumber of days for penalty charge calculation PDAYSINT410INT4
PENRCReason for late payment PENRCCHAR2CHAR2FM_PENRC
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
SCTAXTax portion FI-CA local currency SCTAXCURR13(2) WERT7
FKBER_LONGFunctional Area FKBERCHAR16FKBERFBE
GMVKZItem is in Execution FM_GMVKZCHAR1FM_GMVKZ
SRTYPEType of Additional Receivable FM_SRTYPECHAR2FM_SRTYPE
INTRENOInternal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
MEASUREFunded Program FM_MEASURECHAR24FM_MEASUREFM_MEASURE
AUGGJFiscal Year of Clearing Document AUGGJNUMC4GJAHRGJAHR
PPA_EX_INDPPA Exclude Indicator EXCLUDE_FLGCHAR1XFELD
DOCLNSix-Character Posting Item for Ledger DOCLN6CHAR6DOCLN6
SEGMENTSegment for Segmental Reporting FB_SEGMENTCHAR10ALPHAFB_SEGMENT
PSEGMENTPartner Segment for Segmental Reporting FB_PSEGMENTCHAR10ALPHAFB_SEGMENT
PFKBERPartner Functional Area SFKBERCHAR16FKBER
HKTIDID for account details HKTIDCHAR5HKTID
KSTARCost Element KSTARCHAR10ALPHAKSTARKAT
XLGCLRClearing Specific to Ledger Groups XLGCLRCHAR1XFELD
TAXPSTax document item number TAX_POSNRNUMC6NUM6
PAYS_PROVPayment Service Provider COM_WEC_PAYMENT_SRV_PROVIDERCHAR4COM_WEC_PAYMENT_SRV_PROVIDER
PAYS_TRANPayment Reference of Payment Service Provider FPS_TRANSACTIONCHAR35COM_WEC_PSP_TRANSACTION_ID
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
XFRGE_BSEGPayment Is Released XFRGE_BSEGCHAR1XFELD
.INCLU--AP 0
RE_BUKRSCash Ledger: Company Code for Expense/Revenue FAGL_RE_BUKRSCHAR4BUKRS
RE_ACCOUNTCash Ledger: Expense or Revenue Account FAGL_RE_ACCOUNTCHAR10ALPHASAKNR
.INCLU--AP 0
PGEBERPartner Fund FM_PFUNDCHAR10BP_GEBERPARTNER_FUND
PGRANT_NBRPartner Grant GM_GRANT_PARTNERCHAR20ALPHAGM_GRANT_NBRGRANTS_GENERIC
.INCLU--AP 0
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10FM_BUDGET_PERIODBUDPER
PBUDGET_PDFM: Partner Budget Period FM_PBUDGET_PERIODCHAR10FM_BUDGET_PERIODBUDPER
.INCLU--AP 0
PEROP_BEGBilling Period of Performance Start Date FM_PEROP_FI_LOWDATS8DATUM
PEROP_ENDBilling Period of Performance End Date FM_PEROP_FI_HIGHDATS8DATUM
FASTPAYPPA Fast Pay Indicator FMFG_FASTPAY_FLGCHAR1XFELD
IGNR_IVREFFMFG: Ignore the invoice reference during FI doc splitting FMFG_IGNORE_INV_REFCHAR1XFELD
.INCLU--AP 0
FMXDOCNRFM Reference Document Number FM_XDOCNRCHAR10ALPHABELNR
FMXYEARFM Reference Year FM_XYEARNUMC4GJAHRGJAHR
FMXDOCLNFM Reference Line Item FM_XDOCLNNUMC6NUMC6
FMXZEKKNFM Reference Sequence Account Assignment FM_XZEKKNNUMC5NUMC5
.INCLU--AP 0
PRODPERProduction Month (Date to find period and year) JV_PRODPERDATS8JV_PRODPER
TABNAME_DATA 0

Key field Non-key field



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

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

How to access SAP table FAGL_EMU_S_KEY5

Within an ECC or HANA version of SAP you can also view further information about FAGL_EMU_S_KEY5 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!