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

32 columns | Print definition?ERP 6.0  | KALVG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdvertising Management
1TJH05IS-M/AM: Billing: Document Types20KALVGDoc.Proced.for Det.Pricing Proc.for Sales Agent Settlementnvarchar10
2TJH17IS-M/AM: OPM Item Type7KALVGDoc.Procedure Proposal (to Determine Pricing Procedure)nvarchar10
3TJHAKIS-M/AM: Order-Publishing-Media: Sales Document Type12KALVGDocument procedure (for determining pricing procedure)nvarchar10
4TJHK1IS-M/AM: Pricing Procedure: Determine for Pricing5KALVGDocument procedure (for determining pricing procedure)nvarchar10
5TJHK3Determine Pricing Procedure for Media Sales Agt Settlement4KALVGDocument procedure (for determining pricing procedure)nvarchar10
6TJHPSFIS-M/AM: Order Item Procedure Determination5KALVGDocument procedure (for determining pricing procedure)nvarchar10
TOPAgency Business Global Trade
7TMFKAgency Business: Billing Document Types21KALVGDocument schema for determining calculation schemanvarchar20
8TMKSFCalculation schema, vendor billing document3KALVGDocument schema for determining calculation schemanvarchar20
9TMKVAgency Business: Calculation Schema Transaction2KALVGDocument schema for determining calculation schemanvarchar20
10TMKVTAgency Business: Calculation Schema Transaction Texts3KALVGDocument schema for determining calculation schemanvarchar20
TOPAssortment Maintenance
11TWPAGeneral Parameters for Retail Control28KALVGDocument schema for determining calculation schemanvarchar10
TOPBasic Functions
12TVAKSales Document Types31KALVGDocument procedure (for determining pricing procedure)nvarchar10
13TVFKBilling: Document Types25KALVGDocument procedure (for determining pricing procedure)nvarchar10
14TVKVTPricing Procedures: Procedure: Texts3KALVGDocument procedure (for determining pricing procedure)nvarchar10
TOPConditions
15T683V_CMPCampaign Determination Procedure: Sales Doc. Determination5KALVGDocument procedure (for determining pricing procedure)nvarchar10
TOPCPE in SD
16CPEC_SD_FA_PROCCPE in SD: Determination of Procedure for Formula Assembly5KALVGDocument procedure (for determining pricing procedure)nvarchar10
TOPMaterial Maintenance
17T683VPricing Procedures: Determination in Sales Docs.5KALVGDocument procedure (for determining pricing procedure)nvarchar10
18TVKVPricing Procedures: Transaction2KALVGDocument procedure (for determining pricing procedure)nvarchar10
TOPPatient Accounting
19TN21IS-H: Billing Types5KALVGIS-H: Doc.Pricing Proc. (Det. Pricing Procedure Pat.Billing)nvarchar10
TOPPeriodical Sales and Distribution
20TJAKIS-M/SD: Sales Document Type18KALVGDocument procedure (for determining pricing procedure)nvarchar10
21TJFKIS-M/SD: Billing Document Types24KALVGDocument procedure (for determining pricing procedure)nvarchar10
22TJK05Pricing Procedures: Determination in Sales Documents5KALVGDocument procedure (for determining pricing procedure)nvarchar10
TOPProduct Catalog
23WWMIProduct catalog10KALVGDocument schema for determining a calculation schemanvarchar10
TOPRetail Pricing
24TWRPGPGeneral Parameters for Pricing13KALVGDocument schema for determining calculation schemanvarchar10
TOPService Station Retailing
25OIRCPRUPDSSR Pricing - Update type definition2KALVGSSR Pricing - Margins procedure assigned to business typenvarchar10
26OIRCT683VSSR Pricing - Margin procedure determination2KALVGSSR Pricing - Margins procedure assigned to business typenvarchar10
27OIRCT685SSR Pricing - Condition type definition2KALVGSSR Pricing - Margins procedure assigned to business typenvarchar10
28OIRCT685_HSSR Pricing - Condition type definition2KALVGSSR Pricing - Margins procedure assigned to business typenvarchar10
29OIRCTVKVSSR Pricing - Business type Margin Procedure2KALVGSSR Pricing - Margins procedure assigned to business typenvarchar10
30OIRCTVKVTSSR Pricing - Business type Margin Procedure: Texts3KALVGSSR Pricing - Margins procedure assigned to business typenvarchar10
31OIRECCTYPSSR PC: Company code / credit card types29KALVGDocument procedure (for determining pricing procedure)nvarchar10
TOPTraders and Schedulers Workbench
32OIRARNBTRetail Network Business Types3KALVGSSR Pricing - Margins procedure assigned to business typenvarchar10