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

67 columns | Print definition?ERP 6.0  | GUELTIGAB

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P01E2_UMMELDUNGELStAM Procedure: Table of Change of Registration Data5GUELTIGABELStAM: Key Date of Validity of Change Listnvarchar80
TOPAdvertising Management
2JHTTBEDIS-M/AM: OPM - Rate Requirements6GUELTIGABIS-M: "Valid From" Datenvarchar80
3JJTKSIS-M/AM: Business Partner Hierarchy5GUELTIGABValid-From Datenvarchar80
4JJTVAIncl/Exclusive Sales Agt Requirements for Entire Sales Area6GUELTIGABIS-M: "Valid From" Datenvarchar80
5JJTVBIS-M/AM: Requirement in Media Sales Agent Contract4GUELTIGABIS-M: "Valid From" Datenvarchar80
TOPBasic Data
6QMTBInspection method master record5GUELTIGABValid-From Datenvarchar80
7QMTTInspection Method Texts6GUELTIGABValid-From Datenvarchar80
8QPACInspection catalog codes for selected sets8GUELTIGABValid-From Datenvarchar80
9QPMKInspection characteristic master6GUELTIGABValid-From Datenvarchar80
10QPMTMaster Inspection Characteristics Texts6GUELTIGABValid-From Datenvarchar80
11QPMZAssignment table - insp. methods/master insp. characteristic9GUELTIGABValid-From Datenvarchar80
TOPBasic Data for Certificates
12QCVKCertificate profile header6GUELTIGABField Not Used Field Reserved for SAPnvarchar80
TOPCatalog
13QPCDInspection catalog codes6GUELTIGABValid-From Datenvarchar80
14QPCTCode texts7GUELTIGABValid-From Datenvarchar80
TOPInspection Planning
15PLMKInspection plan characteristics8GUELTIGABValid-From Datenvarchar80
16PLMWMAPL-Dependent Charac. Specifications (Inspection Plan)9GUELTIGABValid-From Datenvarchar80
TOPMaster Data
17JSTAENDERIS-M/SD: Change Number for Structure Maintenance3GUELTIGABIS-M: Date from Which Change Number is Validnvarchar80
18JSTALIASIS-M: Alias Table for Streets32GUELTIGABValid-From Datenvarchar80
19JSTANDLOGIS-M/SD: Log for Changes to JSTAENDER9GUELTIGABIS-M: Date from Which Change Number is Validnvarchar80
20JSTBEZBEZIS-M/SD: Assgmt Table for Carrier Route-Carrier Route Assgmt5GUELTIGABValid-From Datenvarchar80
21JSTCOUNTYIS-M: Counties or Administrative Districts from USPS (USA)5GUELTIGABValid-From Datenvarchar80
22JSTGEOBEZIS-M/SD: Assignment of Carrier Routes to Geographical Units5GUELTIGABValid-From Datenvarchar80
23JSTGEOHIEIS-M/SD: Geographical Hierarchy6GUELTIGABValid-From Datenvarchar80
24JSTGEOORGIS-M/SD: Assignment of Geographical to Organizational Units5GUELTIGABValid-From Datenvarchar80
25JSTGEOPSTIS-M/SD: Assignments of Geographical to Postal Units7GUELTIGABValid-From Datenvarchar80
26JSTKGSPROIS-M/SD: District Municipality File18GUELTIGABValid-From Datenvarchar80
27JSTKGSUPDAIS-M/SD: Table for Upgrade of Table JSTKGSPRO22GUELTIGABValid-From Datenvarchar80
28JSTLAUFIS-M/SD: Round Sequence8GUELTIGABValid-From Datenvarchar80
29JSTORGHIEIS-M/SD: Organizational Plan Hierarchy5GUELTIGABValid-From Datenvarchar80
30JSTORTPROIS-M/SD: City File (Post)24GUELTIGABValid-From Datenvarchar80
31JSTORTUPDAIS-M/SD: Table for Upgrade of Table JSTORTPRO27GUELTIGABValid-From Datenvarchar80
32JSTOTLPROIS-M: City District File19GUELTIGABValid-From Datenvarchar80
33JSTOTLUPDAIS-M/SD: Table for Upgrade of Table JSTOTLPRO23GUELTIGABValid-From Datenvarchar80
34JSTPLOUPDAIS-M/SD: Table for Upgrade of Table JSTPLZORT21GUELTIGABValid-From Datenvarchar80
35JSTPLZORTIS-M/SD: Assignment of Postal Codes to Cities16GUELTIGABValid-From Datenvarchar80
36JSTPLZPROIS-M: Postal Codes22GUELTIGABValid-From Datenvarchar80
37JSTPLZUPDAIS-M/SD: Table for Upgrade of Table JSTPLZPRO26GUELTIGABValid-From Datenvarchar80
38JSTPOFPROIS-M/SD: PO Box Rack File23GUELTIGABValid-From Datenvarchar80
39JSTPOFUPDAIS-M/SD: Table for Upgrade of Table JSTPOFPRO29GUELTIGABValid-From Datenvarchar80
40JSTROUPVAIS-M/SD: Truck Route-Publication/Edition Assignment8GUELTIGABValid-From Datenvarchar80
41JSTSTRPROIS-M/SD: Street File (Post)33GUELTIGABValid-From Datenvarchar80
42JSTSTRUPDAIS-M/SD: Table for Upgrading Table JSTSTRPRO35GUELTIGABValid-From Datenvarchar80
43JST_KGS_CONSIS-M: Table for DMK Consolidation23GUELTIGABValid-From Datenvarchar80
44JST_ORT_CONSIS-M: Table for City Consolidation29GUELTIGABValid-From Datenvarchar80
45JST_OTL_CONSIS-M: Table for City District Consolidation27GUELTIGABValid-From Datenvarchar80
46JST_PLZ_CONSIS-M: Table for Postal Code Consolidation27GUELTIGABValid-From Datenvarchar80
47JST_POF_CONSIS-M: Table for PO Box Consolidation32GUELTIGABValid-From Datenvarchar80
48JST_STR_CONSIS-M: Table for Street Consolidation37GUELTIGABValid-From Datenvarchar80
TOPPeriodical Sales and Distribution
49JRTABLDBARIS-M/SD: Unloading Viability Set4GUELTIGABValid-From Datenvarchar80
50JRTABLRGLIS-M/SD: Unloading Rule (no longer used)13GUELTIGABValid-From Datenvarchar80
51JRTABLRGLAIS-M/SD: Unloading Rule for Unl.Point (Up to 5 Truck Routes)4GUELTIGABValid-From Datenvarchar80
52JRTABLRGLBIS-M: Unloading Rule for Carrier Route (Up to 6 Unl.Pts)4GUELTIGABValid-From Datenvarchar80
53JRTROUBEAIS-M/SD: Truck Route Unloading Point Sequence5GUELTIGABValid-From Datenvarchar80
54JRTROUHIEIS-M/SD: Truck Route Hierarchy6GUELTIGABValid-From Datenvarchar80
55JVTBEZGPIS-M/SD: Delivery Round - Business Partner8GUELTIGABValid-From Datenvarchar80
56JVTLIEFBARIS-M/SD: Delivery/Home Delivery/Pickup Viability Sets3GUELTIGABValid-From Datenvarchar80
57JVTPSTFEHLIS-M/SD: Postal Units not Delivered6GUELTIGABValid-From Datenvarchar80
TOPQuality Inspection
58QALSInspection lot record89GUELTIGABKey Date for Selecting Records or Changing Task Listsnvarchar80
TOPSample Management
59QPRVKSample-drawing procedure4GUELTIGABValid-From Datenvarchar80
TOPSAP Media
60J_1SBOTPROIS-M/SD CH/S: CH Carrier Data8GUELTIGABIS-M: CH/S: Validity Datenvarchar80
61J_1SSTRKUNIS-M/SD CH/S: Assign Street Data for Individual Customers40GUELTIGABValid-From Datenvarchar80
62J_1SSUPBESTANDIS-M/SD CH: Temporary Table for Postal Data Upgrade in DSet45GUELTIGABValid-From Datenvarchar80
TOPTax
63P01E2_ANMELDUNGELStAM Procedure: Table of Registration Data5GUELTIGABELStAM: Key Date of Validity of Change Listnvarchar80
64P01E2_ELSTAMELStAM Procedure: Table of Change Lists4GUELTIGABELStAM: Key Date of Validity of Change Listnvarchar80
65P01T_ELSTAMETStmt: ELStAM (as of 2012)6GUELTIGABELStAM: Key Date of Validity of Change Listnvarchar80
TOPTransaction Manager
66AT200Rules for Determining a Tax Indicator2GUELTIGABValid Fromnvarchar80
67AT210Rules for Determining a Taxes for CFM postings2GUELTIGABValid Fromnvarchar80