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

97 columns | Print definition?ERP 6.0  | SERNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_PM001Data staging - Equipment complex table50SERNRSerial Numbernvarchar180
2/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab50SERNRSerial Numbernvarchar180
3ZEIM_AFPOOrder item44SERNRBOM explosion numbernvarchar80
4ZEIM_LIPSSD document: Delivery: Item data134SERNRBOM explosion numbernvarchar80
5ZEIM_VBAPSales Document: Item Data142SERNRBOM explosion numbernvarchar80
6ZEIM_VBEPSales Document: Schedule Line Data51SERNRBOM explosion numbernvarchar80
TOPAP-LIM Logistics Inventory Management Engine
7/LIME/PN_SERIAL/LIME/DOC - PN Document for Serial Numbers9SERNRSerial Numbernvarchar300
8/LIME/USID_I001LIME - USID Key Serial Number (R/3)2SERNRSerial Numbernvarchar300
TOPAuto-ID Backend Integration
9AIDEPCREFObsolite: EPC Reference10SERNRSerial Numbernvarchar180
TOPBasic Functions
10ANLAAsset Master Record Segment131SERNRSerial numbernvarchar180
TOPBasic functions
11HUINV_SERNRHandling Unit Phys. Inv. Doc. - Serial Numbers for Item4SERNRSerial Numbernvarchar180
12HUMSEG_SERSerial Numbers for the HUMSEG Table4SERNRSerial Numbernvarchar180
13HUWM_LOAD_PROTLog Table of Initial Data Transfer for Subsequent Posting65SERNRSerial Numbernvarchar180
TOPBasic Functions
14T850HUpload Methods: Field Catalogs4SERNRSequential field numbernvarchar20
15VBBESales Requirements: Individual Records34SERNRBOM explosion numbernvarchar80
16VBBSSales Requirement Totals Record22SERNRBOM explosion numbernvarchar80
TOPBilling
17VBRPBilling Document: Item Data114SERNRBOM explosion numbernvarchar80
TOPClinical System
18N1MATVMIS-H*MED: Medical info for material consumpt. documentation8SERNRBOM Explosion Numbernvarchar200
TOPConsolidation
19TF011Generate Request Screen: Formating Instructions2SERNRFour-digit numbernvarchar40
20TF382Upload Methods: Field Catalogs4SERNRSequential field numbernvarchar20
21TF656Activities - Default Sequence3SERNRSequence numbernvarchar20
TOPCross-Application Components
22/GCDSMIC/REPRINTReprint6SERNRValidity: serial numbernvarchar180
23VVBAPSales Document: Item Data142SERNRBOM explosion numbernvarchar80
24VVBEPSales Document: Schedule Line Data51SERNRBOM explosion numbernvarchar80
TOPData Collection
25S120Sales as per receipts46SERNRBOM Explosion Numbernvarchar250
26S120BIW1S120BIW1 * Sales as Per Receipts46SERNRBOM Explosion Numbernvarchar250
27S120BIW2S120BIW2 * Sales as Per Receipts46SERNRBOM Explosion Numbernvarchar250
TOPDefense Forces and Public Security
28/ISDFPS/ZEBANCopy of EBAN55SERNRBOM explosion numbernvarchar80
TOPDemand Management
29PBEDIndependent Requirements Data14SERNRBOM explosion numbernvarchar80
TOPEquipment
30EQUIEquipment master data45SERNRSerial Numbernvarchar180
31IEQT_WL_HDR_BACInterim Statuses - Header Data (Backup)14SERNRSerial Numbernvarchar180
32IEQT_WL_HEADERInterim Statuses - Header Data13SERNRSerial Numbernvarchar180
TOPGeneral Ledger Accounting
33FAGL_RRI_CUSTCustomiz. for Report Interface (NewGL: FI-CO Reconciliation)4SERNRBRST Sequence Numbernvarchar40
34FAGL_RRI_CUST_DDefault Contents for Table FAGL_RRI_CUST3SERNRBRST Sequence Numbernvarchar40
TOPGreat Britain
35T5G_P46ARVHR-GB: Archive for P46(Car)-Forms2SERNRHR-GB: Serial number of P46(Car)-Forms for employeenvarchar40
TOPInformation System
36MCAFPOVVersions: Order Item34SERNRBOM explosion numbernvarchar80
37MCSFISR/2 SFIS Data: Old65SERNRBOM explosion numbernvarchar80
TOPInventory Management
38RESBReservation/dependent requirements33SERNRBOM explosion numbernvarchar80
TOPLogbook
39DIACL_CLISTDI CLIST: Component data5SERNRSerial Numbernvarchar180
TOPMaintenance Orders
40/CUM/AFCUCU: CU Instances12SERNRBOM explosion numbernvarchar80
TOPMalaysia
41T5LSQSerial no Table for EA form - Malaysia9SERNRSerial number for EA formnvarchar60
TOPMaster Data
42MDSMSimulative dependent requirements72SERNRBOM explosion numbernvarchar80
43MDTBMRP Table53SERNRBOM explosion numbernvarchar80
44PLAFPlanned Order38SERNRBOM explosion numbernvarchar80
45SNUCChanged revision levels (for creating MRP records RM61SR00)2SERNRBOM explosion numbernvarchar80
46SNUMBOM explosion number2SERNRBOM explosion numbernvarchar80
47SUMSNew key assignment: BOM explosion no.->New BOM explosion no.4SERNRBOM explosion numbernvarchar80
TOPMaterials Management
48/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions60SERNRBOM explosion numbernvarchar80
49/ISDFPS/REO_PLANPlanned Transfer Postings for Reorganizations10SERNRSerial Numbernvarchar180
50/ISDFPS/REO_PSERPlanned Transfer Postings for Reorganizations (Serial Nos)4SERNRSerial Numbernvarchar180
51/ISDFPS/SERMATWMAssignment: Serial. Material -> Stor. Bin (Loading Object)3SERNRSerial Numbernvarchar180
TOPOLAP Technology
52RSBBSCUBEBW: InfoCube Receiver3SERNRBRST Sequence Numbernvarchar40
53RSBBSCUBEMAPPINGFixed Mapping for BW-R/RI3SERNRBRST Sequence Numbernvarchar40
54RSBBSCUBETBW: Texts for InfoCube Receiver4SERNRBRST Sequence Numbernvarchar40
55RSBBSQRYMAPPINGFixed Mapping for BW-R/RI4SERNRBRST Sequence Numbernvarchar40
56RSBBSQUERYBW: Query Receiver4SERNRBRST Sequence Numbernvarchar40
57RSBBSQUERYTBW: Texts for Query Receiver5SERNRBRST Sequence Numbernvarchar40
TOPPension fund Netherlands
58T5NK9Kasstroom overzicht - log4SERNRVolgnummernvarchar50
TOPProduction Orders
59AFPOOrder item44SERNRBOM explosion numbernvarchar80
60OCMHOMO_ARCHBackup Table of Homogeneity List in Case of Archiving8SERNRBOM explosion numbernvarchar80
TOPPurchasing
61EBANPurchase Requisition55SERNRBOM explosion numbernvarchar80
62EKEHScheduling Agreement Release Documentation12SERNRBOM explosion numbernvarchar80
63EKEHHRemoved Scheduling Agreement Release Documentation12SERNRBOM explosion numbernvarchar80
64EKETScheduling Agreement Schedule Lines21SERNRBOM explosion numbernvarchar80
65EKETHScheduling Agreement Schedules: History Tables21SERNRBOM explosion numbernvarchar80
66MEREQXPurchase Requisition Change Parameter55SERNRUpdated information in related user data fieldnvarchar10
TOPRemaining Beverage - Obsolete Objects
67/BEV1/RBVBAPSales Document: Item Data142SERNRBOM explosion numbernvarchar80
TOPReportReport Interface
68TRSTIBRST assignment sender -> receiver (Communication Handler)8SERNRBRST Sequence Numbernvarchar40
69TRSTI0R/R Interface: Assignment Cross-Client Senders to Receivers7SERNRBRST Sequence Numbernvarchar40
70TRSTI0TAssignment Cross-Client Senders to Receivers: Receiver Texts8SERNRBRST Sequence Numbernvarchar40
71TRSTITBRST assignment sender -> receiver: Receiver texts9SERNRBRST Sequence Numbernvarchar40
TOPSales
72VBAPSales Document: Item Data142SERNRBOM explosion numbernvarchar80
73VBEPSales Document: Schedule Line Data51SERNRBOM explosion numbernvarchar80
74VBSNChange status relating to scheduling agreements8SERNRBOM explosion numbernvarchar80
TOPSerial Numbers
75EQSESerial Number Records4SERNRSerial Numbernvarchar180
76OBJKPlant Maintenance Object List11SERNRSerial Numbernvarchar180
77SERBLPlant Maintenance Object List4SERNRBOM explosion numbernvarchar80
78SERISerial Numbers3SERNRSerial Numbernvarchar180
TOPService Processing
79VBPMSupplement for Sales Document Items: Technical PM Objects6SERNRSerial Numbernvarchar180
TOPShipping
80LIPSSD document: Delivery: Item data134SERNRBOM explosion numbernvarchar80
TOPSimulation
81VSAFPO_CNVersion: Order items in PP orders45SERNRBOM explosion numbernvarchar80
82VSEBAN_CNVersion: Purchase requisition56SERNRBOM explosion numbernvarchar80
83VSPLAF_CNVersion: Planned order39SERNRBOM explosion numbernvarchar80
84VSRESB_CNVersion: Reservation/Dependent requirements34SERNRBOM explosion numbernvarchar80
85VSVBAP_CNVersion: Sales document: Item data143SERNRBOM explosion numbernvarchar80
86VSVBEP_CNVersion: Sales document: Schedule line data52SERNRBOM explosion numbernvarchar80
TOPSoftware Management
87S426Variant Config.1---IBASE14SERNRSerial Numbernvarchar180
88S427Variant Config.2---IBASE18SERNRSerial Numbernvarchar180
TOPStructures Workbench
89/ISDFPS/EQUIPLNMaterials Planned for Force Element (Serialized)5SERNRSerial Numbernvarchar180
90/ISDFPS/MATSPPLNMaterials Planned for Force Element15SERNRSerial Numbernvarchar180
91/ISDFPS/STOCK_MVBackground Relocation Stocks to Be Transferred7SERNRSerial Numbernvarchar180
TOPTakeoverHandover of Technical Objects
92PHINTPhase In Table20SERNRSerial Numbernvarchar180
TOPTechnical Objects
93TITOB_IBASECreation of IBase: Buffer Table Structures7SERNRSerial Numbernvarchar180
TOPUnique Identification
94IUID_MAN_DATAManually Maintained Values for IUID Messages7SERNRSerial Numbernvarchar180
95IUID_PEDIGREEUII IDoc Message Data for Supporting Supplier Collaboration7SERNRSerial Numbernvarchar180
96UII_IUIDUnique Item Identifier10SERNRSerial Numbernvarchar180
TOPWaste Management
97EWA_ORDER_OBJECTItem Table for Waste Disposal Order6SERNRSerial Numbernvarchar180