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
9BSEG345Accounting Document Segment
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OIVL77Whse Journal
6OPCH268A/P Invoice
7OOCR9Loading Factors
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
Financial Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ACCTIT1932Compressed Data from FI/CO DocumentFinancial Accounting
SQL:  selectupdate insert create

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

SELECT MANDT, AWTYP, AWREF, AWORG, POSNR, KSTAT, AWREF_REV, AWORG_REV, BUKRS, BELNR, GJAHR, BLDAT, BUDAT, WWERT, VALUT, MONAT, BLART, XBLNR, VORGN, PRVRG, PRVRG_SV, KTOSL, UMSKZ, BSCHL, SHKZG, PSWSL, PSWBT, KOART, KUNNR, LIFNR, SAKNR, HKONT, ALTKT, GVTYP, SGTXT, GSBER, KOSTL, KOKRS, PERNR, BPMNG, BPRME, AUFNR, ANLN1, ANLN2, ANBWA, RMVCT, ABUKR, AIBN1, AIBN2, MATNR, MENGE, MEINS, WERKS, BWART, PARGB, GSBER_GP, BUZID, HOART, HRKFT, HKMAT, IMKEY, KSTRG, PAOBJNR, PRCTR, PPRCTR, PS_PSP_PNR, NPLNR, AUFPL, VBELN, KDAUF, KDPOS, KZVBR, KZBWS, SOBKZ, VBUND, BWKEY, BWTAR, VNAME, EGRUP, BTYPE, EBELN, EBELP, ZEKKN, RECID, VPTNR, XBILK, XUMSW, KZBEW, TBTKZ, XUMBW, SCOPE, AUTYP, XMFRW, BKLAS, BWMOD, MTART, KZUML, XPKON, KOAID, EPRCTR, FIKRS, FIPOS, FISTL, GEBER, KBLNR, KBLPOS, LOTKZ, STTAX, BEMOT, CO_KAKST, CO_KAAUF, CO_KAPRO, CO_KAKTR, CO_KANPL, CO_KAIMO, CO_KAKDA, CO_KAERG, CO_KAABS, CO_KAPRZ, CO_KASAT, ZZSPREG, ZZBUSPARTN, ZZPRODUCT, ZZLOCA, ZZCHAN, ZZLOB, ZZNFAL, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, ZZREGION, ZZSTATE, BUSTW, ZEILE, URZEILE, PSTYP, FKBER, ERFMG, ERFME, DABRZ, APLZL, BUPLA, SECCO, LOKKT, LSTAR, PRZNR, XNEGP, MAT_KDAUF, MAT_KDPOS, MAT_PSPNR, LOGVO, XBGBB, TPKNZ, GRANT_NBR, AUFPS, SEGMENT, PSEGMENT, BUDGET_PD, AUBEL, AUPOS, BUZEI, MEASURE, MWSKZ, POSN2, POSNR_SD, PSOBT, PSOZL, REBZG, REBZJ, REBZT, REBZZ, SHKZG_VA, STHTX, TAXIT, TXJCD, VBEL2, XAUTO, XREF2, XREF3, ZBD1P, ZBD1T, ZBD2T, ZBD3T, ZFBDT, ZUONR, FMXDOCNR, FMXYEAR, FMXDOCLN, FMXZEKKN, ANL01, ANL02, HBKID, PRODPER FROM ACCTIT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2AWTYPReference Transactionnvarchar50CHAR(N' ')No*AWTYP Allow NULL? 
3AWREFReference Document Numbernvarchar100CHAR(N' ')NoAWREF Allow NULL? 
4AWORGReference Organizational Unitsnvarchar100CHAR(N' ')NoAWORG Allow NULL? 
5POSNRAccounting Document Line Item Numbernvarchar100NUMC(N'0000000000')NoPOSNR_ACC Allow NULL? 
6KSTATIndicator for Statistical Line Itemschar10CHAR(N' ')NoKSTAZ Allow NULL? 
7AWREF_REVReversal: Reverse Document Reference Document Numbernvarchar100CHAR(N' ')NoAWREF_REV Allow NULL? 
8AWORG_REVReversal: Reverse Document Reference Organizationnvarchar100CHAR(N' ')NoAWORG_REV Allow NULL? 
9BUKRSCompany Codenvarchar40CHAR(N' ')No*BUKRS Allow NULL? 
10BELNRAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
11GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
12BLDATDocument Date in Documentnvarchar80DATS(N'00000000')NoBLDAT Allow NULL? 
13BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')NoBUDAT Allow NULL? 
14WWERTTranslation Datenvarchar80DATS(N'00000000')NoWWERT_D Allow NULL? 
15VALUTValue datenvarchar80DATS(N'00000000')NoVALUT Allow NULL? 
16MONATFiscal Periodnvarchar20NUMC(N'00')NoMONAT Allow NULL? 
17BLARTDocument Typenvarchar20CHAR(N' ')No*BLART Allow NULL? 
18XBLNRReference Document Numbernvarchar160CHAR(N' ')NoXBLNR1 Allow NULL? 
19VORGNTransaction Type for General Ledgernvarchar40CHAR(N' ')NoVORGN Allow NULL? 
20PRVRGBusiness transaction for validationsnvarchar40CHAR(N' ')No*PRVRG Allow NULL? 
21PRVRG_SVBusiness transaction for status managementnvarchar40CHAR(N' ')No*PRVRG_SV Allow NULL? 
22KTOSLTransaction Keynvarchar30CHAR(N' ')NoKTOSL Allow NULL? 
23UMSKZSpecial G/L Indicatorchar10CHAR(N' ')No*UMSKZ Allow NULL? 
24BSCHLPosting Keynvarchar20CHAR(N' ')No*BSCHL Allow NULL? 
25SHKZGDebit/Credit Indicatorchar10CHAR(N' ')NoSHKZG Allow NULL? 
26PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50CUKY(N' ')No*PSWSL Allow NULL? 
27PSWBTAmount for Updating in General Ledgerdecimal132CURR((0))NoPSWBT
28KOARTAccount Typechar10CHAR(N' ')NoKOART Allow NULL? 
29KUNNRCustomer Numbernvarchar100CHAR(N' ')No*KUNNR Allow NULL? 
30LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')No*LIFNR Allow NULL? 
31SAKNRG/L Account Numbernvarchar100CHAR(N' ')No*SAKNR Allow NULL? 
32HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')No*HKONT Allow NULL? 
33ALTKTAccount Number in Groupnvarchar100CHAR(N' ')NoALTKT Allow NULL? 
34GVTYPP&L statement account typenvarchar20CHAR(N' ')NoGVTYP Allow NULL? 
35SGTXTItem Textnvarchar500CHAR(N' ')NoSGTXT Allow NULL? 
36GSBERBusiness Areanvarchar40CHAR(N' ')No*GSBER Allow NULL? 
37KOSTLCost Centernvarchar100CHAR(N' ')No*KOSTL Allow NULL? 
38KOKRSControlling Areanvarchar40CHAR(N' ')No*KOKRS Allow NULL? 
39PERNRPersonnel Numbernvarchar80NUMC(N'00000000')NoPERNR_D Allow NULL? 
40BPMNGQuantity in Purchase Order Price Unitdecimal133QUAN((0))NoBPMNG
41BPRMEOrder Price Unit (Purchasing)nvarchar30UNIT(N' ')No*BPRME Allow NULL? 
42AUFNROrder Numbernvarchar120CHAR(N' ')No*AUFNR Allow NULL? 
43ANLN1Main Asset Numbernvarchar120CHAR(N' ')No*ANLN1 Allow NULL? 
44ANLN2Asset Subnumbernvarchar40CHAR(N' ')No*ANLN2 Allow NULL? 
45ANBWAAsset Transaction Typenvarchar30CHAR(N' ')No*ANBWA Allow NULL? 
46RMVCTTransaction Typenvarchar30CHAR(N' ')No*RMVCT Allow NULL? 
47ABUKRCompany Code which will be Cleared Againstnvarchar40CHAR(N' ')No*ABUKR Allow NULL? 
48AIBN1Original asset that was transferrednvarchar120CHAR(N' ')No*AIBN1 Allow NULL? 
49AIBN2Original asset that was transferrednvarchar40CHAR(N' ')No*AIBN2 Allow NULL? 
50MATNRMaterial Numbernvarchar180CHAR(N' ')No*MATNR Allow NULL? 
51MENGEQuantitydecimal133QUAN((0))NoMENGE_D
52MEINSBase Unit of Measurenvarchar30UNIT(N' ')No*MEINS Allow NULL? 
53WERKSPlantnvarchar40CHAR(N' ')No*WERKS_D Allow NULL? 
54BWARTMovement Type (Inventory Management)nvarchar30CHAR(N' ')No*BWART Allow NULL? 
55PARGBTrading partner's business areanvarchar40CHAR(N' ')No*PARGB Allow NULL? 
56GSBER_GPBusiness area reported to the partnernvarchar40CHAR(N' ')No*GSBER_GP Allow NULL? 
57BUZIDIdentification of the Line Itemchar10CHAR(N' ')NoBUZID Allow NULL? 
58HOARTType of origin object (EC-PCA)nvarchar20NUMC(N'00')NoHOART Allow NULL? 
59HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40CHAR(N' ')No*HRKFT Allow NULL? 
60HKMATMaterial-related originchar10CHAR(N' ')NoHKMAT Allow NULL? 
61IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')NoIMKEY Allow NULL? 
62KSTRGCost Objectnvarchar120CHAR(N' ')No*KSTRG Allow NULL? 
63PAOBJNRProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')NoRKEOBJNR Allow NULL? 
64PRCTRProfit Centernvarchar100CHAR(N' ')No*PRCTR Allow NULL? 
65PPRCTRPartner Profit Centernvarchar100CHAR(N' ')No*PPRCTR Allow NULL? 
66PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')No*PS_PSP_PNR Allow NULL? 
67NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')No*NPLNR Allow NULL? 
68AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')NoCO_AUFPL Allow NULL? 
69VBELNSales and Distribution Document Numbernvarchar100CHAR(N' ')No*VBELN Allow NULL? 
70KDAUFSales Order Numbernvarchar100CHAR(N' ')No*KDAUF Allow NULL? 
71KDPOSItem Number in Sales Ordernvarchar60NUMC(N'000000')NoKDPOS Allow NULL? 
72KZVBRConsumption Postingchar10CHAR(N' ')NoKZVBR Allow NULL? 
73KZBWSValuation of Special Stockchar10CHAR(N' ')YesKZBWS Allow NULL? 
74SOBKZSpecial Stock Indicatorchar10CHAR(N' ')Yes*SOBKZ Allow NULL? 
75VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')No*RASSC Allow NULL? 
76BWKEYValuation Areanvarchar40CHAR(N' ')No*BWKEY Allow NULL? 
77BWTARValuation Typenvarchar100CHAR(N' ')No*BWTAR_D Allow NULL? 
78VNAMEJoint Venturenvarchar60CHAR(N' ')No*JV_NAME Allow NULL? 
79EGRUPEquity groupnvarchar30CHAR(N' ')No*JV_EGROUP Allow NULL? 
80BTYPEPayroll Typenvarchar20CHAR(N' ')No*JV_BILIND Allow NULL? 
81EBELNPurchasing Document Numbernvarchar100CHAR(N' ')No*EBELN Allow NULL? 
82EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')No*EBELP Allow NULL? 
83ZEKKNSequential Number of Account Assignmentnvarchar20NUMC(N'00')YesDZEKKN Allow NULL? 
84RECIDRecovery Indicatornvarchar20CHAR(N' ')No*JV_RECIND Allow NULL? 
85VPTNRPartner account numbernvarchar100CHAR(N' ')No*JV_PART Allow NULL? 
86XBILKIndicator: Account is a balance sheet account?char10CHAR(N' ')NoXBILK Allow NULL? 
87XUMSWIndicator: Sales-related item ?char10CHAR(N' ')NoXUMSW Allow NULL? 
88KZBEWMovement Indicatorchar10CHAR(N' ')NoKZBEW Allow NULL? 
89TBTKZIndicator: subsequent debit/creditchar10CHAR(N' ')NoTBTKZ Allow NULL? 
90XUMBWRevaluationchar10CHAR(N' ')NoXUMBW Allow NULL? 
91SCOPEObject Classnvarchar20CHAR(N' ')NoSCOPE_CV Allow NULL? 
92AUTYPOrder categorynvarchar20NUMC(N'00')NoAUFTYP Allow NULL? 
93XMFRWIndicator: Update quantity in RWchar10CHAR(N' ')NoXMFRW Allow NULL? 
94BKLASValuation Classnvarchar40CHAR(N' ')No*BKLAS Allow NULL? 
95BWMODValuation Grouping Codenvarchar40CHAR(N' ')NoBWMOD Allow NULL? 
96MTARTMaterial Typenvarchar40CHAR(N' ')No*MTART Allow NULL? 
97KZUMLStock transfer/transfer postingchar10CHAR(N' ')NoKZUML Allow NULL? 
98XPKONCheck account assignmentchar10CHAR(N' ')NoXPKON Allow NULL? 
99KOAIDCondition classchar10CHAR(N' ')NoKOAID Allow NULL? 
100EPRCTRPartner profit center for elimination of internal businessnvarchar100CHAR(N' ')No*EPRCTR Allow NULL? 
101FIKRSFinancial Management Areanvarchar40CHAR(N' ')No*FIKRS Allow NULL? 
102FIPOSCommitment Itemnvarchar140CHAR(N' ')No*FIPOS Allow NULL? 
103FISTLFunds Centernvarchar160CHAR(N' ')No*FISTL Allow NULL? 
104GEBERFundnvarchar100CHAR(N' ')No*BP_GEBER Allow NULL? 
105KBLNRDocument Number for Earmarked Fundsnvarchar100CHAR(N' ')No*KBLNR Allow NULL? 
106KBLPOSEarmarked Funds: Document Itemnvarchar30NUMC(N'000')No*KBLPOS Allow NULL? 
107LOTKZLot Number for Documentsnvarchar100CHAR(N' ')NoLOTKZ Allow NULL? 
108STTAXTax amount as statistical information in document currencydecimal132CURR((0))NoSTTAX
109BEMOTAccounting Indicatornvarchar20CHAR(N' ')Yes*BEMOT Allow NULL? 
110CO_KAKSTAccount Assignment Type: Cost Centerchar10NUMC(N'0')NoCO_KAKST Allow NULL? 
111CO_KAAUFAccount assignment type: Orderchar10NUMC(N'0')NoCO_KAAUF Allow NULL? 
112CO_KAPROProject account assignment typechar10NUMC(N'0')NoCO_KAPRO Allow NULL? 
113CO_KAKTRAccount Assignment Type: Cost Objectchar10NUMC(N'0')NoCO_KAKTR Allow NULL? 
114CO_KANPLAccount Assignment Type: Networkchar10NUMC(N'0')NoCO_KANPL Allow NULL? 
115CO_KAIMOAccount Assignment Type: Real Estate Objectchar10NUMC(N'0')NoCO_KAIMO Allow NULL? 
116CO_KAKDAAccount Assignment Type: Sales Orderchar10NUMC(N'0')NoCO_KAKDA Allow NULL? 
117CO_KAERGBusiness segment account assignment typechar10NUMC(N'0')NoCO_KAERG Allow NULL? 
118CO_KAABSAccount assignment type: reconciliation objectchar10NUMC(N'0')NoCO_KAABS Allow NULL? 
119CO_KAPRZAccount Assignment Type: Business Processchar10NUMC(N'0')YesCO_KAPRZ Allow NULL? 
120CO_KASATAccount Assignment Type Not Usedchar10NUMC(N'0')YesCO_KASAT Allow NULL? 
121ZZSPREGSpecial Regionnvarchar50CHAR(N' ')YesZZSPREGZREGION Allow NULL? 
122ZZBUSPARTNBusiness partnernvarchar100CHAR(N' ')YesZZBUSPARTN Allow NULL? 
123ZZPRODUCTProduct groupnvarchar100CHAR(N' ')YesZZPRODUCT Allow NULL? 
124ZZLOCACitynvarchar40CHAR(N' ')YesZZLOCA Allow NULL? 
125ZZCHANDistribution channelnvarchar40CHAR(N' ')YesZZCHAN Allow NULL? 
126ZZLOBBUSINESS LINEnvarchar70CHAR(N' ')Yes*ZZLOB Allow NULL? 
127ZZNFALnvarchar100(N' ')Yes Allow NULL? 
128ZZUSERFLD1Territorynvarchar90CHAR(N' ')YesZFU1ZZUSERFLD1 Allow NULL? 
129ZZUSERFLD2Owner/Cont.nvarchar120CHAR(N' ')YesZZUSERFLD2 Allow NULL? 
130ZZUSERFLD3Veinnvarchar220CHAR(N' ')YesZZUSERFLD3 Allow NULL? 
131ZZREGIONLocationnvarchar30CHAR(N' ')YesZREGZZREGION Allow NULL? 
132ZZSTATEState/Province Codenvarchar30CHAR(N' ')YesT005SZZSTATE Allow NULL? 
133BUSTWPosting string for valuesnvarchar40CHAR(N' ')YesBUSTW Allow NULL? 
134ZEILEItem in material or invoice verification documentnvarchar60NUMC(N'000000')YesCK_ZEILE Allow NULL? 
135URZEILEOriginal item in material or invoice documentnvarchar60NUMC(N'000000')YesCK_URZEILE Allow NULL? 
136PSTYPItem Category in Purchasing Documentchar10CHAR(N' ')Yes*PSTYP Allow NULL? 
137FKBERFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
138ERFMGQuantity in Unit of Entrydecimal133QUAN((0))YesERFMG
139ERFMEUnit of Entrynvarchar30UNIT(N' ')Yes*ERFME Allow NULL? 
140DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
141APLZLInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
142BUPLABusiness Placenvarchar40CHAR(N' ')Yes*BUPLA Allow NULL? 
143SECCOSection Codenvarchar40CHAR(N' ')Yes*SECCO Allow NULL? 
144LOKKTAccount Number in the Local Chart of Accountsnvarchar100CHAR(N' ')Yes*LOKKT Allow NULL? 
145LSTARActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
146PRZNRBusiness Processnvarchar120CHAR(N' ')Yes*CO_PRZNR Allow NULL? 
147XNEGPIndicator: Negative postingchar10CHAR(N' ')YesXNEGP Allow NULL? 
148MAT_KDAUFSales Order Number of Valuated Sales Order Stocknvarchar100CHAR(N' ')Yes*MAT_KDAUF Allow NULL? 
149MAT_KDPOSSales Order Item of Valuated Sales Order Stocknvarchar60NUMC(N'000000')YesMAT_KDPOS Allow NULL? 
150MAT_PSPNRValuated Sales Order Stock WBS Elementnvarchar80NUMC(N'00000000')Yes*MAT_PSPNR Allow NULL? 
151LOGVOLogical Transactionnvarchar60CHAR(N' ')YesLOGVO Allow NULL? 
152XBGBBPosting for offsetting entrychar10CHAR(N' ')YesXBGBB Allow NULL? 
153TPKNZTransfer Price Indicatorchar10NUMC(N'0')YesTPKNZ Allow NULL? 
154GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
155AUFPSOrder Item Numbernvarchar40NUMC(N'0000')YesCO_POSNR Allow NULL? 
156SEGMENTSegment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_SEGMENT Allow NULL? 
157PSEGMENTPartner Segment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_PSEGMENT Allow NULL? 
158BUDGET_PDFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
159AUBELSales Documentnvarchar100CHAR(N' ')Yes*VBELN_VA Allow NULL? 
160AUPOSSales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
161BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')YesBUZEI Allow NULL? 
162MEASUREFunded Programnvarchar240CHAR(N' ')Yes*FM_MEASURE Allow NULL? 
163MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
164POSN2Sales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
165POSNR_SDItem number of the SD documentnvarchar60NUMC(N'000000')Yes*POSNR Allow NULL? 
166PSOBTPosting Daynvarchar80DATS(N'00000000')YesPSOBT Allow NULL? 
167PSOZLCheckboxchar10CHAR(N' ')YesXFELD Allow NULL? 
168REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
169REBZJFiscal Year of the Relevant Invoice (for Credit Memo)nvarchar40NUMC(N'0000')YesREBZJ Allow NULL? 
170REBZTFollow-On Document Typechar10CHAR(N' ')YesREBZT Allow NULL? 
171REBZZLine Item in the Relevant Invoicenvarchar30NUMC(N'000')YesREBZZ Allow NULL? 
172SHKZG_VAReturns Itemchar10CHAR(N' ')YesSHKZG_VA Allow NULL? 
173STHTXTax Amount as Statistical Information in Co. Code Currencydecimal132CURR((0))YesSTHTX
174TAXITIndicator: Tax Itemchar10CHAR(N' ')YesTAXIT Allow NULL? 
175TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
176VBEL2Sales Documentnvarchar100CHAR(N' ')Yes*VBELN_VA Allow NULL? 
177XAUTOIndicator: Line item automatically createdchar10CHAR(N' ')YesXAUTO Allow NULL? 
178XREF2Business partner reference keynvarchar120CHAR(N' ')YesXREF2 Allow NULL? 
179XREF3Reference key for line itemnvarchar200CHAR(N' ')YesXREF3 Allow NULL? 
180ZBD1PCash Discount Percentage 1decimal53DEC((0))YesDZBD1P
181ZBD1TCash discount days 1decimal30DEC((0))YesDZBD1T
182ZBD2TCash discount days 2decimal30DEC((0))YesDZBD2T
183ZBD3TNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
184ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
185ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
186FMXDOCNRFM Reference Document Numbernvarchar100CHAR(N' ')YesFM_XDOCNR Allow NULL? 
187FMXYEARFM Reference Yearnvarchar40NUMC(N'0000')YesFM_XYEAR Allow NULL? 
188FMXDOCLNFM Reference Line Itemnvarchar60NUMC(N'000000')YesFM_XDOCLN Allow NULL? 
189FMXZEKKNFM Reference Sequence Account Assignmentnvarchar50NUMC(N'00000')YesFM_XZEKKN Allow NULL? 
190ANL01Main Asset Numbernvarchar120CHAR(N' ')YesANLHANLN1 Allow NULL? 
191ANL02Asset Subnumbernvarchar40CHAR(N' ')YesANLAANLN2 Allow NULL? 
192HBKIDShort Key for a House Banknvarchar50CHAR(N' ')YesT012HBKID Allow NULL? 
193PRODPERProduction Month (Date to find period and year)nvarchar80DATS(N'00000000')YesJV_PRODPER Allow NULL? 
NamePrimaryUniqueTypeColumns
ACCTIT~0YesYesCLUSTEREDPOSNR, AWORG, AWREF, AWTYP, MANDT
ACCTIT~1NoNoNONCLUSTEREDAWTYP, BUKRS, MONAT, GJAHR