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

40 columns | Print definition?ERP 6.0  | ID_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CVP_BEGRUAuthorization Group indicating blocked master data2ID_TYPECustomer/vendor master data ID TYPEnvarchar10
2CVP_C_PARALLELParallel processing settings2ID_TYPECustomer/vendor master data ID TYPEnvarchar10
3CVP_EOPAPPDefine / Store Application Names for EoP check2ID_TYPECustomer/vendor master data ID TYPEnvarchar10
4CVP_EOPAPPTDefine / Store Application Name descriptions for EoP check2ID_TYPECustomer/vendor master data ID TYPEnvarchar10
5CVP_EOPARVDefine / Store Application Rule Variants for EoP Check2ID_TYPECustomer/vendor master data ID TYPEnvarchar10
6CVP_EOPARVTDefine / Store Application Rule Variants for EoP2ID_TYPECustomer/vendor master data ID TYPEnvarchar10
7CVP_EOPCLASSApplication Classes Registered for EoP Check2ID_TYPECustomer/vendor master data ID TYPEnvarchar10
8CVP_EOPCLASSPApplication Classes Registered for EoP Check-Priorities2ID_TYPECustomer/vendor master data ID TYPEnvarchar10
9CVP_EORTEoRT Details of Customer/Vendor/Contact for each application3ID_TYPECustomer/vendor master data ID TYPEnvarchar10
10CVP_NXTCHKMaintain the default Next Check2ID_TYPECustomer/vendor master data ID TYPEnvarchar10
11CVP_SD_ADRNRAddress Details of Cust./One-Time Cust. for SD Application3ID_TYPECustomer/vendor master data ID TYPEnvarchar10
12CVP_SD_SORTSoRT Details of Customer/Vendor/Contact for SD Application3ID_TYPECustomer/vendor master data ID TYPEnvarchar10
13CVP_SHLP_FILTERCustomizing table for filtering search helps3ID_TYPECustomer/vendor master data ID TYPEnvarchar10
14CVP_SORTSoRT Details of Customer/Vendor/Contact for each application3ID_TYPECustomer/vendor master data ID TYPEnvarchar10
15CVP_UNBLK_REQSTCustomer/Vendors unblocking requests3ID_TYPECustomer/vendor master data ID TYPEnvarchar10
16FIDOC_EOPDocument extract for EOP check2ID_TYPECustomer/vendor master data ID TYPEnvarchar10
17FMEOP_CPD_CHECKEOP Check for PSM3ID_TYPECustomer/vendor master data ID TYPEnvarchar10
18PIQDB_NL_DUOILOGDUO Incoming Message Error Log Table6ID_TYPEIdentification Typenvarchar60
19SHLP_FILTER_CVCustomizing Table for Filtering Search Helps3ID_TYPEAccount Typenvarchar10
20SRAL_TRACE_CFGSRAL Trace Configuration2ID_TYPESRAL Trace Id Type ( 1 Username / 2 Terminal ID )nvarchar10
21T7PIQSTBPIDSYNBP Student Identification number synchronization2ID_TYPEIdentification Typenvarchar60
TOPBusiness Partner
22TIVBPGRPCCBusiness Partner Grouping per Company Code3ID_TYPEBusiness partner categorynvarchar10
TOPCentral Part of Product Master
23COMC_ALTID_CNFLDSpecify Context Data for ID Types2ID_TYPEID Type for Alternative IDsnvarchar160
24COMC_ALTID_FIELDData for Alternative Product ID Fields2ID_TYPEID Type for Alternative IDsnvarchar160
25COMC_ALTID_PR_ODSequence of Alternative IDs in a Profile4ID_TYPEID Type for Alternative IDsnvarchar160
26COMC_ALTID_TP_ODSequence of Alternative IDs4ID_TYPEID Type for Alternative IDsnvarchar160
27COMC_ALTID_TP_SCShort Form for Alternative ID Types in PC UI Quick Search2ID_TYPEID Type for Alternative IDsnvarchar160
28COMC_ALTID_TYPEControl Data for Alternative Product IDs2ID_TYPEID Type for Alternative IDsnvarchar160
29COMC_ALTID_TYPETDescription of Alternative ID Type2ID_TYPEID Type for Alternative IDsnvarchar160
30COMM_PRCATProduct Category8ID_TYPEID Type for Alternative IDsnvarchar160
31COMM_PRCATHProduct Category: History9ID_TYPEID Type for Alternative IDsnvarchar160
32COMS_ALTID_VALTable for Alternative ID1ID_TYPEID Type for Alternative IDsnvarchar160
TOPLocalization
33J_3R_CAUTHOutput control for Goods Withholding Authorization5ID_TYPEIdentification Typenvarchar60
TOPMaterials Management
34J_5KFH_CAUTHOutput control for Goods Withholding Authorization5ID_TYPEIdentification Type Used for Authorization Formnvarchar60
35J_5KMH_CAUTHOutput control for Goods Withholding Authorization5ID_TYPEIdentification Type Used for Authorization Formnvarchar60
TOPPatient Accounting
36NEHC_PATIS-H: Health Insurance Card (Patient Data)44ID_TYPEnvarchar20
TOPPublic Sector Contract Accounts Receivable and Payable
37DFMCA_BRF650BRF: Business Partner Reading7ID_TYPEBRF: Expressionnvarchar200
38DFMCA_BRF890BRF: Business Partner Determination from Form8ID_TYPEBRF: Expressionnvarchar200
TOPUse Subcomponents
39SOCSSAPoffice: table for storage of an Office ID (SAPcomm)5ID_TYPESend Externally: ID: Received or Sentnvarchar10
40SOCXSAPoffice: table for storing SAPcomm IDs5ID_TYPESend Externally: ID: Received or Sentnvarchar10