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

95 columns | Print definition?ERP 6.0  | VALDT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CN/SBPSAP001Supplementary Table for a Condition Table18VALDTValue datenvarchar80
2/1CN/SBPSAP016Supplementary Table for a Condition Table18VALDTValue datenvarchar80
3/1CN/SBPSAP019Supplementary Table for a Condition Table18VALDTValue datenvarchar80
4/1CN/SBPSAP068Supplementary Table for a Condition Table18VALDTValue datenvarchar80
5/1CN/SBPSAP118Supplementary Table for a Condition Table18VALDTValue datenvarchar80
6/1CN/SPTSAP00001Supplementary Table for a Condition Table18VALDTValue datenvarchar80
7/1CN/SPTSAP00004Supplementary Table for a Condition Table18VALDTValue datenvarchar80
8/1CN/SPTSAP00005Supplementary Table for a Condition Table18VALDTValue datenvarchar80
9/1CN/SPTSAP00006Supplementary Table for a Condition Table18VALDTValue datenvarchar80
10/1CN/STXSAPD0001Supplementary Table for a Condition Table18VALDTValue datenvarchar80
11/1CN/STXSAPD0002Supplementary Table for a Condition Table18VALDTValue datenvarchar80
12/1CN/STXSAPD0003Supplementary Table for a Condition Table18VALDTValue datenvarchar80
13/1CN/STXSAPD0004Supplementary Table for a Condition Table18VALDTValue datenvarchar80
14/1CN/STXSAPD0201Supplementary Table for a Condition Table18VALDTValue datenvarchar80
15/1CN/STXSAPR0100Supplementary Table for a Condition Table18VALDTValue datenvarchar80
16/1CN/STXSAPR0103Supplementary Table for a Condition Table18VALDTValue datenvarchar80
17/1CN/STXSAPR0104Supplementary Table for a Condition Table18VALDTValue datenvarchar80
18/1CN/STXSAPR0105Supplementary Table for a Condition Table18VALDTValue datenvarchar80
19/1CN/STXSAPR0106Supplementary Table for a Condition Table18VALDTValue datenvarchar80
20/1CN/STXSAPR0107Supplementary Table for a Condition Table18VALDTValue datenvarchar80
21/1CN/STXSAPR0108Supplementary Table for a Condition Table18VALDTValue datenvarchar80
22/1CN/STXSAPR0110Supplementary Table for a Condition Table18VALDTValue datenvarchar80
23/1CN/STXSAPR0111Supplementary Table for a Condition Table18VALDTValue datenvarchar80
24/1CN/STXSAPR0112Supplementary Table for a Condition Table18VALDTValue datenvarchar80
25/1CN/STXSAPR0113Supplementary Table for a Condition Table18VALDTValue datenvarchar80
26/1CN/STXSAPR0120Supplementary Table for a Condition Table18VALDTValue datenvarchar80
27/1CN/STXSAPR0130Supplementary Table for a Condition Table18VALDTValue datenvarchar80
28/1CN/STXSAPR0131Supplementary Table for a Condition Table18VALDTValue datenvarchar80
29/1CN/STXSAPR0140Supplementary Table for a Condition Table18VALDTValue datenvarchar80
30/1CN/STXSAPR0201Supplementary Table for a Condition Table18VALDTValue datenvarchar80
31/1CN/STXSAPRBR01Supplementary Table for a Condition Table18VALDTValue datenvarchar80
32/1CN/STXSAPRBR02Supplementary Table for a Condition Table18VALDTValue datenvarchar80
33/1CN/STXSAPRBR03Supplementary Table for a Condition Table18VALDTValue datenvarchar80
34/1CN/STXSAPRBR10Supplementary Table for a Condition Table18VALDTValue datenvarchar80
35/1CN/STXSAPRBR11Supplementary Table for a Condition Table18VALDTValue datenvarchar80
36/1CN/STXSAPRBR12Supplementary Table for a Condition Table18VALDTValue datenvarchar80
37/1CN/STXSAPRBR20Supplementary Table for a Condition Table18VALDTValue datenvarchar80
38/1CN/STXSAPRBR21Supplementary Table for a Condition Table18VALDTValue datenvarchar80
39/1CN/STXSAPRIN03Supplementary Table for a Condition Table18VALDTValue datenvarchar80
40/1CN/STXSAPRIN04Supplementary Table for a Condition Table18VALDTValue datenvarchar80
41/1CN/STXSAPRIN06Supplementary Table for a Condition Table18VALDTValue datenvarchar80
42/1CN/STXSAPRIN07Supplementary Table for a Condition Table18VALDTValue datenvarchar80
43/1CN/STXSAPS0100Supplementary Table for a Condition Table18VALDTValue datenvarchar80
44/1CN/STXSAPS0101Supplementary Table for a Condition Table18VALDTValue datenvarchar80
45/1CN/STXSAPS0102Supplementary Table for a Condition Table18VALDTValue datenvarchar80
46/1CN/STXSAPW0201Supplementary Table for a Condition Table18VALDTValue datenvarchar80
47/1CN/STXSAPW0202Supplementary Table for a Condition Table18VALDTValue datenvarchar80
48/1CN/STXSAPX0100Supplementary Table for a Condition Table18VALDTValue datenvarchar80
49/1CN/STXSAPX0101Supplementary Table for a Condition Table18VALDTValue datenvarchar80
50/1CN/STXSAPX0102Supplementary Table for a Condition Table18VALDTValue datenvarchar80
51/1CN/STXSAPX0103Supplementary Table for a Condition Table18VALDTValue datenvarchar80
52/1CN/STXSAPX0104Supplementary Table for a Condition Table18VALDTValue datenvarchar80
53/1CN/STXSAPX0105Supplementary Table for a Condition Table18VALDTValue datenvarchar80
54/1CN/STXSAPX0106Supplementary Table for a Condition Table18VALDTValue datenvarchar80
55/1CN/STXSAPX0140Supplementary Table for a Condition Table18VALDTValue datenvarchar80
56/1CN/STXSAPX0141Supplementary Table for a Condition Table18VALDTValue datenvarchar80
57/1CN/STXSAPX0146Supplementary Table for a Condition Table18VALDTValue datenvarchar80
58/1CN/STXSAPX0147Supplementary Table for a Condition Table18VALDTValue datenvarchar80
59/1CN/STXSAPX0148Supplementary Table for a Condition Table18VALDTValue datenvarchar80
60/1CN/STXSAPXBR01Supplementary Table for a Condition Table18VALDTValue datenvarchar80
61/1CN/STXSAPXBR02Supplementary Table for a Condition Table18VALDTValue datenvarchar80
62/1CN/STXSAPXBR03Supplementary Table for a Condition Table18VALDTValue datenvarchar80
63/1CN/STXSAPXBR11Supplementary Table for a Condition Table18VALDTValue datenvarchar80
64P2KR_KRSP1Payroll Results Korea: Separation payroll II (Master Data)43VALDTValuation Date of Monthly Average Income for Separation Paynvarchar80
65CMACBPSTCHGStudent list to be transfered from HR infotype to BP5VALDTInitial Date for Business Partner Datanvarchar80
TOPAdvertising Management
66JHAGAIS-M/AM: Order-Publishing-Media Billing Dataset72VALDTFixed value datenvarchar80
67JHAISZIS-M/AM: Assignment Table of Advertisers for OPM Order28VALDTFixed value datenvarchar80
68JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header39VALDTFixed value datenvarchar80
TOPAgency Business Global Trade
69WBRKAgency business: Header67VALDTFixed Value Datenvarchar80
TOPBasic Functions
70FPLTBilling Plan: Dates32VALDTFixed value datenvarchar80
71FPLTPOBilling Plan: Dates32VALDTFixed value datenvarchar80
72VFPLTBilling Plan: Dates32VALDTFixed value datenvarchar80
TOPBilling
73VBRKBilling Document: Header Data28VALDTFixed value datenvarchar80
TOPCollectionsDisbursements
74VVSCTRANSFERPayment Plan: Business Partner Transfer6VALDTDate from Which Payment Plan Transfer Is Validnvarchar80
TOPConditions
75KONAAgreements31VALDTFixed value datenvarchar80
76KONPConditions (Item)43VALDTFixed value datenvarchar80
TOPContract Accounts Receivable and Payable
77DFKKCFNRClarification Cases from NOC Returns Lot14VALDTValidity Date of Changes (Direct Input)nvarchar80
78DFKKIP_GRPHPayment Specification: Payment Data (History)3VALDTDate to Which Payment Specification Was Validnvarchar80
79DFKKIP_ITMHPayment Specification: Deletions Not Yet Confirmed7VALDTDate to Which Payment Specification Was Validnvarchar80
80DFKKNRKNOC Returns Lot: Header Data21VALDTInitial Date for Business Partner Datanvarchar80
81DFKKNRPNOC Returns Lot: Item Data16VALDTInitial Date for Business Partner Datanvarchar80
TOPCross-Application Components
82VVBKDSales Document: Business Data16VALDTFixed value datenvarchar80
TOPKorea
83PA0538HR Master Record: Infotype 053854VALDTValuation Date of Monthly Average Income for Separation Paynvarchar80
TOPLogistics - General
84WBHDTrading Contract: Commercial Data16VALDTFixed value datenvarchar80
TOPMaintenance Orders
85/MRSS/D_SQM_KPQualification Catalog: Items8VALDTCan Be Used Untilnvarchar80
TOPOverhead Cost Controlling
86COBKCO Object: Document Header42VALDTSpecial Valuation Date for Cost Accountingnvarchar80
TOPPatient Accounting
87NVBRKIS-H: Billing document header data18VALDTFixed value datenvarchar80
TOPPeriodical Sales and Distribution
88JKKDSales Order: Business Data14VALDTFixed value datenvarchar80
89JLRKIS-M/SD: Settlement Header Data17VALDTFixed value datenvarchar80
TOPPersonnel Administration
90T582AInfotypes: Customer-Specific Settings11VALDTIndicator for access authorization (from/to date)nvarchar10
TOPPricing
91PRCM_SUPP_000Reference Table for Additional Information (KONP000)18VALDTValue datenvarchar80
TOPRemaining Beverage - Obsolete Objects
92/BEV1/RBKPCopy Table for KONP for Accrual (Field KBRUE)43VALDTFixed value datenvarchar80
TOPSales
93VBKDSales Document: Business Data16VALDTFixed value datenvarchar80
TOPSimulation
94VSFPLT_CNVersion: Billing schedule: Dates33VALDTFixed value datenvarchar80
95VSVBKD_CNVersion: Sales document - commercial data17VALDTFixed value datenvarchar80