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

48 columns | Print definition?ERP 6.0  | PLSZN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPLogistics Basic Data
1WCMPCategory Management: Project8PLSZNPlanning Scenarionvarchar100
TOPMerchandise and Assortment Planning
2TWISPC_ANREIParameter for Updating Fields in Info Structures2PLSZNPlanning scenario for enhancementnvarchar100
3TWISPC_BW_TIMEAssignment of Infocubes to Time Field in Planning Scenario2PLSZNPlanning Scenarionvarchar100
4TWISPC_CUARetail Planning: Customer-specific CUA Status and Title2PLSZNPlanning Scenarionvarchar100
5TWISPC_DPLVARetail Planning: Manual Planning Variants2PLSZNPlanning Scenarionvarchar100
6TWISPC_DPLVATRetail Planning: Texts for Manual Planning Variants3PLSZNPlanning Scenarionvarchar100
7TWISPC_DPLVVRetail Planning: Default Parameters for Manual Plng Variants2PLSZNPlanning Scenarionvarchar100
8TWISPC_FCODESRetail Planning: Customer-specific CUA Functions2PLSZNPlanning Scenarionvarchar100
9TWISPC_INT_ALLOCInterface Parameters for "Allocation Table" Interface Cat.2PLSZNPlanning Scenarionvarchar100
10TWISPC_INT_LISTGInterface Parameter for Interface Type "Listing"2PLSZNPlanning Scenarionvarchar100
11TWISPC_INT_PROMOMAP: Planning Interface Category "Promotions"2PLSZNPlanning Scenarionvarchar100
12TWISPC_KENNFRetail Planning: Key Figure Formula for Planning Steps2PLSZNPlanning Scenarionvarchar100
13TWISPC_KENNFGRetail Planning: Formula Groups for Planning Steps2PLSZNPlanning Scenarionvarchar100
14TWISPC_KENNFGTRetail Planning: Formula Groups for Planning Step Texts3PLSZNPlanning Scenarionvarchar100
15TWISPC_KENNFZRetail Planning: Formula Lines for Arithmetic Formulas2PLSZNPlanning Scenarionvarchar100
16TWISPC_KENNPARRetail Planning: Control Parameters for Key Figures2PLSZNPlanning Scenarionvarchar100
17TWISPC_KENNZRetail Planning: Additional Key Figures2PLSZNPlanning Scenarionvarchar100
18TWISPC_LEVELSRetail Planning: Meaning of Individual Planning Levels2PLSZNPlanning Scenarionvarchar100
19TWISPC_MASCHPLRetail Planning: Automatic Planning2PLSZNPlanning Scenarionvarchar100
20TWISPC_MASCHPLTText Tables for Automatic Planning3PLSZNPlanning Scenarionvarchar100
21TWISPC_MDATTRMaster Data Attributes2PLSZNPlanning Scenarionvarchar100
22TWISPC_MPLSCHReports/Tcodes for Planning Step Method Program/Transaction2PLSZNPlanning Scenarionvarchar100
23TWISPC_PLINTMAP: Planning Interfaces - General Definitions2PLSZNPlanning Scenarionvarchar100
24TWISPC_PLINTTText Tables for Planning Interfaces3PLSZNPlanning Scenarionvarchar100
25TWISPC_PLSCHRetail Planning: Planning Step2PLSZNPlanning Scenarionvarchar100
26TWISPC_PLSCHTRetail Planning: Texts for Planning Step3PLSZNPlanning Scenarionvarchar100
27TWISPC_PLSCH_BWBW Enhancements at Planning Step Level2PLSZNPlanning Scenarionvarchar100
28TWISPC_PLSCH_WRetail Planning: Plng Step for Add. Table for Retail Applic.2PLSZNPlanning Scenarionvarchar100
29TWISPC_PLSZNRetail Planning: Planning Scenario2PLSZNPlanning Scenarionvarchar100
30TWISPC_PLSZNTRetail Planning: Texts for Planning Scenario3PLSZNPlanning Scenarionvarchar100
31TWISPC_PLSZN_BWRetail Planning: Planning Scenario, BW Data Enhancement2PLSZNPlanning Scenarionvarchar100
32TWISPC_PLVERRetail Planning: Planning Step Links2PLSZNPlanning Scenarionvarchar100
33TWISPC_PLVERTText Table for Planning Step Links3PLSZNPlanning Scenarionvarchar100
34TWISPC_REQHEADMAP: Customizing for External Applications3PLSZNPlanning Scenarionvarchar100
35TWISPC_VRSIORetail Planning: Add-Ons to the LIS Plan Version4PLSZNPlanning Scenarionvarchar100
36TWISPC_ZBRINTAssignment of Break-Downs to Interfaces2PLSZNPlanning Scenarionvarchar100
37TWISPC_ZCUBEAssignment of Cube Fields to MAP2PLSZNPlanning Scenarionvarchar100
38TWISPC_ZINTPLAssignment of Interfaces to Planning Layouts2PLSZNPlanning Scenarionvarchar100
39TWISPC_ZKENNRetail Planning: Assignment of Key Figs to the Planning Step2PLSZNPlanning Scenarionvarchar100
40TWISPC_ZKENN_WRetail Planning: Assign. KeyFig/PlStep (Add. Retail Table)2PLSZNPlanning Scenarionvarchar100
41TWISPC_ZKNZINTAssignment of Key Figures to Interfaces2PLSZNPlanning Scenarionvarchar100
42TWISPC_ZMERINTAssignment of Characteristics to Interfaces2PLSZNPlanning Scenarionvarchar100
43TWISPC_ZMERKRetail Planning: Assignment of Characteristics to Plng Step2PLSZNPlanning Scenarionvarchar100
44TWISPC_ZMERK_WRetail Planning: Assign. Character/PlStep (Add.Retail Table)2PLSZNPlanning Scenarionvarchar100
45TWISPC_ZPSPLRetail Planning: Assign. Planning Layouts to Plan Steps2PLSZNPlanning Scenarionvarchar100
46TWISPS_NOALLOC1Parameters for Allocation Tables Generated in MAP7PLSZNPlanning Scenarionvarchar100
47TWISPS_NOLISTG1Parameters for Allocation Tables Generated in MAP7PLSZNPlanning Scenarionvarchar100
48TWISPS_NOPROMO1Parameters for Promotions Created in MAP11PLSZNPlanning Scenarionvarchar100