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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

91 columns | Print definition?ERP 6.0  | ETYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1AUAASettlement Document: Receiver Segment31ETYPEEquity typenvarchar30
2BSEGAccounting Document Segment232ETYPEEquity typenvarchar30
3BSSEGAccounting Document Segment221ETYPEEquity typenvarchar30
4CNV_20305_CBUKRSSAP LT: Backup table of CEPC_BUKRS8ETYPEEquity typenvarchar30
5CNV_20305_CEPCSAP LT: Backup table of CEPC39ETYPEEquity typenvarchar30
6FUDT_VDOCBSEGVerification Document Item with Additional Info221ETYPEEquity typenvarchar30
7FUDT_VDOCBSEGEVVerification Document Item in the Entry View221ETYPEEquity typenvarchar30
8FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)221ETYPEEquity typenvarchar30
9GLPOS_C_CTFI Document: Entry View108ETYPEEquity typenvarchar30
10GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items108ETYPEEquity typenvarchar30
11GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items108ETYPEEquity typenvarchar30
12GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items108ETYPEEquity typenvarchar30
13GLPOS_N_CTNew General Ledger: Line Item with Currency Type110ETYPEEquity typenvarchar30
14GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type110ETYPEEquity typenvarchar30
15P2HR_SISI properties Croatia9ETYPEEmployee typenvarchar10
16P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)6ETYPEXDEC: Entry Typenvarchar20
17P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)6ETYPEXDEC: Entry Typenvarchar20
18T5GPBS41Vehicle classes for car mileage3ETYPEEngine type to derive vehicle classnvarchar10
19T7HRJOPPD_CUST1Rules definition extension for JOPPD fields5ETYPEEmployee typenvarchar10
TOPAccounting Interface
20GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)215ETYPEEquity typenvarchar30
21GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)215ETYPEEquity typenvarchar30
TOPAustria
22T5A1DSI Characteristics for Contribution Groups3ETYPECharacteristic Type for Contribution Groupsnvarchar20
23T5A1ECharacteristics for Contribution Groups1ETYPECharacteristic Type for Contribution Groupsnvarchar20
24T5A1FValues for Characteristic Types of Contribution Groups1ETYPECharacteristic Type for Contribution Groupsnvarchar20
25T5A1GTexts for Characteristic Types of Contribution Groups2ETYPECharacteristic Type for Contribution Groupsnvarchar20
26T5A1HTexts for Values of Characteristics for Contribution Groups2ETYPECharacteristic Type for Contribution Groupsnvarchar20
TOPClinical System
27N1MEEVENTIS-H*MED: Medication, Medication Event52ETYPEMedication: Event Typenvarchar10
TOPConstruction Equipment Management
28J_3GBELKDocument File - Header Data97ETYPEEquity typenvarchar30
29J_3GBELPDocument Data - Item Data130ETYPEEquity typenvarchar30
TOPContract Accounts Receivable and Payable
30IST_EVALEvaluate Reconnection Proposals2ETYPECategory for Valuating Unlocking Proposalsnvarchar10
TOPControlling
31CSKSCost Center Master Data69ETYPEEquity typenvarchar30
TOPCross-Application Components
32AAUUFKOrder master data95ETYPEEquity typenvarchar30
TOPDocument Builder
33/IPRO/TELMLISTWhere-used table for document elements6ETYPEElement Typenvarchar10
TOPElectronic Bank Statement
34FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)51ETYPEEquity typenvarchar30
35FEB_ACTAcct Assignment Templates51ETYPEEquity typenvarchar30
TOPEmpties Management When Extension EA-CP Is Active
36/BEV1/NEINVITMEmpties Quantities and Values from Invoice Receipt25ETYPEEmpties Categorynvarchar10
TOPFinancial Accounting
37EBSEGDoc.Segment of Fin.Accntng External Documents74ETYPEEquity typenvarchar30
38KMZEIFI: Account Assignment Model Item Information52ETYPEEquity typenvarchar30
39KOMUAccount Assignment Templates for G/L Account Items52ETYPEEquity typenvarchar30
40VBSEGSDocument Segment for Document Parking - G/L Account Database82ETYPEEquity typenvarchar30
TOPFunds Management-Specific Postings
41FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years81ETYPEEquity typenvarchar30
42PSOSEGSRecurring Request Document Segment, G/L Accounts80ETYPEEquity typenvarchar30
TOPGL Account Posting
43TCJ_POSITIONSCash Journal Document Items58ETYPEEquity typenvarchar30
TOPJoint Venture und Production Sharing Accounting
44T8JEInvestment Type3ETYPEEquity typenvarchar30
45T8JETInvestment Type Description4ETYPEEquity typenvarchar30
46T8JGValid Investment Group4ETYPEEquity typenvarchar30
47T8PSA_ADJUST_VOLAdjustment Volumes6ETYPEEquity typenvarchar30
48T8PSA_ARML_PRICEPSA Manual WAP for Arms Length Sales Transactions6ETYPEEquity typenvarchar30
49T8PSA_INPUTVolume Input10ETYPEEquity typenvarchar30
50T8PSA_LIFT_VOLLifting Volumes6ETYPEEquity typenvarchar30
51T8PSA_PAProduct Assignment6ETYPEEquity typenvarchar30
52T8PSA_PRICE_VOLPrices for Volumes6ETYPEEquity typenvarchar30
53T8PSA_PROD_VOLProduction Volumes6ETYPEEquity typenvarchar30
54T8PSA_TERM_PSCAssignment PSC to Terminal6ETYPEEquity typenvarchar30
55T8PSCINPUTPSC Production Input8ETYPEEquity typenvarchar30
56T8PSCPAProduction Sharing Contract Product Assignment6ETYPEEquity typenvarchar30
57T8PSCVPSC Venture Data5ETYPEEquity typenvarchar30
58T8PSC_ADJUSTPSC Adjustment Data6ETYPEEquity typenvarchar30
59T8PSC_LIFTPSC Lifting Data6ETYPEEquity typenvarchar30
60T8PSC_PRICEPSC Production Prices6ETYPEEquity typenvarchar30
61T8PSC_PRODPSC Production Data6ETYPEEquity typenvarchar30
TOPLine Maintenance
62/ISDFPS/CLMEERRCustomizing Tab. - Graph. Avail. Check with Error Ty. Assgmt5ETYPEError Typenvarchar10
TOPOperative Structures
63PROJProject definition79ETYPEEquity typenvarchar30
64PRPSWBS (Work Breakdown Structure) Element Master Data105ETYPEEquity typenvarchar30
TOPOverhead Cost Controlling
65CMDT_CCGeneric Master Data: Cost Center Enhancements33ETYPEEquity typenvarchar30
TOPOverhead Cost Orders
66AUFKOrder master data98ETYPEEquity typenvarchar30
TOPPayroll
67T5H2HText table for T5H2G2ETYPEProcedure typenvarchar10
TOPPersonnel Administration
68T5H2GTax settlement code1ETYPEProcedure typenvarchar10
TOPPersonnel Management
69PA0564HR Master Record: Infotype 056440ETYPEEmployee typenvarchar10
70T7HR10Insurance institutions3ETYPEEmployee typenvarchar10
71T7HR1AInsurance calculation3ETYPEEmployee typenvarchar10
72T7HR20Tax Institution2ETYPEEmployee typenvarchar10
TOPProduction and Revenue Accounting
73OIU_ME_CNTNRGeneral measurement container9ETYPEEquity typenvarchar30
TOPProduction Orders
74AFVUDB structure of the user fields of the operation23ETYPEEquity typenvarchar30
TOPProfit Center Accounting
75CEPCProfit Center Master Data Table39ETYPEEquity typenvarchar30
76CEPC_BUKRSAssignment of Profit Centers to a Company Code7ETYPEEquity typenvarchar30
77CMDT_PC_BUKRSGeneric Master Record: Company Code Assign. for Profit Cent.9ETYPEEquity typenvarchar30
TOPProject Risk Management for Contractors
78/SAPPCE/JVA_PROFProfile for JVA master data maintenance8ETYPEEquity typenvarchar30
TOPPublic Sector
79T5R0P_PSPlant section/Singapore for PS Employees9ETYPEType of companynvarchar20
TOPRemaining Beverage - Obsolete Objects
80/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1223ETYPEEquity typenvarchar30
TOPSimulation
81VSAFVU_CNVersion: User fields in operation in order24ETYPEEquity typenvarchar30
82VSAUFK_CNVersion: Order master data99ETYPEEquity typenvarchar30
83VSPROJ_CNVersion: Project definition80ETYPEEquity typenvarchar30
84VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data106ETYPEEquity typenvarchar30
TOPSingapore
85T5R0PPlant section/Singapore8ETYPEType of companynvarchar20
TOPTemplates
86PROJSStandard project definition81ETYPEEquity typenvarchar30
87PRPSSStandard WBS Element (WBS element) - Master Data88ETYPEEquity typenvarchar30
TOPUSA
88T5UP2Establishment/stores for tip processing8ETYPEEstablishment typenvarchar10
TOPWithout Description
89RSTT_ERRORError Archive12ETYPEError Typenvarchar20
TOPWorkforce Management Core
90/SAPAPO/LRPSUBIDTable for Subscription of Concrete Subjects7ETYPEEvent Category for WFM Objectsnvarchar10
91/SAPAPO/LRPSUBTYTable for Subscription of Generic Subjects7ETYPEEvent Category for WFM Objectsnvarchar10