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

118 columns | Print definition?ERP 6.0  | BSART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000187000PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item)7BSARTnvarchar40
2/BIC/B0000188000PSA for 2LIS_02_HDR T90CLNT090 Purch.Data (Header)10BSARTnvarchar40
3/BIC/B0000189000PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line7BSARTnvarchar40
4/OPT/VIM_2HEADAdditional Fields for Table /OPT/VIM_1HEAD11BSARTOrder Type (Purchasing)nvarchar40
5FSH_OS_MMTable for MM Season customizing2BSARTPurchasing Document Typenvarchar40
6FSH_OS_STODocument type customizing for STO's2BSARTPurchasing Document Typenvarchar40
7P2B2_PTHCM Declustering B2 - Time Event Pairs14BSARTTime event pair startnvarchar30
8S520ES520 - Strukturinformationen11BSARTBestellartnvarchar40
9SGT_SEGVALSegmentation Value for Supplying Plants4BSARTPurchasing Document Typenvarchar40
10SGT_SEGVAL_PRSegmentation Value for Supplying Plants3BSARTPurchasing Document Typenvarchar40
11T160SAP Transaction Control, Purchasing6BSARTPurchasing Document Typenvarchar40
12T161BDefault Business Transaction Type for Import3BSARTPurchasing Document Typenvarchar40
13T161RREORG Control, Purchasing3BSARTPurchasing Document Typenvarchar40
14T161VShipping-Specific Data for Stock Tfr. for Purch. Doc. Type3BSARTPurchasing Document Typenvarchar40
15T161ZAdditional Checks for Outline Agreements on Reorganization3BSARTPurchasing Document Typenvarchar40
16T166UHeadings in Purchasing Document Printout5BSARTPurchasing Document Typenvarchar40
17TMKSUCalculation Schema: Purchasing: for Stock Transfer2BSARTPurchasing Document Typenvarchar40
18TMS_C_PAGExt. TMS: Settings for Int. of MM Scheduling Agreements2BSARTOrder Type (Purchasing)nvarchar40
19ZEIM_VBEPSales Document: Schedule Line Data23BSARTOrder Type (Purchasing)nvarchar40
TOPAccount Determination
20TVKOOrganizational Unit: Sales Organizations18BSARTOrder Type (Purchasing)nvarchar40
TOPAdditionals Management
21TWTCTRLControl table for procedures for additionals8BSARTOrder Type (Purchasing)nvarchar40
TOPAllocation
22AUBSIWorklist for PO (Follow-on Document Generation)25BSARTOrder type in allocation table (for external vendor)nvarchar40
23AUPOAllocation Table Document Item47BSARTOrder type in allocation table (for external vendor)nvarchar40
24T621Item Categories for Allocation Tables10BSARTOrder type in allocation table (for external vendor)nvarchar40
TOPBasic Functions
25T161SNAssignment of Serial Number Profile to Item Category2BSARTPurchasing Document Typenvarchar40
26T163LVDetermination of Confirmation Control Key3BSARTOrder Type (Purchasing)nvarchar40
27TVEPSales Document: Schedule Line Categories9BSARTOrder Type (Purchasing)nvarchar40
TOPConditions
28B025Purchasing Output Determination: Doc.Type/Purch.Org/Vendor4BSARTPurchasing Document Typenvarchar40
29B026Purchasing Output Determination: Document Type4BSARTPurchasing Document Typenvarchar40
30B100Output Determination: DocumentType/Purch.Org./Material Group4BSARTPurchasing Document Typenvarchar40
TOPConsumption-Based Planning See Also PP-MRP
31EDMMSAssignment of EDI partner to purchasing org. and plant8BSARTPurchasing Document Typenvarchar40
32TMDRD_DOCTPDelivery Relationshp: Document Types per Document Category3BSARTPurchasing Document Typenvarchar40
33TWDRD_DOCTPDelivery Relationshp: Document Types per Document Category3BSARTPurchasing Document Typenvarchar40
TOPCross-Application Components
34FRE_DOC_CAT_SENTRelevant Document Categories and Types for Outbound Interf3BSARTPurchasing Document Typenvarchar40
35FRE_DOC_CAT_TYPERelevant Document Categories and Types for Outbound Interf3BSARTPurchasing Document Typenvarchar40
36FRE_OP_PO_KEYKey-Completion F&R Order Proposal <-> R/3 Purchase Order9BSARTPurchasing Document Typenvarchar40
37VVBEPSales Document: Schedule Line Data23BSARTOrder Type (Purchasing)nvarchar40
TOPCustomer Bill of Services
38TBOSSC01Subcontracting: Assignment of Conditions (MM, SD)3BSARTOrder Type (Purchasing)nvarchar40
39TBOSSC02Subcontracting: Assignment of Conditions (MM, SD)3BSARTOrder Type (Purchasing)nvarchar40
TOPData Collection
40S520Test16BSARTOrder Type (Purchasing)nvarchar40
TOPData Retention Tool
41TXW_S_EKKORetrieve EKKO from archive6BSARTPurchasing Document Typenvarchar40
TOPDefense Forces and Public Security
42/ISDFPS/ZEBANCopy of EBAN4BSARTPurchase Requisition Document Typenvarchar40
TOPDistributor-Reseller-Management
43/SAPHT/DRMCT161DRM relevant settings for Purchase order type3BSARTPurchasing Document Typenvarchar40
TOPDown Payment Chains
44/SAPPCE/T_PODPCCustomization table for assigning PO to DPC2BSARTOrder Type (Purchasing)nvarchar40
TOPExchanges
45OIA03Exchange item data - purchasing side5BSARTOrder Type (Purchasing)nvarchar40
TOPExternal Services
46T165ACondition Schema for Services3BSARTPurchasing Document Typenvarchar40
TOPFunctions for U.S. Federal Government
47FMFG_UO_OBL_MMDTSO Adjustmnt Prog: Pur Doc Types to exclude from Obligations3BSARTPurchasing Document Typenvarchar40
TOPFunds Management
48FMFGTOLDCTYPDocument types for US Federal MM tolerances2BSARTPurchasing Document Typenvarchar40
TOPImplementation of Organizational Flexibility in Logistics
49/ISDFPS/CRELSTYRelocation Step Type5BSARTOrderType Relocat.nvarchar40
TOPIndustry Solution Oil
50TOI0_REL_MM_RANKRanking of MM relevance fields4BSARTOrder Type Set Upnvarchar40
TOPKANBAN
51TPK02Key for Controlling Control Cycle: External Replenishment11BSARTOrder Type (Purchasing)nvarchar40
TOPLocalization
52ESFMC_EXCL_EFDException for Budget Control4BSARTPurchasing Document Typenvarchar40
53J_3RFMM_RATE_CLCEnable Down Payments in FC Function for MM Documents3BSARTPurchasing Document Typenvarchar40
TOPLogistics - General
54TB2BCTrading Contract: Purchasing Grouping4BSARTOrder Type (Purchasing)nvarchar40
55WBHDTrading Contract: Commercial Data55BSARTOrder Type (Purchasing)nvarchar40
TOPMarketing, Accounting and Pricing
56OIC_FORM_ATTRIBAttributes of Business Context for F&A Formula19BSARTOrder Type (Purchasing)nvarchar40
TOPMaster Data
57T438MControl Parameter for MRP -Material Level-35BSARTMRP:doc.type purchase requisitions for standard purchase ordnvarchar40
TOPMaterials Management
58/ISDFPS/ADVCODE2Advice Code with Document Type2BSARTPurchase Requisition Document Typenvarchar40
59/ISDFPS/CADVCODEAdvice Code - Table Obsolete - Do Not Use Anymore2BSARTPurchase Requisition Document Typenvarchar40
60/ISDFPS/CREBSARTOrder Types Relevant for Return Delivery2BSARTPurchasing Document Typenvarchar40
61/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions9BSARTPurchase Requisition Document Typenvarchar40
62/ISDFPS/MMRLT161Customizing: Purchasing Doc Types for Rtn Delivery Process3BSARTPurchasing Document Typenvarchar40
63/ISDFPS/PRPLCNTLSubsequent Processing for Prioritized Materials Planning6BSARTPurchase Requisition Document Typenvarchar40
TOPMedia Product Sales and Distribution
64TJKSDPORDERBSARTOrder Types for IS-M Purchase Orders8BSARTPurchasing Document Typenvarchar40
65TJKSDPORDERPOSItem Categories for Purchase Order2BSARTPurchasing Document Typenvarchar40
TOPMobile Materials Management
66/ISDFPS/MEMMT161Customizing: Purchasing Document Types Change Pointers (ME)3BSARTPurchasing Document Typenvarchar40
TOPPerishables Procurement
67FIP_D_ORDER_LINEOrder lines for FIP22BSARTPurchasing Document Typenvarchar40
68FIP_D_SP_VENDORRelationship Supply Plants and Vendors for FIP6BSARTOrder Type (Purchasing)nvarchar40
TOPPOS Interface
69WVFBDRS Interface, Intermediate Buffer, Order Item FM8BSARTPurchasing Document Typenvarchar40
TOPPurchasing
70EBANPurchase Requisition4BSARTPurchase Requisition Document Typenvarchar40
71EKKOPurchasing Document Header5BSARTPurchasing Document Typenvarchar40
72MEREQXPurchase Requisition Change Parameter4BSARTUpdated information in related user data fieldnvarchar10
73T161Purchasing Document Types3BSARTPurchasing Document Typenvarchar40
74T161CSettings for Documents from CRM/BBP3BSARTOrder Type (Purchasing)nvarchar40
75T161PCheck of Document Type, Document Category, Item Category2BSARTPurchasing Document Typenvarchar40
76T161TTexts for Purchasing Document Types3BSARTPurchasing Document Typenvarchar40
77T161VNShipping-Rel. Data f. Stck Transfer f. PO Doc.Type f. St.Loc3BSARTPurchasing Document Typenvarchar40
78T161WOrder Types for Stock Transfer5BSARTPurchasing Document Typenvarchar40
79T166ASupplement Text in Purchasing Document Printouts4BSARTPurchasing Document Typenvarchar40
80T166KHeader Texts in Purchasing Document Printouts4BSARTPurchasing Document Typenvarchar40
81T166PItem Texts in Purchasing Document Printouts4BSARTPurchasing Document Typenvarchar40
82T16CADCM Control Table: Change Management3BSARTPurchasing Document Typenvarchar40
83T16CEOutput Control: Display of Change Documents in Purchasing2BSARTPurchasing Document Typenvarchar40
84T16CRVersion-Relevant Fields of Purchase Requisition2BSARTPurchasing Document Typenvarchar40
85WDFR_DISPPerishables Planning Header107BSARTPurchasing Document Typenvarchar40
86WDFR_POSPerishables Planninng Item84BSARTPurchasing Document Typenvarchar40
87WRFT_OTB_CHECKCustomizing OTB Check3BSARTPurchasing Document Typenvarchar40
88WRFT_POHF_GROUPControl Table for Grouping2BSARTPurchasing Document Typenvarchar40
89WRFT_POHF_INBDOrder List Settings Document Types2BSARTPurchasing Document Typenvarchar40
90WRF_POHF_POLOrder list3BSARTPurchasing Document Typenvarchar40
91WRF_POTB_DB1Worklist OTB Procurement10BSARTOrder Type (Purchasing)nvarchar40
92WRF_PRCT_WL_ITEMOriginal Table for Worklist Items7BSARTOrder Type (Purchasing)nvarchar40
93WRF_PRCT_WL_SHDWShadow Table for Worklist Items10BSARTOrder Type (Purchasing)nvarchar40
TOPPurchasing Information System
94MCEKSR/2 PURCHIS Data (Status: Last Data Transmission)29BSARTOrder Type (Purchasing)nvarchar40
TOPSales
95VBEPSales Document: Schedule Line Data23BSARTOrder Type (Purchasing)nvarchar40
TOPSelf-Service Procurement
96/SRMERP/C_FODTPFollow on Document Types5BSARTPurchasing Document Typenvarchar40
97/SRMERP/D_SC_ITMShopping Cart Item50BSARTPurchasing Document Typenvarchar40
TOPSerial Numbers
98SER08Document Header for Purchase Order Item Serial Numbers7BSARTPurchasing Document Typenvarchar40
99SER09Doc. Header for Serial Numbers for Purchase Requisition Item7BSARTPurchasing Document Typenvarchar40
TOPShipping
100LIPSPOLIPS Reference Data Purchase Order9BSARTOrder Type (Purchasing)nvarchar40
TOPSimulation
101VSEBAN_CNVersion: Purchase requisition5BSARTPurchase Requisition Document Typenvarchar40
102VSVBEP_CNVersion: Sales document: Schedule line data24BSARTOrder Type (Purchasing)nvarchar40
TOPStructures Workbench
103/ISDFPS/MATSPPLNMaterials Planned for Force Element46BSARTOrder Type (Purchasing)nvarchar40
TOPSupply Chain Management
104TCM_C_PUR_MAPMapping TM Organizational Unit to Purchasing Organisation14BSARTPurchasing Document Typenvarchar40
TOPTariffs, Duties and Permits
105OIH08Default values for external procurement functions4BSARTOrder Type (Purchasing)nvarchar40
106OIH08ADefault values for external procurement functions7BSARTOrder Type (Purchasing)nvarchar40
TOPTraders and Schedulers Workbench
107OIJBRDDOCRundown item / document X-ref table for Batch - WILL EXPIR18BSARTOrder Type (Purchasing)nvarchar40
108OIJRDDOCRundown item / document X-ref table/ WILL EXPIRE IN FUTURE18BSARTOrder Type (Purchasing)nvarchar40
109OIJ_EL_DOC_I_REFDocument item reference to nomination22BSARTOrder Type (Purchasing)nvarchar40
110S431PURCHIS: (OIL-TSW) Purchasing document stats by TSW object33BSARTOrder Type (Purchasing)nvarchar40
111TOI0_REL_MMRelevance customizing for MM Documents4BSARTOrder Type (Purchasing)nvarchar40
112TOIJ_EL_INCOMPIS-OIL TSW: Activate incompletion for sales and purchasing4BSARTPurchasing Document Typenvarchar40
113TOIJ_EL_INC_FIS-OIL TSW: specify incompletion fields5BSARTPurchasing Document Typenvarchar40
114TOIJ_EL_MVSCENTSW: Define Movement scenarios10BSARTPurchasing Document Typenvarchar40
TOPTransportation Management Integration
115TMS_C_PURExt. Transport Manag.: Determination of Transfer Relev. PUR4BSARTOrder Type (Purchasing)nvarchar40
TOPVehicle Management System
116CVLC23VELO : Assign Organization Data to VMS Roles13BSARTOrder Type (Purchasing)nvarchar40
117VLCBATCHACTVELO : Variant for Action Execution in Batch14BSARTPurchasing Document Typenvarchar40
TOPWaste Management
118EHSWAC_ENTAMBWParameters for Purchasing Management4BSARTOrder Type (Purchasing)nvarchar40