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

55 columns | Print definition?ERP 6.0  | PROFL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____00YBSID-Tabelle fuer DG indicator profile3PROFLDangerous Goods Indicator Profilenvarchar30
2/SMERP/STG_MM001Data staging - Material master plant view complex table110PROFLDangerous Goods Indicator Profilenvarchar30
3/SMERP/STG_MM002Data staging - Material storage location view complex table110PROFLDangerous Goods Indicator Profilenvarchar30
4/SMERP/STG_MM003Data staging - Material UoM view complex table111PROFLDangerous Goods Indicator Profilenvarchar30
5/SMERP/STG_MM004Data staging - Material warehouse view complex table110PROFLDangerous Goods Indicator Profilenvarchar30
6/SMERP/STG_MM005Data staging - Material batch view complex table110PROFLDangerous Goods Indicator Profilenvarchar30
7PCTR_T_AUTH_ORGPCTR auth. structural org management Auth level config3PROFLAuthorization Profilenvarchar120
8UMD01Default values for MRP19PROFLOverall profile for capacity levelingnvarchar100
9ZEIMMARAUSING FOR STORING EIM MARA DATAS113PROFLDangerous Goods Indicator Profilenvarchar30
10ZEIM_LIPSSD document: Delivery: Item data189PROFLDangerous Goods Indicator Profilenvarchar30
11T7PIQAGR_AUTHPQAuthorization Profiles for Appraisals2PROFLAuthorization Profile for Appraisalsnvarchar120
12T7PIQAGR_AUTHPRStructure of Authorization Profiles for Appraisals2PROFLAuthorization Profile for Appraisalsnvarchar120
13T7PIQAGR_AUTHPSAuthorization Profiles for Appraisals (Texts)3PROFLAuthorization Profile for Appraisalsnvarchar120
TOPAdd-Ons for Progress Analysis
14AD03PHPPlan data handling profile2PROFLPlan data handling profile IDnvarchar60
15AD03PHPTPlan data handling profile text3PROFLPlan data handling profile IDnvarchar60
TOPBills of Material
16TCSVLUser defaults list display (variable lists)5PROFLList profile for variable listsnvarchar180
TOPConstruction Progress Report
17/SAPPCE/TPNV01Constr.Progr. Report/Plan Data: Definition of Cost Elements2PROFLProject Profilenvarchar70
18/SAPPCE/TPNV01KConstruction Progress Report: Definition Offsetting Account2PROFLProject Profilenvarchar70
19/SAPPCE/TPNV04Construction Progress Report: Assignment BDS Document2PROFLProject Profilenvarchar70
20/SAPPCE/TPNV06Planned Revenues: Assignment BDS Document2PROFLProject Profilenvarchar70
21/SAPPCE/TPNV07Planned Costs: Assignment BDS Document2PROFLProject Profilenvarchar70
22/SAPPCE/TPNV17Construction Progress Report: Assignment BSP Application2PROFLProject Profilenvarchar70
TOPCross-Application Components
23MMARAGeneral material data113PROFLDangerous Goods Indicator Profilenvarchar30
TOPDangerous Goods Management
24TDG42DG: Desc. DG indicator profiles for material master3PROFLDangerous Goods Indicator Profilenvarchar30
TOPEnvironment, Health and Safety
25TDG41DG: DG Indicator Profiles for Material Master2PROFLDangerous Goods Indicator Profilenvarchar30
TOPMaterial Master
26MARAGeneral Material Data113PROFLDangerous Goods Indicator Profilenvarchar30
27MARA_TMPFile for Incorrect Data in Direct Input120PROFLDangerous Goods Indicator Profilenvarchar30
28MVRACross-version fields for MARA113PROFLDangerous Goods Indicator Profilenvarchar30
TOPOperative Structures
29PROJProject definition35PROFLProject Profilenvarchar70
TOPOrganizational Management
30HRT1017Table Part Infotype 10174PROFLAuthorization Profilenvarchar120
31T77PQAuthorization Profiles2PROFLAuthorization Profilenvarchar120
32T77PRDefinition of Authorization Profiles2PROFLAuthorization Profilenvarchar120
33T77PSAuthorization Profile Texts3PROFLAuthorization Profilenvarchar120
34T77UAUser Authorizations3PROFLAuthorization Profilenvarchar120
TOPProduct Data Management
35CEPFOLDERSTable of CM folder for CEP scenario9PROFLProfile for field selection in CEPnvarchar70
36TFPROFT_CEPCEP Customizing Table: Profile for Field Selection2PROFLProfile for field selection in CEPnvarchar70
37TFPROF_CEPCEP Customizing Table: Profile for Field Selection2PROFLProfile for field selection in CEPnvarchar70
38TFSEL_CEPCEP Customizing table: Fields for display in CEP control2PROFLProfile for field selection in CEPnvarchar70
39TPROFT_CEPText Table for CEP Profile2PROFLScenario for CEPnvarchar70
40TPROF_CEPProfile for CEP2PROFLScenario for CEPnvarchar70
TOPProject Risk Management for Contractors
41/SAPPCE/JVA_PSPAssignment project profile/project type -> JVA profile3PROFLProject Profilenvarchar70
TOPReal Estate Management
42S402Business entities17PROFLSettlement profile for costsnvarchar60
43S405Building102PROFLSettlement profilenvarchar60
44S407Rental agreements22PROFLSettlement profile for costsnvarchar60
45VIMI01Rental unit - Master data58PROFLSettlement profile for costsnvarchar60
46VIMI04Old. replaced in 3.0 with VIMIMV89PROFLSettlement profile for costsnvarchar60
47VIMIMVLease-Out69PROFLSettlement profile for costsnvarchar60
48VIOB01Business entities41PROFLSettlement profile for costsnvarchar60
49VIOB02Property master data52PROFLSettlement profile for costsnvarchar60
50VIOB03Real estate building master63PROFLSettlement profilenvarchar60
51VIRPS405Building102PROFLSettlement profilenvarchar60
52VIRPS407Rental agreements22PROFLSettlement profile for costsnvarchar60
TOPShipping
53LIPSSD document: Delivery: Item data189PROFLDangerous Goods Indicator Profilenvarchar30
TOPSimulation
54VSPROJ_CNVersion: Project definition36PROFLProject Profilenvarchar70
TOPTemplates
55PROJSStandard project definition35PROFLProject Profilenvarchar70