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

103 columns | Print definition?ERP 6.0  | BSTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000187000PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item)8BSTYPnvarchar10
2/BIC/B0000188000PSA for 2LIS_02_HDR T90CLNT090 Purch.Data (Header)11BSTYPnvarchar10
3/BIC/B0000189000PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line8BSTYPnvarchar10
4/OPT/VIM_2HEADAdditional Fields for Table /OPT/VIM_1HEAD10BSTYPPurchasing Document Categorynvarchar10
5S520ES520 - Strukturinformationen10BSTYPTyp des Einkaufsbelegsnvarchar10
6SGT_SEGVALSegmentation Value for Supplying Plants3BSTYPPurchasing Document Categorynvarchar10
7SGT_SEGVAL_PRSegmentation Value for Supplying Plants2BSTYPPurchasing Document Categorynvarchar10
8T160SAP Transaction Control, Purchasing4BSTYPPurchasing Document Categorynvarchar10
9T161BDefault Business Transaction Type for Import2BSTYPPurchasing Document Categorynvarchar10
10T161RREORG Control, Purchasing2BSTYPPurchasing Document Categorynvarchar10
11T161VShipping-Specific Data for Stock Tfr. for Purch. Doc. Type2BSTYPPurchasing Document Categorynvarchar10
12T161ZAdditional Checks for Outline Agreements on Reorganization2BSTYPPurchasing Document Categorynvarchar10
13T162Field Selection, Purchasing Document8BSTYPPurchasing Document Categorynvarchar10
14T165KCopying Options: Header Texts4BSTYPCategory of reference document for adoption of textsnvarchar10
15T165PCopying Options: Item texts6BSTYPCategory of reference document for adoption of textsnvarchar10
16T166UHeadings in Purchasing Document Printout4BSTYPPurchasing Document Categorynvarchar10
17ZEIM_VBEPSales Document: Schedule Line Data24BSTYPPurchasing Document Categorynvarchar10
TOPAccount Determination
18TVKOOrganizational Unit: Sales Organizations19BSTYPPurchasing Document Categorynvarchar10
TOPAdditionals Management
19TWTCTRLControl table for procedures for additionals7BSTYPPurchasing Document Categorynvarchar10
TOPBasic Functions
20FDM1Cash Management & Forecast: Line Items of MM Documents21BSTYPPurchasing Document Categorynvarchar10
21FDM2Cash management line items from MM purchase requisition17BSTYPPurchasing Document Categorynvarchar10
22T161SNAssignment of Serial Number Profile to Item Category3BSTYPPurchasing Document Categorynvarchar10
23T163LVDetermination of Confirmation Control Key2BSTYPPurchasing Document Categorynvarchar10
24TVEPSales Document: Schedule Line Categories10BSTYPPurchasing Document Categorynvarchar10
TOPBasis Components
25/XFT/INV_C18Customizing Automatic Posting Tax Codes3BSTYPCategory of Purchasing Documentnvarchar10
26/XFT/INV_C19Customizing Automatic Posting Item Data Determination3BSTYPCategory of Purchasing Documentnvarchar10
TOPCross-Application Components
27VVBEPSales Document: Schedule Line Data24BSTYPPurchasing Document Categorynvarchar10
TOPCustomer Bill of Services
28TBOSSC01Subcontracting: Assignment of Conditions (MM, SD)2BSTYPPurchasing Document Categorynvarchar10
29TBOSSC02Subcontracting: Assignment of Conditions (MM, SD)2BSTYPPurchasing Document Categorynvarchar10
TOPData Collection
30S520Test15BSTYPPurchasing Document Categorynvarchar10
TOPDefense Forces and Public Security
31/ISDFPS/ZEBANCopy of EBAN5BSTYPPurchasing Document Categorynvarchar10
TOPDistributor-Reseller-Management
32/SAPHT/DRMCT161DRM relevant settings for Purchase order type2BSTYPPurchasing Document Categorynvarchar10
TOPExchanges
33OIA03Exchange item data - purchasing side4BSTYPPurchasing Document Categorynvarchar10
34OIA11Exchange assignment for deliveries23BSTYPPurchasing Document Categorynvarchar10
TOPExternal Services
35ESLHService Package Header Data9BSTYPPurchasing Document Categorynvarchar10
36T165ACondition Schema for Services2BSTYPCategory of purchasing document (external service)nvarchar10
TOPFinancial Accounting
37/OPT/VIM_1HEADDocument Header233BSTYPPurchasing Document Categorynvarchar10
TOPFrance
38T5F1BARAttributes of the contribution assessment bases7BSTYPContribution basis type codenvarchar30
39T5F1BCContribution base nature type code mapping4BSTYPContribution basis type codenvarchar30
40T5F1BMContribution basis type code mapping3BSTYPContribution basis type codenvarchar30
41T5F1BNContribution basis type code2BSTYPContribution basis type codenvarchar30
42T5F1BNTContribution basis type code3BSTYPContribution basis type codenvarchar30
TOPFunctions for U.S. Federal Government
43FMFG_MM_PEND_CHGPurchasing document changes requiring Notification approvl3BSTYPPurchasing Document Categorynvarchar10
44FMFG_UO_OBL_MMDTSO Adjustmnt Prog: Pur Doc Types to exclude from Obligations2BSTYPPurchasing Document Categorynvarchar10
TOPIndustry Solution Oil
45TOI0_REL_MM_RANKRanking of MM relevance fields3BSTYPPurchasing Document Categorynvarchar10
TOPInterface to Terminal Automation System
46OIK01IS-OIL/TAS: LID Document Data40BSTYPPurchasing Document Categorynvarchar10
47OIK01DIS-OIL/TAS: deactivated LID Document Data41BSTYPPurchasing Document Categorynvarchar10
48OIKLIDTAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes)21BSTYPPurchasing Document Categorynvarchar10
49OIKLIDRTD - TAS Reference Table27BSTYPPurchasing Document Categorynvarchar10
50OIKLIDWTAS LID Working version (NOTE: keep DB eq to DB OIKLID)21BSTYPPurchasing Document Categorynvarchar10
TOPInventory Management
51MWZDM07M1ZDM07M155BSTYPPurchasing Document Categorynvarchar10
TOPLocalization
52ESFMC_EXCL_EFDException for Budget Control3BSTYPPurchasing Document Categorynvarchar10
TOPLogistics - General
53TB2BCTrading Contract: Purchasing Grouping3BSTYPPurchasing Document Categorynvarchar10
54WBHDTrading Contract: Commercial Data54BSTYPPurchasing Document Categorynvarchar10
TOPMaterials Management
55/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions10BSTYPPurchasing Document Categorynvarchar10
56/ISDFPS/MMRLT161Customizing: Purchasing Doc Types for Rtn Delivery Process2BSTYPPurchasing Document Categorynvarchar10
TOPMedia Product Sales and Distribution
57TJKSDPORDERBSARTOrder Types for IS-M Purchase Orders7BSTYPPurchasing Document Categorynvarchar10
TOPMobile Materials Management
58/ISDFPS/MEMMT161Customizing: Purchasing Document Types Change Pointers (ME)2BSTYPPurchasing Document Categorynvarchar10
TOPNetwork and Activity
59TCNTM01FReference Dates for Date Types of an Event8BSTYPPurchasing Document Categorynvarchar10
TOPPortugal
60T5P2MHR-PT: Social Security - Wage Types for 13th/14th Month10BSTYPCalculation basis naturenvarchar10
TOPPOS Interface
61WVFBDRS Interface, Intermediate Buffer, Order Item FM7BSTYPPurchasing Document Categorynvarchar10
62WVFB2SRS: received external requirement numbers/phys. inv. nos3BSTYPDRS document category for double document checknvarchar10
TOPPurchasing
63EBANPurchase Requisition5BSTYPPurchasing Document Categorynvarchar10
64EINEPurchasing Info Record: Purchasing Organization Data31BSTYPPurchasing Document Categorynvarchar10
65EKABRelease Documentation19BSTYPPurchasing Document Categorynvarchar10
66EKKOPurchasing Document Header4BSTYPPurchasing Document Categorynvarchar10
67EKPOPurchasing Document Item75BSTYPPurchasing Document Categorynvarchar10
68EREVVersion in Purchasing2BSTYPPurchasing Document Categorynvarchar10
69MEREQXPurchase Requisition Change Parameter5BSTYPUpdated information in related user data fieldnvarchar10
70MMPURUI_CFDOCcFolders ID for Purchasing Documents6BSTYPPurchasing Document Categorynvarchar10
71T161Purchasing Document Types2BSTYPPurchasing Document Categorynvarchar10
72T161CSettings for Documents from CRM/BBP2BSTYPPurchasing Document Categorynvarchar10
73T161PCheck of Document Type, Document Category, Item Category3BSTYPPurchasing Document Categorynvarchar10
74T161TTexts for Purchasing Document Types4BSTYPPurchasing Document Categorynvarchar10
75T161VNShipping-Rel. Data f. Stck Transfer f. PO Doc.Type f. St.Loc2BSTYPPurchasing Document Categorynvarchar10
76T161WOrder Types for Stock Transfer4BSTYPPurchasing Document Categorynvarchar10
77T166ASupplement Text in Purchasing Document Printouts3BSTYPPurchasing Document Categorynvarchar10
78T166KHeader Texts in Purchasing Document Printouts3BSTYPPurchasing Document Categorynvarchar10
79T166PItem Texts in Purchasing Document Printouts3BSTYPPurchasing Document Categorynvarchar10
80T16CADCM Control Table: Change Management2BSTYPPurchasing Document Categorynvarchar10
81WRFT_OTB_CHECKCustomizing OTB Check2BSTYPPurchasing Document Categorynvarchar10
82WRF_POTB_DB1Worklist OTB Procurement3BSTYPPurchasing Document Categorynvarchar10
TOPPurchasing Information System
83MCEKSR/2 PURCHIS Data (Status: Last Data Transmission)15BSTYPPurchasing Document Categorynvarchar10
TOPSales
84VBEPSales Document: Schedule Line Data24BSTYPPurchasing Document Categorynvarchar10
TOPSelf-Service Procurement
85/SRMERP/C_FODTPFollow on Document Types4BSTYPPurchasing Document Categorynvarchar10
86/SRMERP/C_TXCPIText Copy Rule Item4BSTYPPurchasing Document Categorynvarchar10
TOPSerial Numbers
87SER08Document Header for Purchase Order Item Serial Numbers6BSTYPPurchasing Document Categorynvarchar10
88SER09Doc. Header for Serial Numbers for Purchase Requisition Item6BSTYPPurchasing Document Categorynvarchar10
TOPShipping
89LIPSPOLIPS Reference Data Purchase Order8BSTYPPurchasing Document Categorynvarchar10
TOPSimulation
90VSEBAN_CNVersion: Purchase requisition6BSTYPPurchasing Document Categorynvarchar10
91VSVBEP_CNVersion: Sales document: Schedule line data25BSTYPPurchasing Document Categorynvarchar10
TOPSupply Chain Management
92TCM_C_PUR_MAPMapping TM Organizational Unit to Purchasing Organisation13BSTYPPurchasing Document Categorynvarchar10
TOPTraders and Schedulers Workbench
93OIJBRDNOMStock Projection item / nomination X-ref table16BSTYPPurchasing Document Categorynvarchar10
94OIJRDNOMStock Projection item / nomination X-ref table16BSTYPPurchasing Document Categorynvarchar10
95TOI0_REL_DOCSSelect document types for relevance assignment4BSTYPPurchasing Document Categorynvarchar10
96TOI0_REL_MMRelevance customizing for MM Documents3BSTYPPurchasing Document Categorynvarchar10
97TOIJ_EL_DOC_MMChoose screens for TSW details pop-up in MM contracts2BSTYPPurchasing Document Categorynvarchar10
98TOIJ_EL_DOC_SETOil TSW: Control document flow and error log3BSTYPPurchasing Document Categorynvarchar10
99TOIJ_EL_EV_MMDefault events for purchase documents2BSTYPPurchasing Document Categorynvarchar10
100TOIJ_EL_MVSCENTSW: Define Movement scenarios8BSTYPPurchasing Document Categorynvarchar10
TOPTreasury
101FLQITEMPO_FCLiquidity Calculation - Forecast Line Items for MM POs20BSTYPPurchasing Document Categorynvarchar10
102FLQITEMPR_FCLiquidity Calc. Forecast - Line Items, Purchase Requisitions18BSTYPPurchasing Document Categorynvarchar10
TOPVehicle Management System
103VLCBATCHACTVELO : Variant for Action Execution in Batch13BSTYPPurchasing Document Categorynvarchar10