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
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8/OPT/Z1344Reporting table: Text table for exception definitions
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

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

SELECT MANDT, BELNR, TYPE, AWTYP, SEQUENCE_BELNR, AWSYS, WERKS, MATNR, BWTAR, KDAUF, KDPOS, PSPNR, ELEHK, OBJNR, OBJNR_P, AUFPL, APLZL, VORNR, PLNFL, ARBID, AUFPL_B, APLZL_B, VORNR_B, PLNFL_B, RUECK, RMZHL, PRTNR, USNAM, BUDAT, GJAHR, PERIOD, BLDAT, CPUDT, CPUTM, AGRND, NGRND, MGRND, KOKRS, RESPCC, NOTIF_NUMBER, FCO_ACC_OBJ, PRCTR, GSBER, KOSGR, AUTOWE, STOKZ, STFLG, XQUANT, RQUANT, RBQUANT, RBXQUANT, MEINH, PLNME, UMREZ, UMREN, REWORK_COMPL, VALUATED, NO_VALUATION, REFBN_CANCEL, REFBN_REWORK, REVLV FROM FCO_DOC_HEAD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BELNRFailure Cost Document Numbernvarchar100CHAR(N' ')NoFCO_BELNR Allow NULL? 
3TYPEFailure Cost Document Categorynvarchar20CHAR(N' ')YesFCO_TYPE Allow NULL? 
4AWTYPReference Transactionnvarchar50CHAR(N' ')Yes*AWTYP Allow NULL? 
5SEQUENCE_BELNRSequential Number for Failure Cost Documentnvarchar100CHAR(N' ')YesFCO_SEQUENCE_BELNR Allow NULL? 
6AWSYSLogical Systemnvarchar100CHAR(N' ')Yes*LOGSYSTEM Allow NULL? 
7WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
8MATNRMaterial Number for Ordernvarchar180CHAR(N' ')YesMARACO_MATNR Allow NULL? 
9BWTARValuation Typenvarchar100CHAR(N' ')Yes*BWTAR_D Allow NULL? 
10KDAUFSales Order Numbernvarchar100CHAR(N' ')YesVBUKKDAUF Allow NULL? 
11KDPOSItem Number in Sales Ordernvarchar60NUMC(N'000000')YesKDPOS Allow NULL? 
12PSPNRWork breakdown structure element (WBS element)nvarchar80NUMC(N'00000000')YesPRPSPS_PSP_ELE Allow NULL? 
13ELEHKCost Component Structure - CGM and Sales/Administr. Costsnvarchar20CHAR(N' ')Yes*CK_ELESMHK Allow NULL? 
14OBJNRObject numbernvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
15OBJNR_PObject numbernvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
16AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
17APLZLInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
18VORNROperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
19PLNFLSequencenvarchar60CHAR(N' ')YesPLNFOLGE Allow NULL? 
20ARBIDObject IDnvarchar80NUMC(N'00000000')YesOBJEKTID Allow NULL? 
21AUFPL_BRouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
22APLZL_BInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
23VORNR_BOperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
24PLNFL_BSequencenvarchar60CHAR(N' ')YesPLNFOLGE Allow NULL? 
25RUECKCompletion confirmation number for the operationnvarchar100NUMC(N'0000000000')YesCO_RUECK Allow NULL? 
26RMZHLConfirmation counternvarchar80NUMC(N'00000000')YesCO_RMZHL Allow NULL? 
27PRTNRConfirmation numbernvarchar100NUMC(N'0000000000')Yes*PRTNR Allow NULL? 
28USNAMUser namenvarchar120CHAR(N' ')Yes*USNAM Allow NULL? 
29BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
30GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
31PERIODPeriodnvarchar30NUMC(N'000')YesCO_PERIO Allow NULL? 
32BLDATDocument Datenvarchar80DATS(N'00000000')YesCO_BLDAT Allow NULL? 
33CPUDTDate Document Was Creatednvarchar80DATS(N'00000000')YesCO_CPUDT Allow NULL? 
34CPUTMTime At Which Document Was Enterednvarchar60TIMS(N'000000')YesCO_CPUTM Allow NULL? 
35AGRNDReason for Variancenvarchar40CHAR(N' ')Yes*CO_AGRND Allow NULL? 
36NGRNDReason for Reworknvarchar40CHAR(N' ')Yes*FCO_REWORK_REASON Allow NULL? 
37MGRNDReason for Additional Expensenvarchar40CHAR(N' ')Yes*FCO_EXCESS_REASON Allow NULL? 
38KOKRSControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
39RESPCCCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
40NOTIF_NUMBERNotification Nonvarchar120CHAR(N' ')YesQMELQMNUM Allow NULL? 
41FCO_ACC_OBJAccount Assignment Object in Failure Cost Processingnvarchar220CHAR(N' ')Yes*FCO_ACC_OBJ Allow NULL? 
42PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
43GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
44KOSGRCosting Overhead Groupnvarchar100CHAR(N' ')Yes*CK_KOSGR Allow NULL? 
45AUTOWEAutomatic Goods Receipt for Inward Transfer of Reworkchar10CHAR(N' ')YesFCO_AUTOWE Allow NULL? 
46STOKZIndicator: Document Has Been Reversedchar10CHAR(N' ')YesCO_STOKZ Allow NULL? 
47STFLGIdentifier for reversal documentchar10CHAR(N' ')YesCO_STFLG Allow NULL? 
48XQUANTAssembly Scrap Quantitydecimal153QUAN((0))NoFCO_XQUANT
49RQUANTQuantity Transferred Outward for Reworkdecimal153QUAN((0))NoFCO_RQUANT
50RBQUANTRework Quantity Transferred Inward as Yielddecimal153QUAN((0))NoFCO_RBQUANT
51RBXQUANTScrap Quantity Reworkdecimal153QUAN((0))NoFCO_RBXQUANT
52MEINHUnit of Measure for Activity/Operationnvarchar30UNIT(N' ')Yes*VORME Allow NULL? 
53PLNMETask list unit of measurenvarchar30UNIT(N' ')Yes*PLNME Allow NULL? 
54UMREZNumerator for Conversion to Base Units of Measuredecimal50DEC((0))YesUMREZ
55UMRENDenominator for conversion to base units of measuredecimal50DEC((0))YesUMREN
56REWORK_COMPLRework Completed Indicatorchar10CHAR(N' ')YesFCO_REWORK_COMPL Allow NULL? 
57VALUATEDDocument Valuatedchar10CHAR(N' ')YesFCO_VALUATED Allow NULL? 
58NO_VALUATIONNo Valuation of Documentchar10CHAR(N' ')YesFCO_NO_VALUATION Allow NULL? 
59REFBN_CANCELFailure Cost Document Numbernvarchar100CHAR(N' ')YesFCO_BELNR Allow NULL? 
60REFBN_REWORKFailure Cost Document Numbernvarchar100CHAR(N' ')YesFCO_BELNR Allow NULL? 
61REVLVRevision Levelnvarchar20CHAR(N' ')YesREVLV Allow NULL? 
NamePrimaryUniqueTypeColumns
FCO_DOC_HEAD~0YesYesCLUSTEREDBELNR, MANDT
FCO_DOC_HEAD~001NoNoNONCLUSTEREDOBJNR_P, OBJNR, TYPE, MANDT
FCO_DOC_HEAD~002NoNoNONCLUSTEREDWERKS, MATNR, TYPE, MANDT
FCO_DOC_HEAD~003NoNoNONCLUSTEREDOBJNR_P, TYPE, MANDT
FCO_DOC_HEAD~004NoNoNONCLUSTEREDREFBN_REWORK, MANDT