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

82 columns | Print definition?ERP 6.0  | CUOBJ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_MM001Data staging - Material master plant view complex table319CUOBJInternal object numbernvarchar180
2/SMERP/STG_PM001Data staging - Equipment complex table46CUOBJConfiguration (internal object number)nvarchar180
3/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab46CUOBJConfiguration (internal object number)nvarchar180
4ZEIM_AFPOOrder item63CUOBJConfiguration (internal object number)nvarchar180
5ZEIM_LIPSSD document: Delivery: Item data128CUOBJConfigurationnvarchar180
6ZEIM_VBAPSales Document: Item Data150CUOBJConfigurationnvarchar180
TOPAgency Business Global Trade
7WBRPAgency business: Item107CUOBJConfigurationnvarchar180
TOPBasic Functions
8MMPREK_PRO_01Log table for archiving object MMPREK6CUOBJConfiguration (internal object number)nvarchar180
9MMPREK_PRO_01_BLog table - Preference - Info from rule6CUOBJConfiguration (internal object number)nvarchar180
10MMPREK_PRO_02Log table - Main component - Information6CUOBJConfiguration (internal object number)nvarchar180
11MMPREK_PRO_03Log table - Component - Information6CUOBJConfiguration (internal object number)nvarchar180
12VBBESales Requirements: Individual Records37CUOBJConfigurationnvarchar180
TOPBasic functions
13VEPOPacking: Handling Unit Item (Contents)19CUOBJConfiguration (internal object number)nvarchar180
TOPBilling
14VBRPBilling Document: Item Data108CUOBJConfigurationnvarchar180
TOPCentral Part of Product Master
15COMM_PROD_VARAssignment of Product Variants to Configurable Product4CUOBJConfiguration (Internal Object Number)nvarchar180
16COMM_PROD_VARHHistory: Assignment of Variants to Configurable Product5CUOBJConfiguration (Internal Object Number)nvarchar180
TOPClasses
17INOBLink between Internal Number and Object2CUOBJConfiguration (internal object number)nvarchar180
TOPConditions
18A185Order no./Item/Configuration no./Material/Preference zone6CUOBJConfiguration (internal object number)nvarchar180
TOPConstruction Equipment Management
19J_3GARCHIVCEM Archiving Lists3CUOBJConfiguration (internal object number)nvarchar180
TOPCross-Application Components
20MMARCPlant Data for Material123CUOBJInternal object numbernvarchar180
21VVBAPSales Document: Item Data150CUOBJConfigurationnvarchar180
TOPData Collection
22S126Open Variants - Basis 110CUOBJConfigurationnvarchar180
23S126ES126 - Structural information3CUOBJConfigurationnvarchar180
24S127Open Variants - Basis 210CUOBJConfigurationnvarchar180
25S127ES127 - Structural information3CUOBJConfigurationnvarchar180
26S137Variants: Basis 210CUOBJConfigurationnvarchar180
27S137ES137 -Structural Information5CUOBJConfigurationnvarchar180
TOPDefense Forces and Public Security
28/ISDFPS/ZEBANCopy of EBAN78CUOBJConfiguration (internal object number)nvarchar180
TOPDemand Management
29PBEDIndependent Requirements Data23CUOBJConfiguration (internal object number)nvarchar180
TOPEquipment
30EQUIEquipment master data41CUOBJConfiguration (internal object number)nvarchar180
TOPExternal Services
31ESLHService Package Header Data11CUOBJConfiguration (internal object number)nvarchar180
32ESSRService Entry Sheet Header Data51CUOBJConfiguration (internal object number)nvarchar180
TOPGlobal Trade Services
33/SAPSLL/CUCMAPGTS: Mapping of Objects from Customs Code Lists2CUOBJObject from Customs Code Listnvarchar60
34/SAPSLL/TCULROGTS: Assignment of Obj. from Customs Code List to Legal Reg.3CUOBJObject from Customs Code Listnvarchar60
TOPIntegrated Product and Process Engineering
35PPEFILTEXPLThis table is obsolete, use PPEFILTEXPLPAR3CUOBJConfiguration (Internal Object Number)nvarchar180
36PPEFILTEXPLPARExplosion Parameters for the iPPE Filter4CUOBJConfiguration (Internal Object Number)nvarchar180
37PROFILCUST01iPPE: Profile for PS iPPE Interface11CUOBJConfiguration (internal object number)nvarchar180
38PVCMPRPVS Variant (CMP): Supplement to the Selection Criteria8CUOBJConfiguration (Internal Object Number)nvarchar180
39PVCOLPVS Variant (COL): Color Attributes9CUOBJConfiguration (Internal Object Number)nvarchar180
TOPInventory Management
40MWZDM07M2ZDM07M2101CUOBJInternal object numbernvarchar180
41RESBReservation/dependent requirements117CUOBJConfiguration (internal object number)nvarchar180
TOPMaintenance Notifications
42PMSDOPM organizational data for SD documents13CUOBJConfigurationnvarchar180
TOPMaster Data
43MDSMSimulative dependent requirements56CUOBJConfiguration (internal object number)nvarchar180
44PLAFPlanned Order67CUOBJConfiguration (internal object number)nvarchar180
TOPMaterial Master
45MARCPlant Data for Material123CUOBJInternal object numbernvarchar180
46MARC_TMPFile for Incorrect Data in Direct Input126CUOBJInternal object numbernvarchar180
47MVRCCross-version fields for MARC123CUOBJInternal object numbernvarchar180
48WSTN_PP_STRUCPrepack definition - Components table4CUOBJConfiguration (internal object number)nvarchar180
TOPMaterials Management
49/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions83CUOBJConfiguration (internal object number)nvarchar180
TOPProduct Cost Planning
50CKISItems Unit Costing/Itemization Product Costing138CUOBJObject Number for Conf. Objectsnvarchar180
51CKTC_KALNRDatabase Table for Costing Numbers5CUOBJConfiguration (internal object number)nvarchar180
52KALMCosting Run: Costing Objects52CUOBJObject Number for Conf. Objectsnvarchar180
53KALOCosting Run: Costing Objects (KVMK)46CUOBJObject Number for Conf. Objectsnvarchar180
54KEKOProduct Costing - Header Data79CUOBJObject Number for Conf. Objectsnvarchar180
55KNKOAssignment of Cost Est. Number to Config. Object3CUOBJObject Number for Conf. Objectsnvarchar180
56KNOBAssignment of Cost Est. Number to Config. Object5CUOBJObject Number for Conf. Objectsnvarchar180
TOPProduction Orders
57AFKOOrder Header Data PP Orders82CUOBJConfiguration (internal object number)nvarchar180
58AFPOOrder item63CUOBJConfiguration (internal object number)nvarchar180
TOPPurchasing
59EBANPurchase Requisition78CUOBJConfiguration (internal object number)nvarchar180
60EKPOPurchasing Document Item127CUOBJConfiguration (internal object number)nvarchar180
61MEREQXPurchase Requisition Change Parameter78CUOBJUpdated information in related user data fieldnvarchar10
62WRF_POHF_POLOrder list48CUOBJConfiguration (internal object number)nvarchar180
TOPQuality Inspection
63QALSInspection lot record92CUOBJConfiguration (internal object number)nvarchar180
TOPRemaining Beverage - Obsolete Objects
64/BEV1/RBVBAPSales Document: Item Data150CUOBJConfigurationnvarchar180
TOPSales
65VBAPSales Document: Item Data150CUOBJConfigurationnvarchar180
TOPSerial Numbers
66SER00General Header Table for Serial Number Management3CUOBJConfiguration (internal object number)nvarchar180
67T377XDocuments Allowed for Serial Number Management38CUOBJOptionality of Parameter Transfernvarchar10
TOPShipping
68LIPSSD document: Delivery: Item data128CUOBJConfigurationnvarchar180
TOPSimulation
69VSAFKO_CNVersion: Order header data for PP orders83CUOBJConfiguration (internal object number)nvarchar180
70VSAFPO_CNVersion: Order items in PP orders64CUOBJConfiguration (internal object number)nvarchar180
71VSEBAN_CNVersion: Purchase requisition78CUOBJConfiguration (internal object number)nvarchar180
72VSPLAF_CNVersion: Planned order67CUOBJConfiguration (internal object number)nvarchar180
73VSRESB_CNVersion: Reservation/Dependent requirements118CUOBJConfiguration (internal object number)nvarchar180
74VSVBAP_CNVersion: Sales document: Item data151CUOBJConfigurationnvarchar180
TOPSoftware Management
75S426Variant Config.1---IBASE12CUOBJConfiguration (internal object number)nvarchar180
76S427Variant Config.2---IBASE16CUOBJConfiguration (internal object number)nvarchar180
TOPVariant Configuration
77IBVALUECCBASE: Redundant Object Doc. on Value Changes for Instance2CUOBJConfiguration (internal object number)nvarchar180
TOPVehicle Management System
78VLCADDCFGVELO : Addnl Vehicle Configuration, Not Relevant to Search4CUOBJConfiguration (internal object number)nvarchar180
79VLCHISTORYVELO : Vehicle History5CUOBJConfiguration (internal object number)nvarchar180
80VLCPORDERVELO : MM Purchase Order7CUOBJConfiguration (internal object number)nvarchar180
81VLCVEHICLEVELO : Vehicle11CUOBJConfiguration (internal object number)nvarchar180
TOPWarranties
82BGMPMaster Warranty Item20CUOBJConfiguration (internal object number)nvarchar180