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

53 columns | Print definition?ERP 6.0  | VAKEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RD_VBLPayroll Result: Supplementary Pension Public Sector37VAKEYVariable Key for Employer Tablenvarchar80
2T5FDSNPAVALTable des paramètres DSN4VAKEYClé variable - 70 octetsnvarchar700
3TNADROutput Control: do not use, will be deleted3VAKEYVariable keynvarchar340
TOPAssortment List
4WDLSOPOS outbound log: object with errors4VAKEYKey for POS outbound object errornvarchar400
TOPBasic Data for Certificates
5I000Conditions for certificate profile4VAKEYVariable key 100 bytesnvarchar1000
TOPBasic Functions
6KOND3Conditions: Campaign Determination - Data Part7VAKEYVariable key 100 bytesnvarchar1000
TOPBatches
7R000Condition table for derivation strategy R4VAKEYVariable key 100 bytesnvarchar1000
TOPChargeback
8WB2_D_BUSVOLBASERebates: Business Volume Base for Condition Contract5VAKEYVariable key 100 bytesnvarchar1000
9WB2_D_BVB_SETTLCCS: Snapshot Business Volume Base Data used for settlement7VAKEYVariable key 100 bytesnvarchar1000
TOPConditions
10A000Condition Table for Pricing $4VAKEYVariable key 100 bytesnvarchar1000
11B000$ Sample Table for output control4VAKEYVariable key 100 bytesnvarchar1000
12C000Condition Table for Acct.Determination: $5VAKEYVariable key 100 bytesnvarchar1000
13CND_MEM_INITIALConditions: Buffer for Initial Upload6VAKEYVariable key 100 bytesnvarchar1000
14D000Condition Table for Material Determination $4VAKEYVariable key 100 bytesnvarchar1000
15E000Condition Table for Rebate $4VAKEYVariable key 50 bytesnvarchar500
16F000Condition Table for Secondary Indexes $3VAKEYVariable keynvarchar1000
17G000Condition Table for Material Listing/Exclusion $4VAKEYVariable key 100 bytesnvarchar1000
18H000Condition Table for Batch Search Strategy $4VAKEYVariable key 100 bytesnvarchar1000
19KONDNConditions: Free goods - Data section19VAKEYVariable key 100 bytesnvarchar1000
20KONHConditions (Header)9VAKEYVariable key 100 bytesnvarchar1000
21MASTER_3000Condition Table for Campaign Determination4VAKEYVariable key 100 bytesnvarchar1000
22N000Condition table for free goods determination4VAKEYVariable key 100 bytesnvarchar1000
23VBOXSD Document: Billing Document: Rebate Index4VAKEYVariable key 50 bytesnvarchar500
TOPConstruction Equipment Management
24J_3GJ000Condition Table for Price List Determination4VAKEYVariable key 100 bytesnvarchar1000
25J_3GPRLHDCEM Price Lists Condition Header9VAKEYVariable key 100 bytesnvarchar1000
TOPCost Center Accounting
26TKRSTRTransport Resource Prices9VAKEYVariable key 100 bytesnvarchar1000
TOPData Collection
27MCS0Reference Structure for Generating Info Structures8VAKEYVariable key 100 bytesnvarchar1000
28MCS1Model Structure for Info Structures with Initial VAKEY4VAKEYVariable key 100 bytesnvarchar1000
29MCS2Sample Structure for Structural Information - Info Structure3VAKEYVariable key 100 bytesnvarchar1000
TOPDistributor-Reseller-Management
30W000Condition Table for Rule Determination $4VAKEYVariable key 100 bytesnvarchar1000
TOPExtended Rebate
31S469Erweiterte Bonusabrechnung10VAKEYVariabele keycode 100 bytesnvarchar1000
TOPGermany
32T5D3RHR-DEH: Entry of External Data6VAKEYVariable Key 70 Bytesnvarchar700
TOPMaster data
33P000Conditions for Packing Object4VAKEYVariable key 100 bytesnvarchar1000
TOPOutput Determination
34NACHDetailed output data9VAKEYVariable key 100 bytesnvarchar1000
TOPOverhead Cost Orders
35TKZUTRTransport Overhead Records9VAKEYVariable key 100 bytesnvarchar1000
TOPPeriodical Sales and Distribution
36JLTPST2IS-M/SD: Main Data for Batch Input Postal Charges4VAKEYVariable key 100 bytesnvarchar1000
TOPPosition Management
37KONHMPortfolio Determination - Data Part11VAKEYVariable key 100 bytesnvarchar1000
38M000Master Table for Portfolio Determination4VAKEYVariable key 100 bytesnvarchar1000
TOPPricing
39PRCM_TABL_000Reference Table for Condition Tables (A000)3VAKEYVariable Key Part of a Condition Tablenvarchar2000
TOPProduct Safety
40V000EHS: Conditions for Variant Matching4VAKEYVariable key 100 bytesnvarchar1000
TOPPublic Sector
41PA0051HR Master Record Infotype 0051 (VBL/SPI Data)48VAKEYVariable Key for Employer Tablenvarchar80
42PDPBSZVADMAdministration Table for ZVE-PBS Notification Procedure14VAKEYVariable Key for Employer Tablenvarchar80
43PDPBSZVSUMTotals Record (Record Type 90), SPI8VAKEYVariable Key for Employer Tablenvarchar80
44PDPBSZV_PA0051ZVMP Employer to Be Overridden in IT0051 (Before ZVMP)7VAKEYVariable Key for Employer Tablenvarchar80
45T5DPBSZVAGEmployer-Specific Settings4VAKEYVariable Key for Employer Tablenvarchar80
46T5DPBSZVAGEEmployer-Specific Settings: Entity4VAKEYVariable Key for Employer Tablenvarchar80
47T5DPBSZVAGTEmployer-Specific Settings: Text5VAKEYVariable Key for Employer Tablenvarchar80
TOPPurchase Orders
48WINDDocument Index: Conditions for Automatic Document Adjustment13VAKEYVariable key 100 bytesnvarchar1000
TOPRemaining Beverage - Obsolete Objects
49/BEV1/RBWEItemized Proof Rebate Settlement15VAKEYVariable key 100 bytesnvarchar1000
TOPRetail Enterprise Services
50WESD_OUTB_STATUSStatus Table for Outbound Services4VAKEYVariable Keynvarchar500
TOPReuse Services for Country Development
51T596MData Personnel Area Reporting6VAKEYVariable Key 70 Bytesnvarchar700
52T596NVSummary Personnel Area Reporting6VAKEYVariable Key 70 Bytesnvarchar700
TOPService Station Retailing
53Q000Condition Table for Acct.Determination: $4VAKEYVariable key 100 bytesnvarchar1000