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  | PLSCH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPLogistics Basic Data
1WCMPSDDetails for Category Management Step9PLSCHPlanning Stepnvarchar100
TOPMerchandise and Assortment Planning
2TWISPC_ANREIParameter for Updating Fields in Info Structures3PLSCHPlanning Stepnvarchar100
3TWISPC_CUARetail Planning: Customer-specific CUA Status and Title3PLSCHPlanning Stepnvarchar100
4TWISPC_DPLVARetail Planning: Manual Planning Variants3PLSCHPlanning Stepnvarchar100
5TWISPC_DPLVATRetail Planning: Texts for Manual Planning Variants4PLSCHPlanning Stepnvarchar100
6TWISPC_DPLVVRetail Planning: Default Parameters for Manual Plng Variants3PLSCHPlanning Stepnvarchar100
7TWISPC_FCODESRetail Planning: Customer-specific CUA Functions3PLSCHPlanning Stepnvarchar100
8TWISPC_INT_ALLOCInterface Parameters for "Allocation Table" Interface Cat.3PLSCHPlanning Stepnvarchar100
9TWISPC_INT_LISTGInterface Parameter for Interface Type "Listing"3PLSCHPlanning Stepnvarchar100
10TWISPC_INT_PROMOMAP: Planning Interface Category "Promotions"3PLSCHPlanning Stepnvarchar100
11TWISPC_KENNFRetail Planning: Key Figure Formula for Planning Steps3PLSCHPlanning Stepnvarchar100
12TWISPC_KENNFGRetail Planning: Formula Groups for Planning Steps3PLSCHPlanning Stepnvarchar100
13TWISPC_KENNFGTRetail Planning: Formula Groups for Planning Step Texts4PLSCHPlanning Stepnvarchar100
14TWISPC_KENNFZRetail Planning: Formula Lines for Arithmetic Formulas3PLSCHPlanning Stepnvarchar100
15TWISPC_KENNPARRetail Planning: Control Parameters for Key Figures3PLSCHPlanning Stepnvarchar100
16TWISPC_KENNZRetail Planning: Additional Key Figures3PLSCHPlanning Stepnvarchar100
17TWISPC_MASCHPLRetail Planning: Automatic Planning3PLSCHPlanning Stepnvarchar100
18TWISPC_MASCHPLTText Tables for Automatic Planning4PLSCHPlanning Stepnvarchar100
19TWISPC_MDATTRMaster Data Attributes3PLSCHPlanning Stepnvarchar100
20TWISPC_MPLSCHReports/Tcodes for Planning Step Method Program/Transaction3PLSCHPlanning Stepnvarchar100
21TWISPC_PLINTMAP: Planning Interfaces - General Definitions3PLSCHPlanning Stepnvarchar100
22TWISPC_PLINTTText Tables for Planning Interfaces4PLSCHPlanning Stepnvarchar100
23TWISPC_PLSCHRetail Planning: Planning Step3PLSCHPlanning Stepnvarchar100
24TWISPC_PLSCHTRetail Planning: Texts for Planning Step4PLSCHPlanning Stepnvarchar100
25TWISPC_PLSCH_BWBW Enhancements at Planning Step Level3PLSCHPlanning Stepnvarchar100
26TWISPC_PLSCH_WRetail Planning: Plng Step for Add. Table for Retail Applic.3PLSCHPlanning Stepnvarchar100
27TWISPC_REQHEADMAP: Customizing for External Applications4PLSCHPlanning Stepnvarchar100
28TWISPC_VRSIORetail Planning: Add-Ons to the LIS Plan Version5PLSCHPlanning Stepnvarchar100
29TWISPC_ZBRINTAssignment of Break-Downs to Interfaces3PLSCHPlanning Stepnvarchar100
30TWISPC_ZINTPLAssignment of Interfaces to Planning Layouts3PLSCHPlanning Stepnvarchar100
31TWISPC_ZKENNRetail Planning: Assignment of Key Figs to the Planning Step3PLSCHPlanning Stepnvarchar100
32TWISPC_ZKENN_WRetail Planning: Assign. KeyFig/PlStep (Add. Retail Table)3PLSCHPlanning Stepnvarchar100
33TWISPC_ZKNZINTAssignment of Key Figures to Interfaces3PLSCHPlanning Stepnvarchar100
34TWISPC_ZMERINTAssignment of Characteristics to Interfaces3PLSCHPlanning Stepnvarchar100
35TWISPC_ZMERKRetail Planning: Assignment of Characteristics to Plng Step3PLSCHPlanning Stepnvarchar100
36TWISPC_ZMERK_WRetail Planning: Assign. Character/PlStep (Add.Retail Table)3PLSCHPlanning Stepnvarchar100
37TWISPC_ZPSPLRetail Planning: Assign. Planning Layouts to Plan Steps3PLSCHPlanning Stepnvarchar100
38TWISPS_NOALLOC1Parameters for Allocation Tables Generated in MAP8PLSCHPlanning Stepnvarchar100
39TWISPS_NOLISTG1Parameters for Allocation Tables Generated in MAP8PLSCHPlanning Stepnvarchar100
40TWISPS_NOPROMO1Parameters for Promotions Created in MAP12PLSCHPlanning Stepnvarchar100