SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
1ERP EHP76.0GLPOS_N_GL_CT4571New General Ledger: Line Item with Currency Type
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, DEBIT, CREDIT, TURNOVER, COUNTER, CURTP, CURRUNIT, QUANTITY, QUANUNIT, CURRKEY_00, CURRVAL_00, CURRKEY_0D, CURRVAL_0D, CURRKEY_10, CURRVAL_10, CURRKEY_11, CURRVAL_11, CURRKEY_12, CURRVAL_12, CURRKEY_30, CURRVAL_30, CURRKEY_31, CURRVAL_31, CURRKEY_32, CURRVAL_32, CURRKEY_40, CURRVAL_40, CURRKEY_50, CURRVAL_50, CURRKEY_60, CURRVAL_60, ABPER, ADISC, AEDAT, AGZEI, ALTKT, ANBWA, ANFAE, ANFBJ, ANFBN, ANFBU, ANLN1, ANLN2, APLZL, ARCID, AUFNR, AUFPL, AUGBL, AUGCP, AUGDT, AUGGJ, AUSBK, AWKEY, AWSYS, AWTYP, BELNR, BEWAR, BKTXT, BLART, BLDAT, BLNPZ, BRNCH, BSCHL, BSTAT, BTYPE, BUDAT, BUKRS, BUPLA, BUSTW, BUZEI, BUZID, BVORG, BVTYP, BWKEY, BWTAR, BZDAT, CCBTC, CCINS, CCNUM, CESSION_KZ, CPUDT, CPUTM, DABRZ, DBBLG, DEPOT, DIEKZ, DISBJ, DISBN, DISBZ, DOCCAT, DOCLN, DOCNR, DOKID, DTWS1, DTWS2, DTWS3, DTWS4, DUEFL, EBELN, EBELP, EGBLD, EGLLD, EGRUP, ELIKZ, EMPFB, ESRNR, ESRPZ, ESRRE, ETEN2, ETYPE, FDGRP, FDLEV, FDTAG, FIKRS, FILKD, FIPOS, FISCPER, FISTL, FKBER_LONG, FKONT, GEBER, GITYP, GJAHR, GLUPM, GLVOR, GMVKZ, GRANT_NBR, GRICD, GRIRG, GRPID, GSBER, GVTYP, HBKID, HKONT, HKTID, HRKFT, HWMET, HZUON, IBLAR, IDXSP, IMKEY, INTRENO, KBLNR, KBLPOS, KIDNO, KKBER, KKTPL, KOART, KOKRS, KOSTL, KSTAR, KSTRG, KTOP2, KTOPL, KTOSL, KUNNR, KURSF, KURSR, KURST, LAND1, LANDL, LDGRP, LIFNR, LINETYPE, LINFV, LNRAN, LOKKT, LOTKZ, LSTAR, LZBKZ, MABER, MADAT, MANSP, MANST, MATNR, MEASURE, MONAT, MSCHL, MWART, MWSK1, MWSK2, MWSK3, MWSKZ, NPLNR, NUMPG, OBZEI, PARGB, PEINH, PENDAYS, PENRC, PERIV, PERNR, PFKBER, PGEBER, PGRANT_NBR, PKOSTL, POPER, POPTS, POSN2, PPA_EX_IND, PPNAM, PPRCT, PRCTR, PROJK, PROPMANO, PRZNR, PSALT, PSEGMENT, PYCUR, QSSKZ, QSZNR, REBZG, REBZJ, REBZT, REBZZ, RECID, REINDAT, RFZEI, RLDNR, RPACQ, RRCTY, RSTGR, RTCUR, RYACQ, RYEAR, SAKNR, SAMNR, SECCO, SEGMENT, SGTXT, SHKZG, SHZUZ, SPGRC, SPGRG, SPGRM, SPGRP, SPGRQ, SPGRS, SPGRT, SPGRV, SRTYPE, STBLG, STBUK, STCEG, STEKZ, STGRD, STJAH, STODT, TBTKZ, TCODE, TIMESTAMP, TXDAT, TXGRP, TXJCD, UMSKS, UMSKZ, UPDDT, USNAM, UZAWE, VALUT, VATDATE, VBEL2, VBELN, VBEWA, VBUND, VERTN, VERTT, VNAME, VORGN, VPRSV, VPTNR, VRSDT, VRSKZ, WAERS, WERKS, WVERW, WWERT, XANET, XAUTO, XBILK, XBLNR, XBLNR_ALT, XCPDD, XEGDR, XFAKT, XHKOM, XHRES, XINVE, XKRES, XMWST, XNCOP, XNEGP, XNETB, XOPVW, XPANZ, XPYPR, XRAGL, XREF1, XREF1_HD, XREF2, XREF2_HD, XREF3, XREVERSAL, XRUEB, XSAUF, XSERG, XSKRL, XSKST, XSNET, XSPLIT, XSPRO, XSTOV, XUMAN, XUMSW, XUSVR, XWVOF, XZAHL, ZBD1P, ZBD1T, ZBD2P, ZBD2T, ZBD3T, ZBFIX, ZEKKN, ZFBDT, ZINKZ, ZLSCH, ZLSPR, ZOLLD, ZOLLT, ZTERM, ZUMSK, ZUONR, /SAPF15/STATUS, BATCH, BLIND, BUDGET_PD, CASH_ALLOC, EXCLUDE_FLAG, FASTPAY, FMFGUS_KEY, FMXDOCLN, FMXDOCNR, FMXYEAR, FMXZEKKN, FM_UMART, FOLLOW_ON, IGNR_IVREF, INTDATE, INTFORM, KNUMV, MNDID, OFFSET_REFER_DAT, OFFSET_STATUS, PAYS_PROV, PAYS_TRAN, PBUDGET_PD, PEROP_BEG, PEROP_END, PRODPER, PSOAK, PSOBT, PSODT, PSOFN, PSOKS, PSOSG, PSOTM, PSOTY, PSOZL, RE_ACCOUNT, RE_BUKRS, SAMPLED, SNAME, SSBLK, TAXPS, XFRGE_BSEG, XLGCLR, XMCA, XREORG, ZZBUSPARTN, ZZCHAN, ZZLOB, ZZLOCA, ZZPRODUCT, ZZREGION, ZZSPREG, ZZSTATE, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, RP_KTEXT, RP_LTEXT, SP_KTEXT, SP_LTEXT, RF_FKBTX, SF_FKBTX, CC_KTEXT, CC_LTEXT, OR_KTEXT, MM_MAKTX, GA_TXT20, GA_TXT50, SK_TXT20, SK_TXT50, SKB1_BEGRU, SKB1_BUSAB, SKB1_DATLZ, SKB1_ERDAT, SKB1_ERNAM, SKB1_FDGRV, SKB1_FDLEV, SKB1_FIPLS, SKB1_FSTAG, SKB1_HBKID, SKB1_HKTID, SKB1_KDFSL, SKB1_MITKZ, SKB1_MWSKZ, SKB1_STEXT, SKB1_VZSKZ, SKB1_WAERS, SKB1_WMETH, SKB1_XGKON, SKB1_XINTB, SKB1_XKRES, SKB1_XLOEB, SKB1_XNKON, SKB1_XOPVW, SKB1_XSPEB, SKB1_ZINDT, SKB1_ZINRT, SKB1_ZUAWA, SKB1_ALTKT, SKB1_XMITK, SKB1_RECID, SKB1_FIPOS, SKB1_XMWNO, SKB1_XSALH, SKB1_BEWGP, SKB1_INFKY, SKB1_TOGRU, SKB1_XLGCLR, SKA1_XBILK, SKA1_SAKAN, SKA1_BILKT, SKA1_ERDAT, SKA1_ERNAM, SKA1_GVTYP, SKA1_KTOKS, SKA1_MUSTR, SKA1_VBUND, SKA1_XLOEV, SKA1_XSPEA, SKA1_XSPEB, SKA1_XSPEP, SKA1_MCOD1, SKA1_FUNC_AREA FROM GLPOS_N_GL_CT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DEBITTotal Debit Postingsdecimal232CURR((0))YesFAGL_UMSOL
3CREDITTotal Credit Postingsdecimal232CURR((0))YesFAGL_UMHAB
4TURNOVERBalancedecimal232CURR((0))YesFAGL_SALES
5COUNTERProcessed Database Table Rowsint100INT4((0))YesSYDBCNT Allow NULL? 
6CURTPCurrency Type and Valuation Viewnvarchar20CHAR(N' ')YesCURTP Allow NULL? 
7CURRUNITCurrency Keynvarchar50CUKY(N' ')Yes*RSCURRENCY Allow NULL? 
8QUANTITYQuantitydecimal233QUAN((0))YesQUAN1_12
9QUANUNITUnit of Measurenvarchar30UNIT(N' ')Yes*ROUNIT Allow NULL? 
10CURRKEY_00Update Currency for General Ledger Totals Datanvarchar50CUKY(N' ')Yes*FAGL_CURRKEY_00 Allow NULL? 
11CURRVAL_00Update Currency Value for General Ledger Totals Datadecimal232CURR((0))YesFAGL_CURRVAL_00
12CURRKEY_0DDocument Currency Keynvarchar50CUKY(N' ')Yes*FAGL_CURRKEY_0D Allow NULL? 
13CURRVAL_0DDocument Currency Valuedecimal232CURR((0))YesFAGL_CURRVAL_0D
14CURRKEY_10Company Code Currency Keynvarchar50CUKY(N' ')Yes*FAGL_CURRKEY_10 Allow NULL? 
15CURRVAL_10Company Code Currency Valuedecimal232CURR((0))YesFAGL_CURRVAL_10
16CURRKEY_11Company Code Currency Key, Group Valuationnvarchar50CUKY(N' ')Yes*FAGL_CURRKEY_11 Allow NULL? 
17CURRVAL_11Company Code Currency Value, Group Valuationdecimal232CURR((0))YesFAGL_CURRVAL_11
18CURRKEY_12Company Code Currency Key, Profit Center Valuationnvarchar50CUKY(N' ')Yes*FAGL_CURRKEY_12 Allow NULL? 
19CURRVAL_12Company Code Currency Value, Profit Center Valuationdecimal232CURR((0))YesFAGL_CURRVAL_12
20CURRKEY_30Group Currency Keynvarchar50CUKY(N' ')Yes*FAGL_CURRKEY_30 Allow NULL? 
21CURRVAL_30Group Currency Valuedecimal232CURR((0))YesFAGL_CURRVAL_30
22CURRKEY_31Group Currency Key, Group Valuationnvarchar50CUKY(N' ')Yes*FAGL_CURRKEY_31 Allow NULL? 
23CURRVAL_31Group Currency Value, Group Valuationdecimal232CURR((0))YesFAGL_CURRVAL_31
24CURRKEY_32Group Currency Key, Profit Center Valuationnvarchar50CUKY(N' ')Yes*FAGL_CURRKEY_32 Allow NULL? 
25CURRVAL_32Group Currency Value, Profit Center Valuationdecimal232CURR((0))YesFAGL_CURRVAL_32
26CURRKEY_40Hard Currency Keynvarchar50CUKY(N' ')Yes*FAGL_CURRKEY_40 Allow NULL? 
27CURRVAL_40Hard Currency Valuedecimal232CURR((0))YesFAGL_CURRVAL_40
28CURRKEY_50Index Currency Keynvarchar50CUKY(N' ')Yes*FAGL_CURRKEY_50 Allow NULL? 
29CURRVAL_50Index Currency Valuedecimal232CURR((0))YesFAGL_CURRVAL_50
30CURRKEY_60Global Company Currency Keynvarchar50CUKY(N' ')Yes*FAGL_CURRKEY_60 Allow NULL? 
31CURRVAL_60Global Company Currency Valuedecimal232CURR((0))YesFAGL_CURRVAL_60
32ABPERSettlement Periodnvarchar60NUMC(N'000000')YesFAGL_SETTLEMENT_PERIOD Allow NULL? 
33ADISCIndicator: entry represents a discount documentchar10CHAR(N' ')YesJ_1ADISC Allow NULL? 
34AEDATDate of the Last Document Change by Transactionnvarchar80DATS(N'00000000')YesAEDAT_BKPF Allow NULL? 
35AGZEIClearing Itemdecimal50DEC((0))YesAGZEI
36ALTKTGroup account numbernvarchar100CHAR(N' ')Yes*BILKT_SKA1 Allow NULL? 
37ANBWAAsset Transaction Typenvarchar30CHAR(N' ')Yes*ANBWA Allow NULL? 
38ANFAEBill of Exchange Payment Request Due Datenvarchar80DATS(N'00000000')YesANFAE Allow NULL? 
39ANFBJFiscal Year of the Bill of Exchange Payment Request Documentnvarchar40NUMC(N'0000')YesANFBJ Allow NULL? 
40ANFBNDocument Number of the Bill of Exchange Payment Requestnvarchar100CHAR(N' ')YesANFBN Allow NULL? 
41ANFBUCompany Code in Which Bill of Exch.Payment Request Is Postednvarchar40CHAR(N' ')Yes*ANFBU Allow NULL? 
42ANLN1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
43ANLN2Asset Subnumbernvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
44APLZLGeneral counter for ordernvarchar80NUMC(N'00000000')Yes*APLZL_CH Allow NULL? 
45ARCIDExtract ID Document Headernvarchar100CHAR(N' ')YesEXTID_BKPF Allow NULL? 
46AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
47AUFPLTask list number for operations in ordernvarchar100NUMC(N'0000000000')YesAUFPL_CH Allow NULL? 
48AUGBLDocument Number of the Clearing Documentnvarchar100CHAR(N' ')YesAUGBL Allow NULL? 
49AUGCPClearing Entry Datenvarchar80DATS(N'00000000')YesAUGCP Allow NULL? 
50AUGDTClearing Datenvarchar80DATS(N'00000000')YesAUGDT Allow NULL? 
51AUGGJFiscal Year of Clearing Documentnvarchar40NUMC(N'0000')YesAUGGJ Allow NULL? 
52AUSBKSource Company Codenvarchar40CHAR(N' ')Yes*AUSBK Allow NULL? 
53AWKEYReference Keynvarchar200CHAR(N' ')YesAWKEY Allow NULL? 
54AWSYSLogical systemnvarchar100CHAR(N' ')Yes*LOGSYS Allow NULL? 
55AWTYPReference Transactionnvarchar50CHAR(N' ')Yes*AWTYP Allow NULL? 
56BELNRAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
57BEWARTransaction Typenvarchar30CHAR(N' ')Yes*RMVCT Allow NULL? 
58BKTXTDocument Header Textnvarchar250CHAR(N' ')YesBKTXT Allow NULL? 
59BLARTDocument Typenvarchar20CHAR(N' ')Yes*BLART Allow NULL? 
60BLDATDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
61BLNPZPreference Percentage Ratedecimal72DEC((0))YesBLNPZ
62BRNCHBranch Numbernvarchar40CHAR(N' ')Yes*J_1ABRNCH Allow NULL? 
63BSCHLPosting Keynvarchar20CHAR(N' ')Yes*BSCHL Allow NULL? 
64BSTATDocument Statuschar10CHAR(N' ')YesBSTAT_D Allow NULL? 
65BTYPEPayroll Typenvarchar20CHAR(N' ')Yes*JV_BILIND Allow NULL? 
66BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
67BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
68BUPLABusiness Placenvarchar40CHAR(N' ')Yes*BUPLA Allow NULL? 
69BUSTWPosting string for valuesnvarchar40CHAR(N' ')YesBUSTW Allow NULL? 
70BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')YesBUZEI Allow NULL? 
71BUZIDIdentification of the Line Itemchar10CHAR(N' ')YesBUZID Allow NULL? 
72BVORGNumber of Cross-Company Code Posting Transactionnvarchar160CHAR(N' ')YesBVORG Allow NULL? 
73BVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
74BWKEYValuation Areanvarchar40CHAR(N' ')Yes*BWKEY Allow NULL? 
75BWTARValuation Typenvarchar100CHAR(N' ')Yes*BWTAR_D Allow NULL? 
76BZDATAsset value datenvarchar80DATS(N'00000000')YesBZDAT Allow NULL? 
77CCBTCPayment cards: Settlement runnvarchar100CHAR(N' ')YesCCBTC Allow NULL? 
78CCINSPayment cards: Card typenvarchar40CHAR(N' ')Yes*CCINS_30F Allow NULL? 
79CCNUMPayment cards: Card numbernvarchar250CHAR(N' ')YesCCNUM_30F Allow NULL? 
80CESSION_KZAccounts Receivable Pledging Indicatornvarchar20CHAR(N' ')Yes*CESSION_KZ Allow NULL? 
81CPUDTDay On Which Accounting Document Was Enterednvarchar80DATS(N'00000000')YesCPUDT Allow NULL? 
82CPUTMTime of Entrynvarchar60TIMS(N'000000')YesCPUTM Allow NULL? 
83DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
84DBBLGRecurring Entry Document Numbernvarchar100CHAR(N' ')YesDBBLG Allow NULL? 
85DEPOTSecurities Accountnvarchar100CHAR(N' ')Yes*RLDEPO Allow NULL? 
86DIEKZService Indicator (Foreign Payment)char10CHAR(N' ')YesDIEKZ Allow NULL? 
87DISBJFiscal Year of Bill of Exchange Usage Documentnvarchar40NUMC(N'0000')YesDISBJ Allow NULL? 
88DISBNNumber of Bill of Exchange Usage Document (Discount Doc.)nvarchar100CHAR(N' ')YesDISBN Allow NULL? 
89DISBZLine Item within the Bill of Exchange Usage Documentnvarchar30NUMC(N'000')YesDISBZ Allow NULL? 
90DOCCATClassification of an FI Documentnvarchar60CHAR(N' ')YesDOCUMENT_CATEGORY Allow NULL? 
91DOCLNSix-Character Posting Item for Ledgernvarchar60CHAR(N' ')YesDOCLN6 Allow NULL? 
92DOCNRAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
93DOKIDDocument Name in the Archive Systemnvarchar400CHAR(N' ')YesDOKID_BKPF Allow NULL? 
94DTWS1Instruction key 1nvarchar20NUMC(N'00')Yes*DTAT16 Allow NULL? 
95DTWS2Instruction key 2nvarchar20NUMC(N'00')Yes*DTAT17 Allow NULL? 
96DTWS3Instruction key 3nvarchar20NUMC(N'00')Yes*DTAT18 Allow NULL? 
97DTWS4Instruction key 4nvarchar20NUMC(N'00')Yes*DTAT19 Allow NULL? 
98DUEFLStatus of Data Transfer into Subsequent Releasechar10CHAR(N' ')YesDUEFL_BKPF Allow NULL? 
99EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
100EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
101EGBLDCountry of Destination for Delivery of Goodsnvarchar30CHAR(N' ')Yes*EGBLD Allow NULL? 
102EGLLDSupplying Country for Delivery of Goodsnvarchar30CHAR(N' ')Yes*EGLLD Allow NULL? 
103EGRUPEquity groupnvarchar30CHAR(N' ')Yes*JV_EGROUP Allow NULL? 
104ELIKZ"Delivery Completed" Indicatorchar10CHAR(N' ')YesELIKZ Allow NULL? 
105EMPFBPayee/Payernvarchar100CHAR(N' ')YesEMPFB Allow NULL? 
106ESRNRISR Subscriber Numbernvarchar110CHAR(N' ')YesESRNR Allow NULL? 
107ESRPZISR Check Digitnvarchar20CHAR(N' ')YesESRPZ Allow NULL? 
108ESRREISR Reference Numbernvarchar270CHAR(N' ')YesESRRE Allow NULL? 
109ETEN2Delivery Schedule Line Numbernvarchar40NUMC(N'0000')Yes*ETENR Allow NULL? 
110ETYPEEquity typenvarchar30CHAR(N' ')Yes*JV_ETYPE Allow NULL? 
111FDGRPPlanning Groupnvarchar100CHAR(N' ')Yes*FDGRP Allow NULL? 
112FDLEVPlanning levelnvarchar20CHAR(N' ')Yes*FDLEV Allow NULL? 
113FDTAGPlanning datenvarchar80DATS(N'00000000')YesFDTAG Allow NULL? 
114FIKRSFinancial Management Areanvarchar40CHAR(N' ')Yes*FIKRS Allow NULL? 
115FILKDAccount Number of the Branchnvarchar100CHAR(N' ')YesFILKD Allow NULL? 
116FIPOSCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
117FISCPERFiscal year / periodnvarchar70NUMC(N'0000000')YesRSFISCPER Allow NULL? 
118FISTLFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
119FKBER_LONGFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
120FKONTFinancial Budget Itemnvarchar30NUMC(N'000')YesFIPLS Allow NULL? 
121GEBERFundnvarchar100CHAR(N' ')Yes*BP_GEBER Allow NULL? 
122GITYPDistribution Type for Employment Taxnvarchar20CHAR(N' ')Yes*J_1ADTYP_D Allow NULL? 
123GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
124GLUPMUpdate Method for FM - FI-CA Integrationchar10CHAR(N' ')YesGLUPM Allow NULL? 
125GLVORBusiness Transactionnvarchar40CHAR(N' ')YesGLVOR Allow NULL? 
126GMVKZItem is in Executionchar10CHAR(N' ')YesFM_GMVKZ Allow NULL? 
127GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
128GRICDActivity Code for Gross Income Taxnvarchar20CHAR(N' ')Yes*J_1AGICD_D Allow NULL? 
129GRIRGRegion (State, Province, County)nvarchar30CHAR(N' ')Yes*REGIO Allow NULL? 
130GRPIDBatch Input Session Namenvarchar120CHAR(N' ')YesGRPID_BKPF Allow NULL? 
131GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
132GVTYPP&L statement account typenvarchar20CHAR(N' ')YesGVTYP Allow NULL? 
133HBKIDShort Key for a House Banknvarchar50CHAR(N' ')Yes*HBKID Allow NULL? 
134HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')Yes*HKONT Allow NULL? 
135HKTIDID for account detailsnvarchar50CHAR(N' ')Yes*HKTID Allow NULL? 
136HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40CHAR(N' ')Yes*HRKFT Allow NULL? 
137HWMETMethod with Which the Local Currency Amount Was Determinedchar10CHAR(N' ')YesHWMET Allow NULL? 
138HZUONAssignment Number for Special G/L Accountsnvarchar180CHAR(N' ')YesHZUON Allow NULL? 
139IBLARInternal Document Type for Document Controlnvarchar20CHAR(N' ')YesIBLAR Allow NULL? 
140IDXSPInflation Indexnvarchar50CHAR(N' ')Yes*J_1AINDXSP Allow NULL? 
141IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
142INTRENOInternal Real Estate Master Data Codenvarchar130CHAR(N' ')YesVVINTRENO Allow NULL? 
143KBLNRDocument Number for Earmarked Fundsnvarchar100CHAR(N' ')Yes*KBLNR_FI Allow NULL? 
144KBLPOSEarmarked Funds: Document Itemnvarchar30NUMC(N'000')Yes*KBLPOS Allow NULL? 
145KIDNOPayment Referencenvarchar300CHAR(N' ')YesKIDNO Allow NULL? 
146KKBERCredit control areanvarchar40CHAR(N' ')Yes*KKBER Allow NULL? 
147KKTPLGroup Chart of Acctsnvarchar40CHAR(N' ')Yes*KKTPL Allow NULL? 
148KOARTAccount Typechar10CHAR(N' ')YesKOART Allow NULL? 
149KOKRSControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
150KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
151KSTARCost Elementnvarchar100CHAR(N' ')Yes*KSTAR Allow NULL? 
152KSTRGCost Objectnvarchar120CHAR(N' ')Yes*KSTRG Allow NULL? 
153KTOP2Chart of Accounts According to Country Legislationnvarchar40CHAR(N' ')Yes*KTOP2 Allow NULL? 
154KTOPLChart of Accountsnvarchar40CHAR(N' ')Yes*KTOPL Allow NULL? 
155KTOSLTransaction Keynvarchar30CHAR(N' ')YesKTOSL Allow NULL? 
156KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
157KURSFExchange ratedecimal95DEC((0))YesKURSF
158KURSRHedged Exchange Ratedecimal95DEC((0))YesKURSR
159KURSTExchange Rate Typenvarchar40CHAR(N' ')Yes*KURST Allow NULL? 
160LAND1Country Keynvarchar30CHAR(N' ')Yes*LAND1 Allow NULL? 
161LANDLSupplying Countrynvarchar30CHAR(N' ')Yes*LANDL Allow NULL? 
162LDGRPLedger Groupnvarchar40CHAR(N' ')Yes*FAGL_LDGRP Allow NULL? 
163LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
164LINETYPEItem categorynvarchar50CHAR(N' ')Yes*LINETYPE Allow NULL? 
165LINFVLast Adjustment Datenvarchar80DATS(N'00000000')YesJ_1ALINFVL Allow NULL? 
166LNRANSequence number of asset line items in fiscal yearnvarchar50NUMC(N'00000')Yes*LNRAN Allow NULL? 
167LOKKTAlternative account number in company codenvarchar100CHAR(N' ')Yes*ALTKT_SKB1 Allow NULL? 
168LOTKZLot Number for Requestsnvarchar100CHAR(N' ')YesPSO_LOTKZ Allow NULL? 
169LSTARActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
170LZBKZState Central Bank Indicatornvarchar30CHAR(N' ')Yes*LZBKZ Allow NULL? 
171MABERDunning Areanvarchar20CHAR(N' ')Yes*MABER Allow NULL? 
172MADATLast dunned onnvarchar80DATS(N'00000000')YesMADAT Allow NULL? 
173MANSPDunning blockchar10CHAR(N' ')Yes*MANSP Allow NULL? 
174MANSTDunning levelchar10NUMC(N'0')YesMAHNS_D Allow NULL? 
175MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
176MEASUREFunded Programnvarchar240CHAR(N' ')Yes*FM_MEASURE Allow NULL? 
177MONATFiscal Periodnvarchar20NUMC(N'00')YesMONAT Allow NULL? 
178MSCHLDunning keychar10CHAR(N' ')Yes*MSCHL Allow NULL? 
179MWARTTax Typechar10CHAR(N' ')YesMWART Allow NULL? 
180MWSK1Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
181MWSK2Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
182MWSK3Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
183MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
184NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
185NUMPGNumber of pages of invoicenvarchar30NUMC(N'000')YesJ_1ANOPG Allow NULL? 
186OBZEINumber of Line Item in Original Documentnvarchar30NUMC(N'000')YesOBZEI Allow NULL? 
187PARGBTrading partner's business areanvarchar40CHAR(N' ')Yes*PARGB Allow NULL? 
188PEINHPrice Unitdecimal50DEC((0))YesPEINH
189PENDAYSNumber of days for penalty charge calculationint100INT4((0))YesPDAYS Allow NULL? 
190PENRCReason for late paymentnvarchar20CHAR(N' ')YesPENRC Allow NULL? 
191PERIVFiscal Year Variantnvarchar20CHAR(N' ')Yes*PERIV Allow NULL? 
192PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
193PFKBERPartner Functional Areanvarchar160CHAR(N' ')Yes*SFKBER Allow NULL? 
194PGEBERPartner Fundnvarchar100CHAR(N' ')Yes*FM_PFUND Allow NULL? 
195PGRANT_NBRPartner Grantnvarchar200CHAR(N' ')YesGM_GRANT_PARTNER Allow NULL? 
196PKOSTLSender cost centernvarchar100CHAR(N' ')Yes*SKOST Allow NULL? 
197POPERPosting periodnvarchar30NUMC(N'000')YesPOPER Allow NULL? 
198POPTSReal estate option ratedecimal96DEC((0))YesPOPTSATZ
199POSN2Sales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
200PPA_EX_INDPPA Exclude Indicatorchar10CHAR(N' ')YesEXCLUDE_FLG Allow NULL? 
201PPNAMName of User Who Parked this Documentnvarchar120CHAR(N' ')Yes*PPNAM Allow NULL? 
202PPRCTPartner Profit Centernvarchar100CHAR(N' ')Yes*PPRCTR Allow NULL? 
203PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
204PROJKWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
205PROPMANOReal Estate Management Mandatenvarchar130CHAR(N' ')YesRE_MANDAT Allow NULL? 
206PRZNRBusiness Processnvarchar120CHAR(N' ')Yes*CO_PRZNR Allow NULL? 
207PSALTAlternative Price Controlchar10CHAR(N' ')YesPSALT Allow NULL? 
208PSEGMENTPartner Segment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_PSEGMENT Allow NULL? 
209PYCURCurrency for Automatic Paymentnvarchar50CUKY(N' ')Yes*PYCUR Allow NULL? 
210QSSKZWithholding Tax Codenvarchar20CHAR(N' ')Yes*QSSKZ Allow NULL? 
211QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100CHAR(N' ')YesQSZNR Allow NULL? 
212REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
213REBZJFiscal Year of the Relevant Invoice (for Credit Memo)nvarchar40NUMC(N'0000')YesREBZJ Allow NULL? 
214REBZTFollow-On Document Typechar10CHAR(N' ')YesREBZT Allow NULL? 
215REBZZLine Item in the Relevant Invoicenvarchar30NUMC(N'000')YesREBZZ Allow NULL? 
216RECIDRecovery Indicatornvarchar20CHAR(N' ')Yes*JV_RECIND Allow NULL? 
217REINDATInvoice Receipt Datenvarchar80DATS(N'00000000')YesREINDAT Allow NULL? 
218RFZEIPayment Card Itemnvarchar30NUMC(N'000')YesRFZEI_CC Allow NULL? 
219RLDNRLedger in General Ledger Accountingnvarchar20CHAR(N' ')Yes*FAGL_RLDNR Allow NULL? 
220RPACQPeriod of Acquisitionnvarchar30NUMC(N'000')YesRPACQ Allow NULL? 
221RRCTYRecord Typechar10CHAR(N' ')YesRRCTY Allow NULL? 
222RSTGRReason Code for Paymentsnvarchar30CHAR(N' ')Yes*RSTGR Allow NULL? 
223RTCURCurrency Keynvarchar50CUKY(N' ')Yes*RTCUR Allow NULL? 
224RYACQYear of acquisitionnvarchar40CHAR(N' ')YesRYACQ Allow NULL? 
225RYEARFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
226SAKNRG/L Account Numbernvarchar100CHAR(N' ')Yes*SAKNR Allow NULL? 
227SAMNRInvoice List Numbernvarchar80NUMC(N'00000000')YesSAMNR Allow NULL? 
228SECCOSection Codenvarchar40CHAR(N' ')Yes*SECCO Allow NULL? 
229SEGMENTSegment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_SEGMENT Allow NULL? 
230SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
231SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
232SHZUZDebit/Credit Addition for Cash Discountchar10CHAR(N' ')YesSHZUZ Allow NULL? 
233SPGRCBlock.reason: qualitychar10CHAR(N' ')YesSPGRC Allow NULL? 
234SPGRGBlocking reason: order price quantitychar10CHAR(N' ')YesSPGRG Allow NULL? 
235SPGRMBlocking reason: quantitychar10CHAR(N' ')YesSPGRM Allow NULL? 
236SPGRPBlocking reason: pricechar10CHAR(N' ')YesSPGRP Allow NULL? 
237SPGRQManual Blocking Reasonchar10CHAR(N' ')YesSPGRQ Allow NULL? 
238SPGRSBlocking Reason: Item Amountchar10CHAR(N' ')YesSPGRS Allow NULL? 
239SPGRTBlocking Reason: Datechar10CHAR(N' ')YesSPGRT Allow NULL? 
240SPGRVBlocking reason: project budgetchar10CHAR(N' ')YesSPGRV Allow NULL? 
241SRTYPEType of Additional Receivablenvarchar20CHAR(N' ')YesFM_SRTYPE Allow NULL? 
242STBLGReverse Document Numbernvarchar100CHAR(N' ')YesSTBLG Allow NULL? 
243STBUKTax Company Codenvarchar40CHAR(N' ')Yes*STBUK Allow NULL? 
244STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
245STEKZVersion Number Componentnvarchar20CHAR(N' ')YesCHAR2 Allow NULL? 
246STGRDReason for Reversalnvarchar20CHAR(N' ')Yes*STGRD Allow NULL? 
247STJAHReverse document fiscal yearnvarchar40NUMC(N'0000')YesSTJAH Allow NULL? 
248STODTPlanned Date for the Reverse Postingnvarchar80DATS(N'00000000')YesSTODT Allow NULL? 
249TBTKZIndicator: subsequent debit/creditchar10CHAR(N' ')YesTBTKZ Allow NULL? 
250TCODETransaction Codenvarchar200CHAR(N' ')Yes*TCODE Allow NULL? 
251TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))YesTIMESTAMP
252TXDATDate for defining tax ratesnvarchar80DATS(N'00000000')YesTXDAT Allow NULL? 
253TXGRPGroup Indicator for Tax Line Itemsnvarchar30NUMC(N'000')YesTXGRP Allow NULL? 
254TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
255UMSKSSpecial G/L Transaction Typechar10CHAR(N' ')YesUMSKS Allow NULL? 
256UMSKZSpecial G/L Indicatorchar10CHAR(N' ')Yes*UMSKZ Allow NULL? 
257UPDDTDate of the Last Document Updatenvarchar80DATS(N'00000000')YesUPDDT Allow NULL? 
258USNAMUser namenvarchar120CHAR(N' ')Yes*USNAM Allow NULL? 
259UZAWEPayment Method Supplementnvarchar20CHAR(N' ')Yes*UZAWE Allow NULL? 
260VALUTValue datenvarchar80DATS(N'00000000')YesVALUT Allow NULL? 
261VATDATETax Reporting Datenvarchar80DATS(N'00000000')YesVATDATE Allow NULL? 
262VBEL2Sales Documentnvarchar100CHAR(N' ')Yes*VBELN_VA Allow NULL? 
263VBELNBilling Documentnvarchar100CHAR(N' ')Yes*VBELN_VF Allow NULL? 
264VBEWAFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
265VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')Yes*RASSC Allow NULL? 
266VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
267VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
268VNAMEJoint Venturenvarchar60CHAR(N' ')Yes*JV_NAME Allow NULL? 
269VORGNTransaction Type for General Ledgernvarchar40CHAR(N' ')YesVORGN Allow NULL? 
270VPRSVPrice control indicatorchar10CHAR(N' ')YesVPRSV Allow NULL? 
271VPTNRPartner account numbernvarchar100CHAR(N' ')Yes*JV_PART Allow NULL? 
272VRSDTInsurance datenvarchar80DATS(N'00000000')YesVRSDT Allow NULL? 
273VRSKZInsurance indicatorchar10CHAR(N' ')YesVRSKZ Allow NULL? 
274WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
275WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
276WVERWBill of exchange usage typechar10CHAR(N' ')YesWVERW Allow NULL? 
277WWERTTranslation Datenvarchar80DATS(N'00000000')YesWWERT_D Allow NULL? 
278XANETIndicator: Down payment in net procedure ?char10CHAR(N' ')YesXANET Allow NULL? 
279XAUTOIndicator: Line item automatically createdchar10CHAR(N' ')YesXAUTO Allow NULL? 
280XBILKIndicator: Account is a balance sheet account?char10CHAR(N' ')YesXBILK Allow NULL? 
281XBLNRReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
282XBLNR_ALTAlternative Reference Numbernvarchar260CHAR(N' ')YesXBLNR_ALT Allow NULL? 
283XCPDDIndicator: Address and bank data set individuallychar10CHAR(N' ')YesXCPDD Allow NULL? 
284XEGDRIndicator: Triangular deal within the EU ?char10CHAR(N' ')YesXEGDR Allow NULL? 
285XFAKTIndicator: Billing document update successful ?char10CHAR(N' ')YesXFAKT Allow NULL? 
286XHKOMIndicator: G/L account assigned manually ?char10CHAR(N' ')YesXHKOM Allow NULL? 
287XHRESIndicator: Resident G/L account?char10CHAR(N' ')YesXHRES Allow NULL? 
288XINVEIndicator: Capital Goods Affected?char10CHAR(N' ')YesXINVE Allow NULL? 
289XKRESIndicator: Can Line Items Be Displayed by Account?char10CHAR(N' ')YesXKRES Allow NULL? 
290XMWSTCalculate tax automaticallychar10CHAR(N' ')YesXMWST Allow NULL? 
291XNCOPIndicator: Items cannot be copied?char10CHAR(N' ')YesXNCOP Allow NULL? 
292XNEGPIndicator: Negative postingchar10CHAR(N' ')YesXNEGP Allow NULL? 
293XNETBIndicator: Document posted net ?char10CHAR(N' ')YesXNETB Allow NULL? 
294XOPVWIndicator: Open Item Management?char10CHAR(N' ')YesXOPVW Allow NULL? 
295XPANZDisplay itemchar10CHAR(N' ')YesXPANZ Allow NULL? 
296XPYPRIndicator: Items from Payment Program Blockedchar10CHAR(N' ')YesXPYPR Allow NULL? 
297XRAGLIndicator: Clearing was Reversedchar10CHAR(N' ')YesXRAGL Allow NULL? 
298XREF1Business partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
299XREF1_HDReference Key 1 Internal for Document Headernvarchar200CHAR(N' ')YesXREF1_HD Allow NULL? 
300XREF2Business partner reference keynvarchar120CHAR(N' ')YesXREF2 Allow NULL? 
301XREF2_HDReference Key 2 Internal for Document Headernvarchar200CHAR(N' ')YesXREF2_HD Allow NULL? 
302XREF3Reference key for line itemnvarchar200CHAR(N' ')YesXREF3 Allow NULL? 
303XREVERSALSpecifies whether doc. is reversal doc. or reversed doc.char10CHAR(N' ')YesXREVERSAL Allow NULL? 
304XRUEBIndicator: Document is posted to a previous periodchar10CHAR(N' ')YesXRUEB Allow NULL? 
305XSAUFIndicator: Posting to order is statisticalchar10CHAR(N' ')YesXSAUF Allow NULL? 
306XSERGIndicator: Posting to prof.analysis is statisticalchar10CHAR(N' ')YesXSERG Allow NULL? 
307XSKRLIndicator: Line item not liable to cash discount?char10CHAR(N' ')YesXSKRL Allow NULL? 
308XSKSTIndicator: Statistical posting to cost centerchar10CHAR(N' ')YesXSKST Allow NULL? 
309XSNETG/L account amounts entered exclude taxchar10CHAR(N' ')YesXSNET Allow NULL? 
310XSPLITFI Document Originates from Split Posting (Indicator)char10CHAR(N' ')YesSPLIT_POSTING Allow NULL? 
311XSPROIndicator: Posting to project is statisticalchar10CHAR(N' ')YesXSPRO Allow NULL? 
312XSTOVIndicator: Document is flagged for reversalchar10CHAR(N' ')YesXSTOV Allow NULL? 
313XUMANIndicator: Transfer posting from down payment ?char10CHAR(N' ')YesXUMAN Allow NULL? 
314XUMSWIndicator: Sales-related item ?char10CHAR(N' ')YesXUMSW Allow NULL? 
315XUSVRIndicator: US taxes changed at detail level ?char10CHAR(N' ')YesXUSVR_BKPF Allow NULL? 
316XWVOFIndicator: Customer bill of exchange payment before due datechar10CHAR(N' ')YesXWVOF Allow NULL? 
317XZAHLIndicator: Is the posting key used in a payment transaction?char10CHAR(N' ')YesXZAHL Allow NULL? 
318ZBD1PCash Discount Percentage 1decimal53DEC((0))YesDZBD1P
319ZBD1TCash discount days 1decimal30DEC((0))YesDZBD1T
320ZBD2PCash Discount Percentage 2decimal53DEC((0))YesDZBD2P
321ZBD2TCash discount days 2decimal30DEC((0))YesDZBD2T
322ZBD3TNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
323ZBFIXFixed Payment Termschar10CHAR(N' ')YesDZBFIX Allow NULL? 
324ZEKKNSequential Number of Account Assignmentnvarchar20NUMC(N'00')YesDZEKKN Allow NULL? 
325ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
326ZINKZExempted from interest calculationnvarchar20CHAR(N' ')YesDZINKZ Allow NULL? 
327ZLSCHPayment Methodchar10CHAR(N' ')Yes*SCHZW_BSEG Allow NULL? 
328ZLSPRPayment Block Keychar10CHAR(N' ')Yes*DZLSPR Allow NULL? 
329ZOLLDCustoms Datenvarchar80DATS(N'00000000')YesDZOLLD Allow NULL? 
330ZOLLTCustoms Tariff Numbernvarchar80CHAR(N' ')YesDZOLLT Allow NULL? 
331ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
332ZUMSKTarget Special G/L Indicatorchar10CHAR(N' ')Yes*DZUMSK Allow NULL? 
333ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
334/SAPF15/STATUSchar10(N' ')Yes Allow NULL? 
335BATCHLot Number for Documentsnvarchar100CHAR(N' ')YesLOTKZ Allow NULL? 
336BLINDBudgetary Ledger Indicatorchar10CHAR(N' ')YesFM_BLIND Allow NULL? 
337BUDGET_PDFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
338CASH_ALLOCCash-Relevant Documentchar10CHAR(N' ')YesFAGL_CASH_ALLOC Allow NULL? 
339EXCLUDE_FLAGPPA Exclude Indicatorchar10CHAR(N' ')YesEXCLUDE_FLG Allow NULL? 
340FASTPAYPPA Fast Pay Indicatorchar10CHAR(N' ')YesFMFG_FASTPAY_FLG Allow NULL? 
341FMFGUS_KEYUnited States Federal Government Fieldsnvarchar220CHAR(N' ')YesFMFG_US_KEY Allow NULL? 
342FMXDOCLNFM Reference Line Itemnvarchar60NUMC(N'000000')YesFM_XDOCLN Allow NULL? 
343FMXDOCNRFM Reference Document Numbernvarchar100CHAR(N' ')YesFM_XDOCNR Allow NULL? 
344FMXYEARFM Reference Yearnvarchar40NUMC(N'0000')YesFM_XYEAR Allow NULL? 
345FMXZEKKNFM Reference Sequence Account Assignmentnvarchar50NUMC(N'00000')YesFM_XZEKKN Allow NULL? 
346FM_UMARTType of Payment Transferchar10CHAR(N' ')YesFM_UMART Allow NULL? 
347FOLLOW_ONFollow-on document indicatorchar10CHAR(N' ')YesFAGL_FOLLOW_ON Allow NULL? 
348IGNR_IVREFFMFG: Ignore the invoice reference during FI doc splittingchar10CHAR(N' ')YesFMFG_IGNORE_INV_REF Allow NULL? 
349INTDATEInterest Calc. Datenvarchar80DATS(N'00000000')YesFM_INTDATE Allow NULL? 
350INTFORMInterest Formulanvarchar40CHAR(N' ')YesFM_INTFORM Allow NULL? 
351KNUMVNumber of the document conditionnvarchar100CHAR(N' ')YesKNUMV Allow NULL? 
352MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350CHAR(N' ')YesSEPA_MNDID Allow NULL? 
353OFFSET_REFER_DATDate Record Referred to Treasurynvarchar80DATS(N'00000000')YesFMFG_REFERRED_OFFSET_DAT Allow NULL? 
354OFFSET_STATUSTreasury Offset Statusnvarchar20CHAR(N' ')YesFMFG_OFFSET_STATUS Allow NULL? 
355PAYS_PROVPayment Service Providernvarchar40CHAR(N' ')Yes*COM_WEC_PAYMENT_SRV_PROVIDER Allow NULL? 
356PAYS_TRANPayment Reference of Payment Service Providernvarchar350CHAR(N' ')YesFPS_TRANSACTION Allow NULL? 
357PBUDGET_PDFM: Partner Budget Periodnvarchar100CHAR(N' ')Yes*FM_PBUDGET_PERIOD Allow NULL? 
358PEROP_BEGBilling Period of Performance Start Datenvarchar80DATS(N'00000000')YesFM_PEROP_FI_LOW Allow NULL? 
359PEROP_ENDBilling Period of Performance End Datenvarchar80DATS(N'00000000')YesFM_PEROP_FI_HIGH Allow NULL? 
360PRODPERProduction Month (Date to find period and year)nvarchar80DATS(N'00000000')YesJV_PRODPER Allow NULL? 
361PSOAKReasonnvarchar100CHAR(N' ')Yes*PSOAK Allow NULL? 
362PSOBTPosting Daynvarchar80DATS(N'00000000')YesPSOBT Allow NULL? 
363PSODTChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
364PSOFNIS-PS: File numbernvarchar300CHAR(N' ')YesPSOFN Allow NULL? 
365PSOKSRegionnvarchar100CHAR(N' ')Yes*PSOKS Allow NULL? 
366PSOSGReason for reversal - IS-PS requestschar10CHAR(N' ')YesPSOSG Allow NULL? 
367PSOTMLast changed atnvarchar60TIMS(N'000000')YesPSOTM Allow NULL? 
368PSOTYDocument category payment requestsnvarchar20CHAR(N' ')Yes*PSOTY_D Allow NULL? 
369PSOZLActual postingchar10CHAR(N' ')YesPSOZL Allow NULL? 
370RE_ACCOUNTCash Ledger: Expense or Revenue Accountnvarchar100CHAR(N' ')Yes*FAGL_RE_ACCOUNT Allow NULL? 
371RE_BUKRSCash Ledger: Company Code for Expense/Revenuenvarchar40CHAR(N' ')Yes*FAGL_RE_BUKRS Allow NULL? 
372SAMPLEDSampled Invoice by Payment Certificationchar10CHAR(N' ')YesSAMPLED Allow NULL? 
373SNAMEUser Namenvarchar120CHAR(N' ')YesUNAME Allow NULL? 
374SSBLKPayment Statistical Sampling Blockchar10CHAR(N' ')YesSSBLK Allow NULL? 
375TAXPSTax document item numbernvarchar60NUMC(N'000000')YesTAX_POSNR Allow NULL? 
376XFRGE_BSEGPayment Is Releasedchar10CHAR(N' ')YesXFRGE_BSEG Allow NULL? 
377XLGCLRClearing Specific to Ledger Groupschar10CHAR(N' ')YesXLGCLR Allow NULL? 
378XMCADocument Originates from Multi Currency Accountingchar10CHAR(N' ')YesGLE_DTE_MCA_XMCA Allow NULL? 
379XREORGDoc. Contains Open Item that Was Transferred During Reorg.char10CHAR(N' ')YesFAGL_R_XDOC_REORG Allow NULL? 
380ZZBUSPARTNBusiness partnernvarchar100CHAR(N' ')YesZZBUSPARTN Allow NULL? 
381ZZCHANDistribution channelnvarchar40CHAR(N' ')YesZZCHAN Allow NULL? 
382ZZLOBBUSINESS LINEnvarchar70CHAR(N' ')Yes*ZZLOB Allow NULL? 
383ZZLOCACitynvarchar40CHAR(N' ')YesZZLOCA Allow NULL? 
384ZZPRODUCTProduct groupnvarchar100CHAR(N' ')YesZZPRODUCT Allow NULL? 
385ZZREGIONLocationnvarchar30CHAR(N' ')YesZZREGION Allow NULL? 
386ZZSPREGSpecial Regionnvarchar50CHAR(N' ')Yes*ZREGION Allow NULL? 
387ZZSTATEState/Province Codenvarchar30CHAR(N' ')Yes*ZZSTATE Allow NULL? 
388ZZUSERFLD1Territorynvarchar90CHAR(N' ')YesZZUSERFLD1 Allow NULL? 
389ZZUSERFLD2Owner/Cont.nvarchar120CHAR(N' ')YesZZUSERFLD2 Allow NULL? 
390ZZUSERFLD3Veinnvarchar220CHAR(N' ')YesZZUSERFLD3 Allow NULL? 
391RP_KTEXTProfit Center: Short Textnvarchar200CHAR(N' ')YesFAGL_TEXT_PRCTR_SHORT Allow NULL? 
392RP_LTEXTProfit Center: Long Textnvarchar400CHAR(N' ')YesFAGL_TEXT_PRCTR_LONG Allow NULL? 
393SP_KTEXTPartner Profit Center: Short Textnvarchar200CHAR(N' ')YesFAGL_TEXT_PPRCTR_SHORT Allow NULL? 
394SP_LTEXTPartner Profit Center: Long Textnvarchar400CHAR(N' ')YesFAGL_TEXT_PPRCTR_LONG Allow NULL? 
395RF_FKBTXFunctional Area: Textnvarchar250CHAR(N' ')YesFAGL_TEXT_FAREA Allow NULL? 
396SF_FKBTXPartner Functional Area: Textnvarchar250CHAR(N' ')YesFAGL_TEXT_PFAREA Allow NULL? 
397CC_KTEXTCost Center: Short Textnvarchar200CHAR(N' ')YesFAGL_TEXT_CCNTR_SHORT Allow NULL? 
398CC_LTEXTCost Center: Long Textnvarchar400CHAR(N' ')YesFAGL_TEXT_CCNTR_LONG Allow NULL? 
399OR_KTEXTOrder: Short Textnvarchar400CHAR(N' ')YesFAGL_TEXT_ORDER_SHORT Allow NULL? 
400MM_MAKTXMaterial: Descriptionnvarchar400CHAR(N' ')YesFAGL_TEXT_MATERIAL Allow NULL? 
401GA_TXT20G/L Account: Short Textnvarchar200CHAR(N' ')YesFAGL_TEXT_GL_ACCOUNT_SHORT Allow NULL? 
402GA_TXT50G/L Account: Long Textnvarchar500CHAR(N' ')YesFAGL_TEXT_GL_ACCOUNT_LONG Allow NULL? 
403SK_TXT20Reconciliation Account: Short Textnvarchar200CHAR(N' ')YesFAGL_TEXT_SAKNR_SHORT Allow NULL? 
404SK_TXT50Reconciliation Account: Long Textnvarchar500CHAR(N' ')YesFAGL_TEXT_SAKNR_LONG Allow NULL? 
405SKB1_BEGRUAuthorization Groupnvarchar40CHAR(N' ')Yes*BRGRU Allow NULL? 
406SKB1_BUSABAccounting clerknvarchar20CHAR(N' ')Yes*BUSAB Allow NULL? 
407SKB1_DATLZDate of the last interest calculation runnvarchar80DATS(N'00000000')YesDATLZ Allow NULL? 
408SKB1_ERDATCompany Code: Date on which the Record Was Creatednvarchar80DATS(N'00000000')YesSKB1_ERDAT_RF Allow NULL? 
409SKB1_ERNAMCompany Code: Name of Person who Created the Recordnvarchar120CHAR(N' ')YesSKB1_ERNAM_RF Allow NULL? 
410SKB1_FDGRVPlanning groupnvarchar100CHAR(N' ')Yes*FDGRV Allow NULL? 
411SKB1_FDLEVPlanning levelnvarchar20CHAR(N' ')Yes*FDLEV Allow NULL? 
412SKB1_FIPLSFinancial Budget Itemnvarchar30NUMC(N'000')YesFIPLS Allow NULL? 
413SKB1_FSTAGField status groupnvarchar40CHAR(N' ')Yes*FSTAG Allow NULL? 
414SKB1_HBKIDShort Key for a House Banknvarchar50CHAR(N' ')Yes*HBKID Allow NULL? 
415SKB1_HKTIDCompany Code: ID for Account Detailsnvarchar50CHAR(N' ')Yes*SKB1_HKTID Allow NULL? 
416SKB1_KDFSLKey for Exchange Rate Differences in Foreign Currency Acctsnvarchar40CHAR(N' ')Yes*KDFSL Allow NULL? 
417SKB1_MITKZAccount is reconciliation accountchar10CHAR(N' ')YesMITKZ Allow NULL? 
418SKB1_MWSKZTax Category in Account Master Recordnvarchar20CHAR(N' ')YesSMWSK Allow NULL? 
419SKB1_STEXTG/L account additional textnvarchar500CHAR(N' ')YesSTEXT_SKB1 Allow NULL? 
420SKB1_VZSKZInterest calculation indicatornvarchar20CHAR(N' ')Yes*VZSKZ Allow NULL? 
421SKB1_WAERSAccount currencynvarchar50CUKY(N' ')Yes*WAERS_SKB1 Allow NULL? 
422SKB1_WMETHIndicator: account managed in external systemnvarchar20CHAR(N' ')YesWMETH Allow NULL? 
423SKB1_XGKONCash receipt account / cash disbursement accountchar10CHAR(N' ')YesXGKON Allow NULL? 
424SKB1_XINTBIndicator: Is account only posted to automatically?char10CHAR(N' ')YesXINTB Allow NULL? 
425SKB1_XKRESIndicator: Can Line Items Be Displayed by Account?char10CHAR(N' ')YesXKRES Allow NULL? 
426SKB1_XLOEBIndicator: Account marked for deletion?char10CHAR(N' ')YesXLOEV Allow NULL? 
427SKB1_XNKONIndicator: Supplement for automatic postings ?char10CHAR(N' ')YesXNKON Allow NULL? 
428SKB1_XOPVWIndicator: Open Item Management?char10CHAR(N' ')YesXOPVW Allow NULL? 
429SKB1_XSPEBIndicator: Is Account Blocked for Posting?char10CHAR(N' ')YesXSPEB Allow NULL? 
430SKB1_ZINDTKey date of the last interest calculationnvarchar80DATS(N'00000000')YesDZINDT Allow NULL? 
431SKB1_ZINRTInterest calculation frequency in monthsnvarchar20NUMC(N'00')YesDZINRT Allow NULL? 
432SKB1_ZUAWAKey for sorting according to assignment numbersnvarchar30CHAR(N' ')Yes*DZUAWA Allow NULL? 
433SKB1_ALTKTCompany Code: Alternative Account Numbernvarchar100CHAR(N' ')Yes*SKB1_ALTKT Allow NULL? 
434SKB1_XMITKIndicator: Reconcil.acct ready for input at time of posting?char10CHAR(N' ')YesXMITK Allow NULL? 
435SKB1_RECIDRecovery Indicatornvarchar20CHAR(N' ')Yes*JV_RECIND Allow NULL? 
436SKB1_FIPOSCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
437SKB1_XMWNOIndicator: Tax code is not a required fieldchar10CHAR(N' ')YesXMWNO Allow NULL? 
438SKB1_XSALHIndicator: Only Manage Balances in Local Currencychar10CHAR(N' ')YesXSALH Allow NULL? 
439SKB1_BEWGPValuation Groupnvarchar100CHAR(N' ')YesBEWGP Allow NULL? 
440SKB1_INFKYInflation Keynvarchar80CHAR(N' ')Yes*J_1AIFSKS Allow NULL? 
441SKB1_TOGRUTolerance Group for G/L Accountsnvarchar40CHAR(N' ')Yes*TOGRU_S Allow NULL? 
442SKB1_XLGCLRClearing Specific to Ledger Groupschar10CHAR(N' ')YesXLGCLR Allow NULL? 
443SKA1_XBILKIndicator: Account is a balance sheet account?char10CHAR(N' ')YesXBILK Allow NULL? 
444SKA1_SAKANG/L account number, significant lengthnvarchar100CHAR(N' ')YesSAKAN Allow NULL? 
445SKA1_BILKTGroup Account Numbernvarchar100CHAR(N' ')Yes*BILKT Allow NULL? 
446SKA1_ERDATDate on which the Record Was Creatednvarchar80DATS(N'00000000')YesERDAT_RF Allow NULL? 
447SKA1_ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM_RF Allow NULL? 
448SKA1_GVTYPP&L statement account typenvarchar20CHAR(N' ')YesGVTYP Allow NULL? 
449SKA1_KTOKSG/L Account Groupnvarchar40CHAR(N' ')Yes*KTOKS Allow NULL? 
450SKA1_MUSTRNumber of the sample accountnvarchar100CHAR(N' ')Yes*MUSTR Allow NULL? 
451SKA1_VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')Yes*RASSC Allow NULL? 
452SKA1_XLOEVIndicator: Account marked for deletion?char10CHAR(N' ')YesXLOEV Allow NULL? 
453SKA1_XSPEAIndicator: account is blocked for creation ?char10CHAR(N' ')YesXSPEA Allow NULL? 
454SKA1_XSPEBIndicator: Is Account Blocked for Posting?char10CHAR(N' ')YesXSPEB Allow NULL? 
455SKA1_XSPEPIndicator: account blocked for planning ?char10CHAR(N' ')YesXSPEP Allow NULL? 
456SKA1_MCOD1Search Term for Using Matchcodenvarchar250CHAR(N' ')YesMCODF Allow NULL? 
457SKA1_FUNC_AREAFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
NamePrimaryUniqueTypeColumns
GLPOS_N_GL_CT~0YesYesCLUSTEREDMANDT