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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

147 columns | Print definition?ERP 6.0  | PPRCTR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010MIItems for Class SD01 - Raw Data102PPRCTRPartner Profit Centernvarchar100
2/BIC/B0000171000PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances22PPRCTRnvarchar100
3/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.23PPRCTRnvarchar100
4/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs25PPRCTRnvarchar100
5/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)25PPRCTRnvarchar100
6CE1PR22Périm. résultat IDES50PPRCTRCentre de profit partenairenvarchar100
7CE2PR22Périm. résultat IDES38PPRCTRCentre de profit partenairenvarchar100
8CE4PR22Périm. résultat IDES22PPRCTRCentre de profit partenairenvarchar100
9CE4PR22_ACCTPérim. résultat IDES20PPRCTRCentre de profit partenairenvarchar100
10CE4PR22_FLAGPérim. résultat IDES19PPRCTRFlag : caract. imputée manuellement ou via TKEZUnvarchar10
11CE4PR22_KENCPérim. résultat IDES21PPRCTRCentre de profit partenairenvarchar100
12FAGLFLEXCEMU: Sum of Open Items of Table FAGLFLEXT32PPRCTRPartner Profit Centernvarchar100
13FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT34PPRCTRPartner Profit Centernvarchar100
14FAGLFLEXT_BAKGeneral Ledger: Totals34PPRCTRPartner Profit Centernvarchar100
15FAGLFLEXT_DIFDelta Table: G/L Totals34PPRCTRPartner Profit Centernvarchar100
16TKMGBBusiness area consolidation: SD assignments10PPRCTRPartner Profit Centernvarchar100
17TLMGBBusiness area consolidation: MM assignments10PPRCTRPartner Profit Centernvarchar100
TOPAccounting Interface
18GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)172PPRCTRPartner Profit Centernvarchar100
19GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)172PPRCTRPartner Profit Centernvarchar100
TOPActual CostingMaterial Ledger
20MLCOMaterial valuation document account assignment information14PPRCTRPartner Profit Centernvarchar100
TOPAlternative Valuation Run
21CKMLAVRDOCITLines for Cumulation Posting Document22PPRCTRPartner Profit Centernvarchar100
TOPBasic Settings
22A141Dependent on material and receiver profit center7PPRCTRPartner Profit Centernvarchar100
TOPBilling
23VBRPBilling Document: Item Data215PPRCTRPartner Profit Centernvarchar100
TOPConditions
24A902Condition Table for Pricing A9026PPRCTRPartner Profit Centernvarchar100
25A903Condition Table for Pricing A9036PPRCTRPartner Profit Centernvarchar100
TOPData Retention Tool
26TXW_S_MSEGRetrieve MSEG from archive43PPRCTRPartner Profit Centernvarchar100
TOPElectronic Bank Statement
27FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)30PPRCTRPartner Profit Centernvarchar100
28FEB_ACTAcct Assignment Templates30PPRCTRPartner Profit Centernvarchar100
TOPFinancial Accounting
29ACCTITCompressed Data from FI/CO Document65PPRCTRPartner Profit Centernvarchar100
30FBICRC003AICRC: Open Items Customers/Vendors: Documents44PPRCTRPartner Profit Centernvarchar100
31VBSEGADocument Segment for Document Parking - Asset Database59PPRCTRPartner Profit Centernvarchar100
32VBSEGSDocument Segment for Document Parking - G/L Account Database39PPRCTRPartner Profit Centernvarchar100
TOPFunds Management-Specific Postings
33FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years40PPRCTRPartner Profit Centernvarchar100
34PSOSEGSRecurring Request Document Segment, G/L Accounts39PPRCTRPartner Profit Centernvarchar100
TOPGeneral Ledger Accounting
35FAGLCOFITRACELog of Real-Time Integration CO->FI19PPRCTRPartner Profit Centernvarchar100
36FAGLFLEX06General ledger: Sender SAP additional account assignment3PPRCTRPartner Profit Centernvarchar100
37FAGLFLEXAGeneral Ledger: Actual Line Items25PPRCTRPartner Profit Centernvarchar100
38FAGLFLEXPGeneral Ledger: Plan Line Items27PPRCTRPartner Profit Centernvarchar100
39FAGLFLEXTGeneral Ledger: Totals34PPRCTRPartner Profit Centernvarchar100
40FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records26PPRCTRPartner Profit Centernvarchar100
41FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis24PPRCTRPartner Profit Centernvarchar100
42FAGL_SPLINFOSplittling Information of Open Items15PPRCTRPartner Profit Centernvarchar100
43GLFLEX06General ledger: Sender SAP additional account assignment3PPRCTRPartner Profit Centernvarchar100
44GLFLEXAFlexible general ledger: Actual line items20PPRCTRPartner Profit Centernvarchar100
45GLFLEXPFlexible G/L: Plan line items20PPRCTRPartner Profit Centernvarchar100
46GLFLEXTFlexible G/L: Totals26PPRCTRPartner Profit Centernvarchar100
TOPGeneral Ledger Reorganization
47FAGL_R_APARReorganization: Object List for Receivables and Payables16PPRCTRPartner Profit Centernvarchar100
48FAGL_R_BLNCEReorganization: Balances to Be Transferred29PPRCTRPartner Profit Centernvarchar100
49FAGL_R_MAP_SAPReorganization: Object Number of the Included SAP Fields9PPRCTRPartner Profit Centernvarchar100
50FAGL_R_SPLReorganization: Splitting Information of the Open Items14PPRCTRPartner Profit Centernvarchar100
TOPGL Account Posting
51TCJ_POSITIONSCash Journal Document Items37PPRCTRPartner Profit Centernvarchar100
TOPInventory Management
52MSEGDocument Segment: Material144PPRCTRPartner Profit Centernvarchar100
53MWXMSEGZMSEG: Interface for Posting of Value144PPRCTRPartner Profit Centernvarchar100
54MWZMSEGZMSEG:Interface for Posting of Value144PPRCTRPartner Profit Centernvarchar100
TOPJoint Venture und Production Sharing Accounting
55JVGLFLEX06General ledger: Sender SAP additional account assignment3PPRCTRPartner Profit Centernvarchar100
56JVGLFLEXAGeneral Ledger: Actual Line Items24PPRCTRPartner Profit Centernvarchar100
57JVGLFLEXPGeneral Ledger: Plan Line Items26PPRCTRPartner Profit Centernvarchar100
58JVGLFLEXTGeneral Ledger: Totals33PPRCTRPartner Profit Centernvarchar100
TOPProfitability Analysis
59CE1850050PPRCTRPartner Profit Centernvarchar100
60CE1BGISErgebnisbereich für50PPRCTRPartnerprofitcenternvarchar100
61CE1E_B1Model Bank50PPRCTRPartner Profit Centernvarchar100
62CE1IDEAOp. Concern BR World50PPRCTRPartner Profit Centernvarchar100
63CE1IDEBErgebnisbereich IDES50PPRCTRPartnerprofitcenternvarchar100
64CE1IDESErgebnisbereich IDES50PPRCTRPartnerprofitcenternvarchar100
65CE1INT1Ergebnisbereich IDES50PPRCTRPartnerprofitcenternvarchar100
66CE1OC01Bike International50PPRCTRPartner Profit Centernvarchar100
67CE1R300Operating Concern IDES50PPRCTRPartner Profit Centernvarchar100
68CE1S001Sample operating concern75PPRCTRPartner Profit Centernvarchar100
69CE1S300Operating Concern IDES50PPRCTRPartner Profit Centernvarchar100
70CE1S_ALAirline Route Profit50PPRCTRPartner Profit Centernvarchar100
71CE1S_CPTemplate for Consumer Goods Industry50PPRCTRPartner Profit Centernvarchar100
72CE1S_GOQuickstart Template50PPRCTRPartner Profit Centernvarchar100
73CE2850038PPRCTRPartner Profit Centernvarchar100
74CE2BGISErgebnisbereich für38PPRCTRPartnerprofitcenternvarchar100
75CE2E_B1Model Bank38PPRCTRPartner Profit Centernvarchar100
76CE2IDEAOp. Concern BR World38PPRCTRPartner Profit Centernvarchar100
77CE2IDEBErgebnisbereich IDES38PPRCTRPartnerprofitcenternvarchar100
78CE2IDESErgebnisbereich IDES38PPRCTRPartnerprofitcenternvarchar100
79CE2INT1Ergebnisbereich IDES38PPRCTRPartnerprofitcenternvarchar100
80CE2OC01Bike International38PPRCTRPartner Profit Centernvarchar100
81CE2R300Operating Concern IDES38PPRCTRPartner Profit Centernvarchar100
82CE2S001Sample operating concern98PPRCTRPartner Profit Centernvarchar100
83CE2S300Operating Concern IDES38PPRCTRPartner Profit Centernvarchar100
84CE2S_ALAirline Route Profit38PPRCTRPartner Profit Centernvarchar100
85CE2S_CPTemplate for Consumer Goods Industry38PPRCTRPartner Profit Centernvarchar100
86CE2S_GOQuickstart Template38PPRCTRPartner Profit Centernvarchar100
87CE4850022PPRCTRPartner Profit Centernvarchar100
88CE48500_ACCT20PPRCTRPartner Profit Centernvarchar100
89CE48500_FLAG19PPRCTRFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
90CE48500_KENC21PPRCTRPartner Profit Centernvarchar100
91CE4BGISErgebnisbereich für22PPRCTRPartnerprofitcenternvarchar100
92CE4BGIS_ACCTErgebnisbereich für20PPRCTRPartnerprofitcenternvarchar100
93CE4BGIS_FLAGErgebnisbereich für19PPRCTRFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
94CE4BGIS_KENCErgebnisbereich für21PPRCTRPartnerprofitcenternvarchar100
95CE4E_B1Model Bank22PPRCTRPartner Profit Centernvarchar100
96CE4E_B1_ACCTModel Bank20PPRCTRPartner Profit Centernvarchar100
97CE4E_B1_FLAGModel Bank19PPRCTRFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
98CE4E_B1_KENCModel Bank21PPRCTRPartner Profit Centernvarchar100
99CE4IDEAOp. Concern BR World22PPRCTRPartner Profit Centernvarchar100
100CE4IDEA_ACCTOp. Concern BR World20PPRCTRPartner Profit Centernvarchar100
101CE4IDEA_FLAGOp. Concern BR World19PPRCTRFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
102CE4IDEA_KENCOp. Concern BR World21PPRCTRPartner Profit Centernvarchar100
103CE4IDEBErgebnisbereich IDES22PPRCTRPartnerprofitcenternvarchar100
104CE4IDEB_ACCTErgebnisbereich IDES20PPRCTRPartnerprofitcenternvarchar100
105CE4IDEB_FLAGErgebnisbereich IDES Banking19PPRCTRFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
106CE4IDEB_KENCErgebnisbereich IDES21PPRCTRPartnerprofitcenternvarchar100
107CE4IDESErgebnisbereich IDES22PPRCTRPartnerprofitcenternvarchar100
108CE4IDES_ACCTErgebnisbereich IDES20PPRCTRPartnerprofitcenternvarchar100
109CE4IDES_FLAGErgebnisbereich IDES19PPRCTRFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
110CE4IDES_KENCErgebnisbereich IDES21PPRCTRPartnerprofitcenternvarchar100
111CE4INT1Ergebnisbereich IDES22PPRCTRPartnerprofitcenternvarchar100
112CE4INT1_ACCTErgebnisbereich IDES20PPRCTRPartnerprofitcenternvarchar100
113CE4INT1_FLAGErgebnisbereich IDES19PPRCTRFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
114CE4INT1_KENCErgebnisbereich IDES21PPRCTRPartnerprofitcenternvarchar100
115CE4OC01Bike International22PPRCTRPartner Profit Centernvarchar100
116CE4OC01_ACCTBike International20PPRCTRPartner Profit Centernvarchar100
117CE4OC01_KENCBike International21PPRCTRPartner Profit Centernvarchar100
118CE4R300Operating Concern IDES22PPRCTRPartner Profit Centernvarchar100
119CE4R300_ACCTErgebnisbereich IDES20PPRCTRPartnerprofitcenternvarchar100
120CE4R300_FLAGErgebnisbereich IDES19PPRCTRFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
121CE4R300_KENCOperating Concern IDES21PPRCTRPartner Profit Centernvarchar100
122CE4S001Sample operating concern37PPRCTRPartner Profit Centernvarchar100
123CE4S001_ACCTSample operating con20PPRCTRPartner Profit Centernvarchar100
124CE4S001_FLAGSample Operating Concern 119PPRCTRFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
125CE4S001_KENCSample operating con36PPRCTRPartner Profit Centernvarchar100
126CE4S300Operating Concern IDES22PPRCTRPartner Profit Centernvarchar100
127CE4S300_ACCTOperating Concern IDES20PPRCTRPartner Profit Centernvarchar100
128CE4S300_FLAGErgebnisbereich IDES Serv.Prov19PPRCTRFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
129CE4S300_KENCOperating Concern IDES21PPRCTRPartner Profit Centernvarchar100
130CE4S_ALAirline Route Profit22PPRCTRPartner Profit Centernvarchar100
131CE4S_AL_ACCTAirline Route Profit20PPRCTRPartner Profit Centernvarchar100
132CE4S_AL_FLAGAirline Route Profit19PPRCTRFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
133CE4S_AL_KENCAirline Route Profit21PPRCTRPartner Profit Centernvarchar100
134CE4S_CPTemplate for Consumer Goods Industry22PPRCTRPartner Profit Centernvarchar100
135CE4S_CP_ACCTTemplate for Consumer Goods Industry20PPRCTRPartner Profit Centernvarchar100
136CE4S_CP_FLAGTemplate for Consumer Goods Industry19PPRCTRFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
137CE4S_CP_KENCTemplate for Consumer Goods Industry21PPRCTRPartner Profit Centernvarchar100
138CE4S_GOQuickstart Template22PPRCTRPartner Profit Centernvarchar100
139CE4S_GO_ACCTQuickstart Template20PPRCTRPartner Profit Centernvarchar100
140CE4S_GO_FLAGQuickstart Template19PPRCTRFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
141CE4S_GO_KENCQuickstart Template21PPRCTRPartner Profit Centernvarchar100
142CEST4Segment table (CO-PA)22PPRCTRPartner Profit Centernvarchar100
143GLTPCProfit Center Accounting9PPRCTRPartner Profit Centernvarchar100
TOPRepetitive Manufacturing
144COMPMOVEGoods Movement of Components239PPRCTRPartner Profit Centernvarchar100
TOPRevenues and Earnings
145AD01DLIDynamic items (DI)38PPRCTRPartner Profit Centernvarchar100
TOPShipping
146LIPSPOLIPS Reference Data Purchase Order25PPRCTRPartner Profit Centernvarchar100
147LIPSRFLIPS Reference Data28PPRCTRPartner Profit Centernvarchar100