SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9/OPT/Z1344Reporting table: Text table for exception definitions
10FCO_DOC_HEAD61Failure Cost Document Header

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OIVL77Whse Journal
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
1ERP EHP76.0GLPOS_C_VEN_CT4421GLPOS_C_CT Vendor Line Items
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, 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, 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, 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, RSTGR, RYACQ, 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, 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, VERZN, X_CLEARED_ITEM, NEBTR, NETDT, SK1DT, SK2DT, ZINSZ, SKNTO, T001S_SNAME, T001S_USNAM, LFA1_LAND1, LFA1_NAME1, LFA1_NAME2, LFA1_ORT01, LFA1_PSTLZ, LFA1_REGIO, LFA1_SORTL, LFA1_STRAS, LFA1_TELF1, LFA1_TELFX, LFA1_XCPDK, LFA1_ADRNR, LFA1_MCOD1, LFA1_MCOD2, LFA1_MCOD3, LFA1_BEGRU, LFA1_LOEVM, LFA1_SPERR, LFB1_ERDAT, LFB1_ERNAM, LFB1_SPERR, LFB1_LOEVM, LFB1_BUSAB, LFB1_AKONT, LFB1_BEGRU, LFB1_XVERR, LFB1_ZAHLS, LFB1_ZTERM, LFB1_VZSKZ, LFB1_ZINDT, LFB1_EIKTO, LFB1_ZSABE, LFB1_KVERM, LFB1_WEBTR, LFB1_TOGRU, LFB1_NODEL, LFB1_TLFNS, 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 FROM GLPOS_C_VEN_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' ')YesTABWANBWA 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' ')YesT001ANFBU Allow NULL? 
42ANLN1Main Asset Numbernvarchar120CHAR(N' ')YesANLHANLN1 Allow NULL? 
43ANLN2Asset Subnumbernvarchar40CHAR(N' ')YesANLAANLN2 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' ')YesAUFKAUFNR 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' ')YesT001AUSBK Allow NULL? 
53AWKEYReference Keynvarchar200CHAR(N' ')YesAWKEY Allow NULL? 
54AWSYSLogical Systemnvarchar100CHAR(N' ')Yes*LOGSYSTEM Allow NULL? 
55AWTYPReference Transactionnvarchar50CHAR(N' ')YesTTYPAWTYP Allow NULL? 
56BELNRAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
57BEWARTransaction Typenvarchar30CHAR(N' ')YesT856RMVCT Allow NULL? 
58BKTXTDocument Header Textnvarchar250CHAR(N' ')YesBKTXT Allow NULL? 
59BLARTDocument Typenvarchar20CHAR(N' ')YesT003BLART 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' ')YesTBSLBSCHL 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' ')YesT001BUKRS 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' ')YesT001KBWKEY Allow NULL? 
75BWTARValuation Typenvarchar100CHAR(N' ')YesT149DBWTAR_D Allow NULL? 
76BZDATAsset value datenvarchar80DATS(N'00000000')YesBZDAT Allow NULL? 
77CCBTCPayment cards: Settlement runnvarchar100CHAR(N' ')YesCCBTC Allow NULL? 
78CCINSPayment cards: Card typenvarchar40CHAR(N' ')YesTCRINCCINS_30F Allow NULL? 
79CCNUMPayment cards: Card numbernvarchar250CHAR(N' ')YesCCNUM_30F Allow NULL? 
80CESSION_KZAccounts Receivable Pledging Indicatornvarchar20CHAR(N' ')YesTCESSIONCESSION_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? 
91DOKIDDocument Name in the Archive Systemnvarchar400CHAR(N' ')YesDOKID_BKPF Allow NULL? 
92DTWS1Instruction key 1nvarchar20NUMC(N'00')Yes*DTAT16 Allow NULL? 
93DTWS2Instruction key 2nvarchar20NUMC(N'00')Yes*DTAT17 Allow NULL? 
94DTWS3Instruction key 3nvarchar20NUMC(N'00')Yes*DTAT18 Allow NULL? 
95DTWS4Instruction key 4nvarchar20NUMC(N'00')Yes*DTAT19 Allow NULL? 
96DUEFLStatus of Data Transfer into Subsequent Releasechar10CHAR(N' ')YesDUEFL_BKPF Allow NULL? 
97EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
98EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
99EGBLDCountry of Destination for Delivery of Goodsnvarchar30CHAR(N' ')YesT005EGBLD Allow NULL? 
100EGLLDSupplying Country for Delivery of Goodsnvarchar30CHAR(N' ')YesT005EGLLD Allow NULL? 
101EGRUPEquity groupnvarchar30CHAR(N' ')Yes*JV_EGROUP Allow NULL? 
102ELIKZ"Delivery Completed" Indicatorchar10CHAR(N' ')YesELIKZ Allow NULL? 
103EMPFBPayee/Payernvarchar100CHAR(N' ')YesEMPFB Allow NULL? 
104ESRNRISR Subscriber Numbernvarchar110CHAR(N' ')YesESRNR Allow NULL? 
105ESRPZISR Check Digitnvarchar20CHAR(N' ')YesESRPZ Allow NULL? 
106ESRREISR Reference Numbernvarchar270CHAR(N' ')YesESRRE Allow NULL? 
107ETEN2Delivery Schedule Line Numbernvarchar40NUMC(N'0000')Yes*ETENR Allow NULL? 
108ETYPEEquity typenvarchar30CHAR(N' ')Yes*JV_ETYPE Allow NULL? 
109FDGRPPlanning Groupnvarchar100CHAR(N' ')YesT035FDGRP Allow NULL? 
110FDLEVPlanning levelnvarchar20CHAR(N' ')YesT036FDLEV Allow NULL? 
111FDTAGPlanning datenvarchar80DATS(N'00000000')YesFDTAG Allow NULL? 
112FIKRSFinancial Management Areanvarchar40CHAR(N' ')YesFM01FIKRS Allow NULL? 
113FILKDAccount Number of the Branchnvarchar100CHAR(N' ')YesFILKD Allow NULL? 
114FIPOSCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
115FISCPERFiscal year / periodnvarchar70NUMC(N'0000000')YesRSFISCPER Allow NULL? 
116FISTLFunds Centernvarchar160CHAR(N' ')YesFMFCTRFISTL Allow NULL? 
117FKBER_LONGFunctional Areanvarchar160CHAR(N' ')YesTFKBFKBER Allow NULL? 
118FKONTFinancial Budget Itemnvarchar30NUMC(N'000')YesFIPLS Allow NULL? 
119GEBERFundnvarchar100CHAR(N' ')YesFMFINCODEBP_GEBER Allow NULL? 
120GITYPDistribution Type for Employment Taxnvarchar20CHAR(N' ')Yes*J_1ADTYP_D Allow NULL? 
121GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
122GLUPMUpdate Method for FM - FI-CA Integrationchar10CHAR(N' ')YesGLUPM Allow NULL? 
123GLVORBusiness Transactionnvarchar40CHAR(N' ')YesGLVOR Allow NULL? 
124GMVKZItem is in Executionchar10CHAR(N' ')YesFM_GMVKZ Allow NULL? 
125GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
126GRICDActivity Code for Gross Income Taxnvarchar20CHAR(N' ')Yes*J_1AGICD_D Allow NULL? 
127GRIRGRegion (State, Province, County)nvarchar30CHAR(N' ')YesT005SREGIO Allow NULL? 
128GRPIDBatch Input Session Namenvarchar120CHAR(N' ')YesGRPID_BKPF Allow NULL? 
129GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
130GVTYPP&L statement account typenvarchar20CHAR(N' ')YesGVTYP Allow NULL? 
131HBKIDShort Key for a House Banknvarchar50CHAR(N' ')YesT012HBKID Allow NULL? 
132HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')YesSKA1FAGL_HKONT Allow NULL? 
133HKTIDID for account detailsnvarchar50CHAR(N' ')YesT012KHKTID Allow NULL? 
134HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40CHAR(N' ')YesTKKH1HRKFT Allow NULL? 
135HWMETMethod with Which the Local Currency Amount Was Determinedchar10CHAR(N' ')YesHWMET Allow NULL? 
136HZUONAssignment Number for Special G/L Accountsnvarchar180CHAR(N' ')YesHZUON Allow NULL? 
137IBLARInternal Document Type for Document Controlnvarchar20CHAR(N' ')YesIBLAR Allow NULL? 
138IDXSPInflation Indexnvarchar50CHAR(N' ')Yes*J_1AINDXSP Allow NULL? 
139IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
140INTRENOInternal Real Estate Master Data Codenvarchar130CHAR(N' ')YesVVINTRENO Allow NULL? 
141KBLNRDocument Number for Earmarked Fundsnvarchar100CHAR(N' ')YesKBLKKBLNR_FI Allow NULL? 
142KBLPOSEarmarked Funds: Document Itemnvarchar30NUMC(N'000')Yes*KBLPOS Allow NULL? 
143KIDNOPayment Referencenvarchar300CHAR(N' ')YesKIDNO Allow NULL? 
144KKBERCredit control areanvarchar40CHAR(N' ')YesT014KKBER Allow NULL? 
145KKTPLGroup Chart of Acctsnvarchar40CHAR(N' ')YesT004KKTPL Allow NULL? 
146KOARTAccount Typechar10CHAR(N' ')YesKOART Allow NULL? 
147KOKRSControlling Areanvarchar40CHAR(N' ')YesTKA01KOKRS Allow NULL? 
148KOSTLCost Centernvarchar100CHAR(N' ')YesCSKSKOSTL Allow NULL? 
149KSTARCost Elementnvarchar100CHAR(N' ')YesCSKAKSTAR Allow NULL? 
150KSTRGCost Objectnvarchar120CHAR(N' ')YesCKPHKSTRG Allow NULL? 
151KTOP2Chart of Accounts According to Country Legislationnvarchar40CHAR(N' ')YesT004KTOP2 Allow NULL? 
152KTOPLChart of Accountsnvarchar40CHAR(N' ')YesT004KTOPL Allow NULL? 
153KTOSLTransaction Keynvarchar30CHAR(N' ')YesKTOSL Allow NULL? 
154KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
155KURSFExchange ratedecimal95DEC((0))YesKURSF
156KURSRHedged Exchange Ratedecimal95DEC((0))YesKURSR
157KURSTExchange Rate Typenvarchar40CHAR(N' ')YesTCURVKURST Allow NULL? 
158LAND1Country Keynvarchar30CHAR(N' ')YesT005LAND1 Allow NULL? 
159LANDLSupplying Countrynvarchar30CHAR(N' ')YesT005LANDL Allow NULL? 
160LDGRPLedger Groupnvarchar40CHAR(N' ')YesFAGL_TLDGRPFAGL_LDGRP Allow NULL? 
161LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
162LINFVLast Adjustment Datenvarchar80DATS(N'00000000')YesJ_1ALINFVL Allow NULL? 
163LNRANSequence number of asset line items in fiscal yearnvarchar50NUMC(N'00000')YesANEKLNRAN Allow NULL? 
164LOKKTAlternative account number in company codenvarchar100CHAR(N' ')YesSKA1ALTKT_SKB1 Allow NULL? 
165LOTKZLot Number for Requestsnvarchar100CHAR(N' ')YesPSO_LOTKZ Allow NULL? 
166LSTARActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
167LZBKZState Central Bank Indicatornvarchar30CHAR(N' ')YesT015LLZBKZ Allow NULL? 
168MABERDunning Areanvarchar20CHAR(N' ')YesT047MMABER Allow NULL? 
169MADATLast dunned onnvarchar80DATS(N'00000000')YesMADAT Allow NULL? 
170MANSPDunning blockchar10CHAR(N' ')YesT040SMANSP Allow NULL? 
171MANSTDunning levelchar10NUMC(N'0')YesMAHNS_D Allow NULL? 
172MATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
173MEASUREFunded Programnvarchar240CHAR(N' ')Yes*FM_MEASURE Allow NULL? 
174MONATFiscal Periodnvarchar20NUMC(N'00')YesMONAT Allow NULL? 
175MSCHLDunning keychar10CHAR(N' ')YesT040MSCHL Allow NULL? 
176MWARTTax Typechar10CHAR(N' ')YesMWART Allow NULL? 
177MWSK1Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
178MWSK2Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
179MWSK3Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
180MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
181NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')YesAUFKNPLNR Allow NULL? 
182NUMPGNumber of pages of invoicenvarchar30NUMC(N'000')YesJ_1ANOPG Allow NULL? 
183OBZEINumber of Line Item in Original Documentnvarchar30NUMC(N'000')YesOBZEI Allow NULL? 
184PARGBTrading partner's business areanvarchar40CHAR(N' ')YesTGSBPARGB Allow NULL? 
185PEINHPrice Unitdecimal50DEC((0))YesPEINH
186PENDAYSNumber of days for penalty charge calculationint100INT4((0))YesPDAYS Allow NULL? 
187PENRCReason for late paymentnvarchar20CHAR(N' ')YesPENRC Allow NULL? 
188PERIVFiscal Year Variantnvarchar20CHAR(N' ')YesT009PERIV Allow NULL? 
189PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
190PFKBERPartner Functional Areanvarchar160CHAR(N' ')YesTFKBSFKBER Allow NULL? 
191PGEBERPartner Fundnvarchar100CHAR(N' ')YesFMFINCODEFM_PFUND Allow NULL? 
192PGRANT_NBRPartner Grantnvarchar200CHAR(N' ')YesGM_GRANT_PARTNER Allow NULL? 
193POPTSReal estate option ratedecimal96DEC((0))YesPOPTSATZ
194POSN2Sales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
195PPA_EX_INDPPA Exclude Indicatorchar10CHAR(N' ')YesEXCLUDE_FLG Allow NULL? 
196PPNAMName of User Who Parked this Documentnvarchar120CHAR(N' ')YesUSR02PPNAM Allow NULL? 
197PPRCTPartner Profit Centernvarchar100CHAR(N' ')YesCEPCPPRCTR Allow NULL? 
198PRCTRProfit Centernvarchar100CHAR(N' ')YesCEPCPRCTR Allow NULL? 
199PROJKWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')YesPRPSPS_PSP_PNR Allow NULL? 
200PROPMANOReal Estate Management Mandatenvarchar130CHAR(N' ')YesRE_MANDAT Allow NULL? 
201PRZNRBusiness Processnvarchar120CHAR(N' ')YesCBPRCO_PRZNR Allow NULL? 
202PSALTAlternative Price Controlchar10CHAR(N' ')YesPSALT Allow NULL? 
203PSEGMENTPartner Segment for Segmental Reportingnvarchar100CHAR(N' ')YesFAGL_SEGMFB_PSEGMENT Allow NULL? 
204PYCURCurrency for Automatic Paymentnvarchar50CUKY(N' ')YesTCURCPYCUR Allow NULL? 
205QSSKZWithholding Tax Codenvarchar20CHAR(N' ')YesT059QQSSKZ Allow NULL? 
206QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100CHAR(N' ')YesQSZNR Allow NULL? 
207REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
208REBZJFiscal Year of the Relevant Invoice (for Credit Memo)nvarchar40NUMC(N'0000')YesREBZJ Allow NULL? 
209REBZTFollow-On Document Typechar10CHAR(N' ')YesREBZT Allow NULL? 
210REBZZLine Item in the Relevant Invoicenvarchar30NUMC(N'000')YesREBZZ Allow NULL? 
211RECIDRecovery Indicatornvarchar20CHAR(N' ')Yes*JV_RECIND Allow NULL? 
212REINDATInvoice Receipt Datenvarchar80DATS(N'00000000')YesREINDAT Allow NULL? 
213RFZEIPayment Card Itemnvarchar30NUMC(N'000')YesRFZEI_CC Allow NULL? 
214RLDNRLedger in General Ledger Accountingnvarchar20CHAR(N' ')Yes*FAGL_RLDNR Allow NULL? 
215RPACQPeriod of Acquisitionnvarchar30NUMC(N'000')YesRPACQ Allow NULL? 
216RSTGRReason Code for Paymentsnvarchar30CHAR(N' ')YesT053RRSTGR Allow NULL? 
217RYACQYear of acquisitionnvarchar40CHAR(N' ')YesRYACQ Allow NULL? 
218SAKNRReconciliation Account from Master Datanvarchar100CHAR(N' ')Yes*FAGL_SAKNR Allow NULL? 
219SAMNRInvoice List Numbernvarchar80NUMC(N'00000000')YesSAMNR Allow NULL? 
220SECCOSection Codenvarchar40CHAR(N' ')Yes*SECCO Allow NULL? 
221SEGMENTSegment for Segmental Reportingnvarchar100CHAR(N' ')YesFAGL_SEGMFB_SEGMENT Allow NULL? 
222SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
223SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
224SHZUZDebit/Credit Addition for Cash Discountchar10CHAR(N' ')YesSHZUZ Allow NULL? 
225SPGRCBlock.reason: qualitychar10CHAR(N' ')YesSPGRC Allow NULL? 
226SPGRGBlocking reason: order price quantitychar10CHAR(N' ')YesSPGRG Allow NULL? 
227SPGRMBlocking reason: quantitychar10CHAR(N' ')YesSPGRM Allow NULL? 
228SPGRPBlocking reason: pricechar10CHAR(N' ')YesSPGRP Allow NULL? 
229SPGRQManual Blocking Reasonchar10CHAR(N' ')YesSPGRQ Allow NULL? 
230SPGRSBlocking Reason: Item Amountchar10CHAR(N' ')YesSPGRS Allow NULL? 
231SPGRTBlocking Reason: Datechar10CHAR(N' ')YesSPGRT Allow NULL? 
232SPGRVBlocking reason: project budgetchar10CHAR(N' ')YesSPGRV Allow NULL? 
233SRTYPEType of Additional Receivablenvarchar20CHAR(N' ')YesFM_SRTYPE Allow NULL? 
234STBLGReverse Document Numbernvarchar100CHAR(N' ')YesSTBLG Allow NULL? 
235STBUKTax Company Codenvarchar40CHAR(N' ')YesT001STBUK Allow NULL? 
236STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
237STEKZVersion Number Componentnvarchar20CHAR(N' ')YesCHAR2 Allow NULL? 
238STGRDReason for Reversalnvarchar20CHAR(N' ')YesT041CSTGRD Allow NULL? 
239STJAHReverse document fiscal yearnvarchar40NUMC(N'0000')YesSTJAH Allow NULL? 
240STODTPlanned Date for the Reverse Postingnvarchar80DATS(N'00000000')YesSTODT Allow NULL? 
241TBTKZIndicator: subsequent debit/creditchar10CHAR(N' ')YesTBTKZ Allow NULL? 
242TCODETransaction Codenvarchar200CHAR(N' ')YesTSTCTCODE Allow NULL? 
243TXDATDate for defining tax ratesnvarchar80DATS(N'00000000')YesTXDAT Allow NULL? 
244TXGRPGroup Indicator for Tax Line Itemsnvarchar30NUMC(N'000')YesTXGRP Allow NULL? 
245TXJCDTax Jurisdictionnvarchar150CHAR(N' ')YesTTXJTXJCD Allow NULL? 
246UMSKSSpecial G/L Transaction Typechar10CHAR(N' ')YesUMSKS Allow NULL? 
247UMSKZSpecial G/L Indicatorchar10CHAR(N' ')YesT074UUMSKZ Allow NULL? 
248UPDDTDate of the Last Document Updatenvarchar80DATS(N'00000000')YesUPDDT Allow NULL? 
249USNAMUser namenvarchar120CHAR(N' ')YesUSR02USNAM Allow NULL? 
250UZAWEPayment Method Supplementnvarchar20CHAR(N' ')YesT042FUZAWE Allow NULL? 
251VALUTValue datenvarchar80DATS(N'00000000')YesVALUT Allow NULL? 
252VATDATETax Reporting Datenvarchar80DATS(N'00000000')YesVATDATE Allow NULL? 
253VBEL2Sales Documentnvarchar100CHAR(N' ')YesVBUKVBELN_VA Allow NULL? 
254VBELNBilling Documentnvarchar100CHAR(N' ')YesVBUKVBELN_VF Allow NULL? 
255VBEWAFlow Typenvarchar40CHAR(N' ')YesTZB0ASBEWART Allow NULL? 
256VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')YesT880RASSC Allow NULL? 
257VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
258VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
259VNAMEJoint Venturenvarchar60CHAR(N' ')YesT8JVJV_NAME Allow NULL? 
260VORGNTransaction Type for General Ledgernvarchar40CHAR(N' ')YesVORGN Allow NULL? 
261VPRSVPrice control indicatorchar10CHAR(N' ')YesVPRSV Allow NULL? 
262VPTNRPartner account numbernvarchar100CHAR(N' ')YesKNA1JV_PART Allow NULL? 
263VRSDTInsurance datenvarchar80DATS(N'00000000')YesVRSDT Allow NULL? 
264VRSKZInsurance indicatorchar10CHAR(N' ')YesVRSKZ Allow NULL? 
265WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
266WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
267WVERWBill of exchange usage typechar10CHAR(N' ')YesWVERW Allow NULL? 
268WWERTTranslation Datenvarchar80DATS(N'00000000')YesWWERT_D Allow NULL? 
269XANETIndicator: Down payment in net procedure ?char10CHAR(N' ')YesXANET Allow NULL? 
270XAUTOIndicator: Line item automatically createdchar10CHAR(N' ')YesXAUTO Allow NULL? 
271XBILKIndicator: Account is a balance sheet account?char10CHAR(N' ')YesXBILK Allow NULL? 
272XBLNRReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
273XBLNR_ALTAlternative Reference Numbernvarchar260CHAR(N' ')YesXBLNR_ALT Allow NULL? 
274XCPDDIndicator: Address and bank data set individuallychar10CHAR(N' ')YesXCPDD Allow NULL? 
275XEGDRIndicator: Triangular deal within the EU ?char10CHAR(N' ')YesXEGDR Allow NULL? 
276XFAKTIndicator: Billing document update successful ?char10CHAR(N' ')YesXFAKT Allow NULL? 
277XHKOMIndicator: G/L account assigned manually ?char10CHAR(N' ')YesXHKOM Allow NULL? 
278XHRESIndicator: Resident G/L account?char10CHAR(N' ')YesXHRES Allow NULL? 
279XINVEIndicator: Capital Goods Affected?char10CHAR(N' ')YesXINVE Allow NULL? 
280XKRESIndicator: Can Line Items Be Displayed by Account?char10CHAR(N' ')YesXKRES Allow NULL? 
281XMWSTCalculate tax automaticallychar10CHAR(N' ')YesXMWST Allow NULL? 
282XNCOPIndicator: Items cannot be copied?char10CHAR(N' ')YesXNCOP Allow NULL? 
283XNEGPIndicator: Negative postingchar10CHAR(N' ')YesXNEGP Allow NULL? 
284XNETBIndicator: Document posted net ?char10CHAR(N' ')YesXNETB Allow NULL? 
285XOPVWIndicator: Open Item Management?char10CHAR(N' ')YesXOPVW Allow NULL? 
286XPANZDisplay itemchar10CHAR(N' ')YesXPANZ Allow NULL? 
287XPYPRIndicator: Items from Payment Program Blockedchar10CHAR(N' ')YesXPYPR Allow NULL? 
288XRAGLIndicator: Clearing was Reversedchar10CHAR(N' ')YesXRAGL Allow NULL? 
289XREF1Business partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
290XREF1_HDReference Key 1 Internal for Document Headernvarchar200CHAR(N' ')YesXREF1_HD Allow NULL? 
291XREF2Business partner reference keynvarchar120CHAR(N' ')YesXREF2 Allow NULL? 
292XREF2_HDReference Key 2 Internal for Document Headernvarchar200CHAR(N' ')YesXREF2_HD Allow NULL? 
293XREF3Reference key for line itemnvarchar200CHAR(N' ')YesXREF3 Allow NULL? 
294XREVERSALSpecifies whether doc. is reversal doc. or reversed doc.char10CHAR(N' ')YesXREVERSAL Allow NULL? 
295XRUEBIndicator: Document is posted to a previous periodchar10CHAR(N' ')YesXRUEB Allow NULL? 
296XSAUFIndicator: Posting to order is statisticalchar10CHAR(N' ')YesXSAUF Allow NULL? 
297XSERGIndicator: Posting to prof.analysis is statisticalchar10CHAR(N' ')YesXSERG Allow NULL? 
298XSKRLIndicator: Line item not liable to cash discount?char10CHAR(N' ')YesXSKRL Allow NULL? 
299XSKSTIndicator: Statistical posting to cost centerchar10CHAR(N' ')YesXSKST Allow NULL? 
300XSNETG/L account amounts entered exclude taxchar10CHAR(N' ')YesXSNET Allow NULL? 
301XSPLITFI Document Originates from Split Posting (Indicator)char10CHAR(N' ')YesSPLIT_POSTING Allow NULL? 
302XSPROIndicator: Posting to project is statisticalchar10CHAR(N' ')YesXSPRO Allow NULL? 
303XSTOVIndicator: Document is flagged for reversalchar10CHAR(N' ')YesXSTOV Allow NULL? 
304XUMANIndicator: Transfer posting from down payment ?char10CHAR(N' ')YesXUMAN Allow NULL? 
305XUMSWIndicator: Sales-related item ?char10CHAR(N' ')YesXUMSW Allow NULL? 
306XUSVRIndicator: US taxes changed at detail level ?char10CHAR(N' ')YesXUSVR_BKPF Allow NULL? 
307XWVOFIndicator: Customer bill of exchange payment before due datechar10CHAR(N' ')YesXWVOF Allow NULL? 
308XZAHLIndicator: Is the posting key used in a payment transaction?char10CHAR(N' ')YesXZAHL Allow NULL? 
309ZBD1PCash Discount Percentage 1decimal53DEC((0))YesDZBD1P
310ZBD1TCash discount days 1decimal30DEC((0))YesDZBD1T
311ZBD2PCash Discount Percentage 2decimal53DEC((0))YesDZBD2P
312ZBD2TCash discount days 2decimal30DEC((0))YesDZBD2T
313ZBD3TNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
314ZBFIXFixed Payment Termschar10CHAR(N' ')YesDZBFIX Allow NULL? 
315ZEKKNSequential Number of Account Assignmentnvarchar20NUMC(N'00')YesDZEKKN Allow NULL? 
316ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
317ZINKZExempted from interest calculationnvarchar20CHAR(N' ')YesDZINKZ Allow NULL? 
318ZLSCHPayment Methodchar10CHAR(N' ')YesT042ZSCHZW_BSEG Allow NULL? 
319ZLSPRPayment Block Keychar10CHAR(N' ')YesT008DZLSPR Allow NULL? 
320ZOLLDCustoms Datenvarchar80DATS(N'00000000')YesDZOLLD Allow NULL? 
321ZOLLTCustoms Tariff Numbernvarchar80CHAR(N' ')YesDZOLLT Allow NULL? 
322ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
323ZUMSKTarget Special G/L Indicatorchar10CHAR(N' ')YesT074UDZUMSK Allow NULL? 
324ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
325/SAPF15/STATUSchar10(N' ')Yes Allow NULL? 
326BATCHLot Number for Documentsnvarchar100CHAR(N' ')YesLOTKZ Allow NULL? 
327BLINDBudgetary Ledger Indicatorchar10CHAR(N' ')YesFM_BLIND Allow NULL? 
328BUDGET_PDFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
329CASH_ALLOCCash-Relevant Documentchar10CHAR(N' ')YesFAGL_CASH_ALLOC Allow NULL? 
330EXCLUDE_FLAGPPA Exclude Indicatorchar10CHAR(N' ')YesEXCLUDE_FLG Allow NULL? 
331FASTPAYPPA Fast Pay Indicatorchar10CHAR(N' ')YesFMFG_FASTPAY_FLG Allow NULL? 
332FMFGUS_KEYUnited States Federal Government Fieldsnvarchar220CHAR(N' ')YesFMFG_US_KEY Allow NULL? 
333FMXDOCLNFM Reference Line Itemnvarchar60NUMC(N'000000')YesFM_XDOCLN Allow NULL? 
334FMXDOCNRFM Reference Document Numbernvarchar100CHAR(N' ')YesFM_XDOCNR Allow NULL? 
335FMXYEARFM Reference Yearnvarchar40NUMC(N'0000')YesFM_XYEAR Allow NULL? 
336FMXZEKKNFM Reference Sequence Account Assignmentnvarchar50NUMC(N'00000')YesFM_XZEKKN Allow NULL? 
337FM_UMARTType of Payment Transferchar10CHAR(N' ')YesFM_UMART Allow NULL? 
338FOLLOW_ONFollow-on document indicatorchar10CHAR(N' ')YesFAGL_FOLLOW_ON Allow NULL? 
339IGNR_IVREFFMFG: Ignore the invoice reference during FI doc splittingchar10CHAR(N' ')YesFMFG_IGNORE_INV_REF Allow NULL? 
340INTDATEInterest Calc. Datenvarchar80DATS(N'00000000')YesFM_INTDATE Allow NULL? 
341INTFORMInterest Formulanvarchar40CHAR(N' ')YesFM_INTFORM Allow NULL? 
342KNUMVNumber of the document conditionnvarchar100CHAR(N' ')YesKNUMV Allow NULL? 
343MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350CHAR(N' ')YesSEPA_MNDID Allow NULL? 
344OFFSET_REFER_DATDate Record Referred to Treasurynvarchar80DATS(N'00000000')YesFMFG_REFERRED_OFFSET_DAT Allow NULL? 
345OFFSET_STATUSTreasury Offset Statusnvarchar20CHAR(N' ')YesFMFG_OFFSET_STATUS Allow NULL? 
346PAYS_PROVPayment Service Providernvarchar40CHAR(N' ')Yes*COM_WEC_PAYMENT_SRV_PROVIDER Allow NULL? 
347PAYS_TRANPayment Reference of Payment Service Providernvarchar350CHAR(N' ')YesFPS_TRANSACTION Allow NULL? 
348PBUDGET_PDFM: Partner Budget Periodnvarchar100CHAR(N' ')Yes*FM_PBUDGET_PERIOD Allow NULL? 
349PEROP_BEGBilling Period of Performance Start Datenvarchar80DATS(N'00000000')YesFM_PEROP_FI_LOW Allow NULL? 
350PEROP_ENDBilling Period of Performance End Datenvarchar80DATS(N'00000000')YesFM_PEROP_FI_HIGH Allow NULL? 
351PRODPERProduction Month (Date to find period and year)nvarchar80DATS(N'00000000')YesJV_PRODPER Allow NULL? 
352PSOAKReasonnvarchar100CHAR(N' ')Yes*PSOAK Allow NULL? 
353PSOBTPosting Daynvarchar80DATS(N'00000000')YesPSOBT Allow NULL? 
354PSODTChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
355PSOFNIS-PS: File numbernvarchar300CHAR(N' ')YesPSOFN Allow NULL? 
356PSOKSRegionnvarchar100CHAR(N' ')Yes*PSOKS Allow NULL? 
357PSOSGReason for reversal - IS-PS requestschar10CHAR(N' ')YesPSOSG Allow NULL? 
358PSOTMLast changed atnvarchar60TIMS(N'000000')YesPSOTM Allow NULL? 
359PSOTYDocument category payment requestsnvarchar20CHAR(N' ')Yes*PSOTY_D Allow NULL? 
360PSOZLActual postingchar10CHAR(N' ')YesPSOZL Allow NULL? 
361RE_ACCOUNTCash Ledger: Expense or Revenue Accountnvarchar100CHAR(N' ')Yes*FAGL_RE_ACCOUNT Allow NULL? 
362RE_BUKRSCash Ledger: Company Code for Expense/Revenuenvarchar40CHAR(N' ')Yes*FAGL_RE_BUKRS Allow NULL? 
363SAMPLEDSampled Invoice by Payment Certificationchar10CHAR(N' ')YesSAMPLED Allow NULL? 
364SNAMEUser Namenvarchar120CHAR(N' ')YesUNAME Allow NULL? 
365SSBLKPayment Statistical Sampling Blockchar10CHAR(N' ')YesSSBLK Allow NULL? 
366TAXPSTax document item numbernvarchar60NUMC(N'000000')YesTAX_POSNR Allow NULL? 
367XFRGE_BSEGPayment Is Releasedchar10CHAR(N' ')YesXFRGE_BSEG Allow NULL? 
368XLGCLRClearing Specific to Ledger Groupschar10CHAR(N' ')YesXLGCLR Allow NULL? 
369XMCADocument Originates from Multi Currency Accountingchar10CHAR(N' ')YesGLE_DTE_MCA_XMCA Allow NULL? 
370XREORGDoc. Contains Open Item that Was Transferred During Reorg.char10CHAR(N' ')YesFAGL_R_XDOC_REORG Allow NULL? 
371ZZBUSPARTNBusiness partnernvarchar100CHAR(N' ')YesZZBUSPARTN Allow NULL? 
372ZZCHANDistribution channelnvarchar40CHAR(N' ')YesZZCHAN Allow NULL? 
373ZZLOBBUSINESS LINEnvarchar70CHAR(N' ')Yes*ZZLOB Allow NULL? 
374ZZLOCACitynvarchar40CHAR(N' ')YesZZLOCA Allow NULL? 
375ZZPRODUCTProduct groupnvarchar100CHAR(N' ')YesZZPRODUCT Allow NULL? 
376ZZREGIONLocationnvarchar30CHAR(N' ')YesZZREGION Allow NULL? 
377ZZSPREGSpecial Regionnvarchar50CHAR(N' ')Yes*ZREGION Allow NULL? 
378ZZSTATEState/Province Codenvarchar30CHAR(N' ')Yes*ZZSTATE Allow NULL? 
379ZZUSERFLD1Territorynvarchar90CHAR(N' ')YesZZUSERFLD1 Allow NULL? 
380ZZUSERFLD2Owner/Cont.nvarchar120CHAR(N' ')YesZZUSERFLD2 Allow NULL? 
381ZZUSERFLD3Veinnvarchar220CHAR(N' ')YesZZUSERFLD3 Allow NULL? 
382VERZNDays in Arrears by Net Due Datedecimal50DEC((0))YesVERZN
383X_CLEARED_ITEMCleared Itemchar10CHAR(N' ')YesFAGL_X_CLEARED_ITEM Allow NULL? 
384NEBTRNet Payment Amountdecimal132CURR((0))YesNEBTR
385NETDTDue Date for Net Paymentnvarchar80DATS(N'00000000')YesNETDT Allow NULL? 
386SK1DTDue Date for Cash Discount 1nvarchar80DATS(N'00000000')YesSK1DT Allow NULL? 
387SK2DTDue Date for Cash Discount 2nvarchar80DATS(N'00000000')YesSK2DT Allow NULL? 
388ZINSZInterest Calculation Numerator (Days in Arrears * Amount)decimal152CURR((0))YesDZINSZ
389SKNTOCash discount amount in local currencydecimal132CURR((0))YesSKNTO
390T001S_SNAMEName of Accounting Clerknvarchar300CHAR(N' ')YesSNAME_001S Allow NULL? 
391T001S_USNAMName of SAP Office Usernvarchar120CHAR(N' ')YesFI_USR_NAM Allow NULL? 
392LFA1_LAND1Country Keynvarchar30CHAR(N' ')YesT005LAND1_GP Allow NULL? 
393LFA1_NAME1Vendor Account: Name 1nvarchar350CHAR(N' ')YesFAGL_TEXT_VENDOR_NAME1 Allow NULL? 
394LFA1_NAME2Vendor Account: Name 2nvarchar350CHAR(N' ')YesFAGL_TEXT_VENDOR_NAME2 Allow NULL? 
395LFA1_ORT01Citynvarchar350CHAR(N' ')YesORT01_GP Allow NULL? 
396LFA1_PSTLZPostal Codenvarchar100CHAR(N' ')YesPSTLZ Allow NULL? 
397LFA1_REGIORegion (State, Province, County)nvarchar30CHAR(N' ')YesT005SREGIO Allow NULL? 
398LFA1_SORTLSort fieldnvarchar100CHAR(N' ')YesSORTL Allow NULL? 
399LFA1_STRASHouse number and streetnvarchar350CHAR(N' ')YesSTRAS_GP Allow NULL? 
400LFA1_TELF1First telephone numbernvarchar160CHAR(N' ')YesTELF1 Allow NULL? 
401LFA1_TELFXFax Numbernvarchar310CHAR(N' ')YesTELFX Allow NULL? 
402LFA1_XCPDKIndicator: Is the account a one-time account?char10CHAR(N' ')YesXCPDK Allow NULL? 
403LFA1_ADRNRAddressnvarchar100CHAR(N' ')Yes*ADRNR Allow NULL? 
404LFA1_MCOD1Search term for matchcode searchnvarchar250CHAR(N' ')YesMCDK1 Allow NULL? 
405LFA1_MCOD2Search term for matchcode searchnvarchar250CHAR(N' ')YesMCDK2 Allow NULL? 
406LFA1_MCOD3Search term for matchcode searchnvarchar250CHAR(N' ')YesMCDK3 Allow NULL? 
407LFA1_BEGRUAuthorization Groupnvarchar40CHAR(N' ')Yes*BRGRU Allow NULL? 
408LFA1_LOEVMCentral Deletion Flag for Master Recordchar10CHAR(N' ')YesLOEVM_X Allow NULL? 
409LFA1_SPERRCentral posting blockchar10CHAR(N' ')YesSPERB_X Allow NULL? 
410LFB1_ERDATDate on which the Record Was Creatednvarchar80DATS(N'00000000')YesERDAT_RF Allow NULL? 
411LFB1_ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM_RF Allow NULL? 
412LFB1_SPERRPosting block for company codechar10CHAR(N' ')YesSPERB_B Allow NULL? 
413LFB1_LOEVMDeletion Flag for Master Record (Company Code Level)char10CHAR(N' ')YesLOEVM_B Allow NULL? 
414LFB1_BUSABAccounting clerknvarchar20CHAR(N' ')YesT001SBUSAB Allow NULL? 
415LFB1_AKONTReconciliation Account in General Ledgernvarchar100CHAR(N' ')YesSKB1AKONT Allow NULL? 
416LFB1_BEGRUAuthorization Groupnvarchar40CHAR(N' ')Yes*BRGRU Allow NULL? 
417LFB1_XVERRIndicator: Clearing between customer and vendor?char10CHAR(N' ')YesXVERR_LFB1 Allow NULL? 
418LFB1_ZAHLSBlock Key for Paymentchar10CHAR(N' ')YesT008DZAHLS Allow NULL? 
419LFB1_ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
420LFB1_VZSKZInterest calculation indicatornvarchar20CHAR(N' ')YesT056VZSKZ Allow NULL? 
421LFB1_ZINDTKey date of the last interest calculationnvarchar80DATS(N'00000000')YesDZINDT Allow NULL? 
422LFB1_EIKTOOur account number with the vendornvarchar120CHAR(N' ')YesEIKTO_K Allow NULL? 
423LFB1_ZSABEClerk at vendornvarchar150CHAR(N' ')YesDZSABE_K Allow NULL? 
424LFB1_KVERMMemonvarchar300CHAR(N' ')YesKVERM Allow NULL? 
425LFB1_WEBTRBill of exchange limit (in local currency)decimal132CURR((0))YesWEBTR
426LFB1_TOGRUTolerance group for the business partner/G/L accountnvarchar40CHAR(N' ')YesT043GTOGRU Allow NULL? 
427LFB1_NODELDeletion bock for master record (company code level)char10CHAR(N' ')YesNODEL_B Allow NULL? 
428LFB1_TLFNSAccounting clerk's telephone number at business partnernvarchar300CHAR(N' ')YesTLFNS Allow NULL? 
429RP_KTEXTProfit Center: Short Textnvarchar200CHAR(N' ')YesFAGL_TEXT_PRCTR_SHORT Allow NULL? 
430RP_LTEXTProfit Center: Long Textnvarchar400CHAR(N' ')YesFAGL_TEXT_PRCTR_LONG Allow NULL? 
431SP_KTEXTPartner Profit Center: Short Textnvarchar200CHAR(N' ')YesFAGL_TEXT_PPRCTR_SHORT Allow NULL? 
432SP_LTEXTPartner Profit Center: Long Textnvarchar400CHAR(N' ')YesFAGL_TEXT_PPRCTR_LONG Allow NULL? 
433RF_FKBTXFunctional Area: Textnvarchar250CHAR(N' ')YesFAGL_TEXT_FAREA Allow NULL? 
434SF_FKBTXPartner Functional Area: Textnvarchar250CHAR(N' ')YesFAGL_TEXT_PFAREA Allow NULL? 
435CC_KTEXTCost Center: Short Textnvarchar200CHAR(N' ')YesFAGL_TEXT_CCNTR_SHORT Allow NULL? 
436CC_LTEXTCost Center: Long Textnvarchar400CHAR(N' ')YesFAGL_TEXT_CCNTR_LONG Allow NULL? 
437OR_KTEXTOrder: Short Textnvarchar400CHAR(N' ')YesFAGL_TEXT_ORDER_SHORT Allow NULL? 
438MM_MAKTXMaterial: Descriptionnvarchar400CHAR(N' ')YesFAGL_TEXT_MATERIAL Allow NULL? 
439GA_TXT20G/L Account: Short Textnvarchar200CHAR(N' ')YesFAGL_TEXT_GL_ACCOUNT_SHORT Allow NULL? 
440GA_TXT50G/L Account: Long Textnvarchar500CHAR(N' ')YesFAGL_TEXT_GL_ACCOUNT_LONG Allow NULL? 
441SK_TXT20Reconciliation Account: Short Textnvarchar200CHAR(N' ')YesFAGL_TEXT_SAKNR_SHORT Allow NULL? 
442SK_TXT50Reconciliation Account: Long Textnvarchar500CHAR(N' ')YesFAGL_TEXT_SAKNR_LONG Allow NULL? 
NamePrimaryUniqueTypeColumns
GLPOS_C_VEN_CT~0YesYesCLUSTEREDMANDT