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

37 columns | Print definition?ERP 6.0  | PLIFZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_MM001Data staging - Material master plant view complex table214PLIFZPlanned Delivery Time in Daysdecimal30
2BBP_TMP_VENObsolete from 2.0C Onwards. Was Never used Before11PLIFZPlanned Delivery Time in Daysdecimal30
3BBP_TMP_VEN000Temporary: Request 'Bidder', Purchasing Data11PLIFZPlanned Delivery Time in Daysdecimal30
4VEN000Business Partner: General Vendor Data11PLIFZPlanned Delivery Time in Daysdecimal30
TOPAllocation
5AUFIAllocation Table, Document Sub-item, Stores36PLIFZPlanned Delivery Time in Daysdecimal30
6AUVTShipping-Specific Data of Plants for Delivery Generation15PLIFZPlanned Delivery Time in Daysdecimal30
7AUVZDistribution Center15PLIFZPlanned Delivery Time in Daysdecimal30
TOPCross-Application Components
8FRE_DB_PROCYCProcurement cycle7PLIFZPlanned Delivery Time in Daysdecimal30
9MMARCPlant Data for Material18PLIFZPlanned Delivery Time in Daysdecimal30
10PLLPOTask list - operation/activity101PLIFZPlanned Delivery Time in Daysdecimal30
TOPDefense Forces and Public Security
11/ISDFPS/ZEBANCopy of EBAN111PLIFZPlanned Delivery Time in Daysdecimal30
TOPDistribution Requirements Planning
12MDRP_POCOEvent Table: Deployment Run12PLIFZPlanned Delivery Time in Daysdecimal30
TOPInventory Management
13MWZDM07M1ZDM07M1181PLIFZPlanned Delivery Time in Daysdecimal30
TOPMaintenance History
14HIVGPM order history - operations41PLIFZPlanned Delivery Time in Daysdecimal30
TOPMaster Data
15MDMAMRP Area for Material44PLIFZPlanned Delivery Time in Daysdecimal30
TOPMaster Data Distribution
16/ISDFPS/TL1Task List - Operation/Activity101PLIFZPlanned Delivery Time in Daysdecimal30
TOPMaterial Master
17MARCPlant Data for Material18PLIFZPlanned Delivery Time in Daysdecimal30
18MARC_TMPFile for Incorrect Data in Direct Input21PLIFZPlanned Delivery Time in Daysdecimal30
19MDIPMaterial: MRP Profiles (Field Contents)7PLIFZPlanned Delivery Time in Daysdecimal30
20MVRCCross-version fields for MARC18PLIFZPlanned Delivery Time in Daysdecimal30
TOPMaterials Management
21/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions117PLIFZPlanned Delivery Time in Daysdecimal30
TOPPerishables Procurement
22FIP_D_PDT_TO_CUSInternal planned delivery time from suppl. Plant to customer7PLIFZPlanned Delivery Time in Daysdecimal30
23FIP_D_PDT_TO_DCExternal planned delivery time from vendor to suppl. plant6PLIFZPlanned Delivery Time in Daysdecimal30
24FIP_D_PDT_TO_STInternal planned delivery time from suppl. plant to store6PLIFZPlanned Delivery Time in Daysdecimal30
TOPProduction Orders
25AFVVDB structure of the quantities/dates/values in the operation39PLIFZPlanned Delivery Time in Daysdecimal30
TOPPurchasing
26EBANPurchase Requisition111PLIFZPlanned Delivery Time in Daysdecimal30
27EKPOPurchasing Document Item83PLIFZPlanned Delivery Time in Daysdecimal30
28EKPVShipping Data For Stock Transfer of Purchasing Document Item14PLIFZPlanned Delivery Time in Daysdecimal30
29EQUPQuota File: Item22PLIFZPlanned Delivery Time in Daysdecimal30
30MEREQXPurchase Requisition Change Parameter111PLIFZUpdated information in related user data fieldnvarchar10
TOPRouting
31PLPOTask list - operation/activity101PLIFZPlanned Delivery Time in Daysdecimal30
TOPSelf-Service Procurement
32/SRMERP/D_SC_ITMShopping Cart Item22PLIFZPlanned Delivery Time in Daysdecimal30
TOPSimulation
33VSAFVV_CNVersion: Quantities/Dates/Values in order operation40PLIFZPlanned Delivery Time in Daysdecimal30
34VSEBAN_CNVersion: Purchase requisition112PLIFZPlanned Delivery Time in Daysdecimal30
TOPVendor Master
35LFM1Vendor master record purchasing organization data25PLIFZPlanned Delivery Time in Daysdecimal30
36LFM2Vendor Master Record: Purchasing Data27PLIFZPlanned Delivery Time in Daysdecimal30
37WYT5Changes to Vendor Master Record12PLIFZPlanned Delivery Time in Daysdecimal30