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

109 columns | Print definition?ERP 6.0  | MEDIUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PICM/C_APPL_FRMPICM: Application print form4MEDIUMOutputnvarchar10
2BBP_TMP_VENObsolete from 2.0C Onwards. Was Never used Before12MEDIUMTransmission Medium (Printer, Fax, EDI, XML, and so on)nvarchar30
3BBP_TMP_VEN000Temporary: Request 'Bidder', Purchasing Data12MEDIUMTransmission Medium (Printer, Fax, EDI, XML, and so on)nvarchar30
4BKK_OPD_RCN_ACReconciliation Accounts for Outgoing Payment Dispatcher12MEDIUMMediumnvarchar40
5GHO_ALC_SRC_FORMFormula Source data for Allocation results invalidation5MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
6GHO_ALC_SRC_NDRLSource Table for Node Rule6MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
7GHO_ALC_SRC_NRULSource Table for Network Rule6MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
8GHO_ALC_SRC_TRTheoretical Source data for Allocation results invalidation6MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
9GHO_ALC_SRC_UOMRSource Table for UOM Rule5MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
10GHO_ALERTStore Network Alerts4MEDIUMMediumnvarchar60
11GHO_ALLOC_PREPAllocation Results Header5MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
12GHO_ALLOC_RUN_JBAllocation Results Header5MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
13GHO_DM_ALLOC_RESAllocation Results6MEDIUMMediumnvarchar60
14GHO_DM_RESULTSDeferment Results9MEDIUMMediumnvarchar60
15GHO_FORM_MEAS_HAllocation Formula Measurements Header6MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
16GHO_MEAS_MEDIUMMeasurements mapped with mediums2MEDIUMMediumnvarchar60
17GHO_MEAS_PRIO_HAllocation Rules Measurement Priority Header5MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
18GHO_PPA_DATAPPA request details22MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
19T160IControl of Intrastat Reports4MEDIUMTransport medium for Intrastat datanvarchar10
20T160JText Table for Intrastat Reports5MEDIUMTransport medium for Intrastat datanvarchar10
21VEN000Business Partner: General Vendor Data12MEDIUMTransmission Medium (Printer, Fax, EDI, XML, and so on)nvarchar30
22VIXCESM180DECModelo 180 - Witholding Tax Declarer Line 018MEDIUMType of output mediumnvarchar10
23ZEIMMARAUSING FOR STORING EIM MARA DATAS163MEDIUMMediumnvarchar60
TOPBank Customer Accounts
24BKKCORRITEMAuxiliary Table: Payment Items for Adjustments33MEDIUMMediumnvarchar40
25BKKSOBCA: Standing Orders24MEDIUMMediumnvarchar40
26BKK_PRENOTEPrenotes17MEDIUMMediumnvarchar40
TOPBasic Data
27NC301AIS-HCM: EDI - Obsolete! (Documentation Archive Transfers)9MEDIUMIS-HCM: Medium for data exchange (data carrier type)nvarchar20
28NC301DIS-HCM: EDI - Documentation Archive Transfers11MEDIUMIS-HCM: Medium for data exchange (data carrier type)nvarchar20
TOPCondition
29BKK97Acct Balancing: Posting Data (Temporary Data)(for Deletion)25MEDIUMMediumnvarchar40
30TBKK8CCategorization Medium (Item Counter)3MEDIUMMediumnvarchar40
TOPCross-Application Components
31MMARAGeneral material data163MEDIUMMediumnvarchar60
TOPDay-to-Day Activities
32HRT5048Table Section Infotype 50487MEDIUMOutput Mediumnvarchar40
33LSOCRPCNTXTPRTCLLSO Correspondence: Log Area28MEDIUMOutput Mediumnvarchar40
34LSOCRPCNTXTSTAGELSO Correspondence: Staging Area28MEDIUMOutput Mediumnvarchar40
35LSOCRPCONTROLOutput Control: Delivery Method-Specific6MEDIUMOutput Mediumnvarchar40
36LSOCRPMEDIUMOutput Media Supported1MEDIUMOutput Mediumnvarchar40
37LSOCRPMEDIUMTOutput Media Supported: Texts1MEDIUMOutput Mediumnvarchar40
TOPFSCM In-House Cash
38IHC_DB_CL_TYPESTechnical Settings for AMS Update7MEDIUMMediumnvarchar40
TOPGL transfer
39BKKCNOITGLTable of Items not Updated on the Account15MEDIUMMediumnvarchar40
TOPMaterial Master
40MARAGeneral Material Data163MEDIUMMediumnvarchar60
41MARA_TMPFile for Incorrect Data in Direct Input170MEDIUMMediumnvarchar60
42MVRACross-version fields for MARA163MEDIUMMediumnvarchar60
TOPNetwork Operations
43GHO_OTS_MATGHO Order Template Structure Materials12MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
44GHO_PP_PTABLE_ITItem Table for Results of GHO Planning Table6MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
TOPOwnership
45GHO_OWNDOI_HDRCKDOI Header Details work tabel8MEDIUMMediumnvarchar60
46GHO_OWN_DOI_HDRDOI Header Details8MEDIUMMediumnvarchar60
47GHO_OWN_NET_ASGOwnership (DOI) assignment to Network Objects6MEDIUMMediumnvarchar60
TOPPayment Item
48BKKITPayment Item33MEDIUMMediumnvarchar40
49BKKITAIInfo Items for Interest Penalty at Balancing13MEDIUMMediumnvarchar40
50BKKITENQBlocked Payment Items33MEDIUMMediumnvarchar40
51BKKITRELPayment Item33MEDIUMMediumnvarchar40
52BKKITRETRELPayment Item Return to be released5MEDIUMMediumnvarchar40
53BKKITTMPPlanned Payment Items34MEDIUMMediumnvarchar40
54BKKITTMP_DELPlanned Payment Items - Completed34MEDIUMMediumnvarchar40
55BKKPAYMEX_ITEFT Management: Items in Outgoing Payment Transactions28MEDIUMMediumnvarchar40
56BKKPAYMIN_HDHeader Table of EFT Management Imported Items12MEDIUMMediumnvarchar40
57BKKPAYMIN_ITTable of Imported Items23MEDIUMMediumnvarchar40
58TBKKI1Assignment Medium/Payment Method to Processes3MEDIUMMediumnvarchar40
59TBKKIDFBCA: Defaults for Transaction4MEDIUMMediumnvarchar40
TOPPayment Order
60BKKPOHDPayment Order, Header Data7MEDIUMMediumnvarchar40
61BKKPOHD_TMPPlanned Payment Order, Header Data8MEDIUMMediumnvarchar40
62BKKPOHD_TMP_DELPlanned Payment Order, Header Data8MEDIUMMediumnvarchar40
63BKKPOITItem in Payment Order17MEDIUMMediumnvarchar40
64BKKPOIT_TMPItems in Planned Payment Order18MEDIUMMediumnvarchar40
65BKKPOIT_TMP_DELItems in Planned Payment Order16MEDIUMMediumnvarchar40
TOPPayment Transactions
66BUSPROC_FCT_FIEBFIEB: Function Modules for Business Process1MEDIUMStandard for Payment Transactionsnvarchar100
67GENERAL_EB_FIEBGeneral Customizing Table for Electronic Banking1MEDIUMStandard for Payment Transactionsnvarchar100
TOPPlant Maintenance
68EAMS_SL_NM_LINKSNetwork Modelor Links customization table2MEDIUMMediumnvarchar60
TOPProcess Controls
69GRPCEVENT1AGGREvent Monitoring Aggregation8MEDIUMTotal Deficiency Mediumint100
70GRPCEVENTAGGROBSOLETE Event Monitoring Aggregation9MEDIUMTotal Deficiency Mediumint100
71GRPCVIOLATIONEvent Monitoring: Violations12MEDIUMTotal Deficiency Mediumint100
TOPProduct definition
72TBKKG1Media2MEDIUMMediumnvarchar40
73TBKKG1TText Table for Media3MEDIUMMediumnvarchar40
74TBKKG1_TCODEAssignment Transaction to Medium3MEDIUMMediumnvarchar40
75TBKKG5Assignment Functions Group - Medium, Transaction Type3MEDIUMMediumnvarchar40
76TBKKG7Assignment Blocking Reason - Medium, Transaction Type3MEDIUMMediumnvarchar40
TOPProduction Allocation
77GHO_ALLOCRES_HAllocation Results Header4MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
78GHO_ALLOC_FIN_PPTable to hold PP related final allocation results8MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
79GHO_ALLOC_OVROBSOLETE - GHO Allocation Theoratical Override6MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
80GHO_ALLOC_RES_HOBSOLETE - Table for storing allocation results (Header)4MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
81GHO_ALLOC_RES_PPTable to hold PP related allocation results8MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
82GHO_COM_WC_HCommingled Well Completion Header5MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
83GHO_NODERULE_HNode Allocation Rules Header4MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
84GHO_NODE_DS_SP_HNode Down Stream Split header table5MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
85GHO_NODE_RULE_HOBSOLETE - Node Allocation Rules Header3MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
86GHO_NWRULE_HNetwork Allocation Rules Header4MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
87GHO_NW_RULE_HOBSOLETE - Production Flow Network Allocation Rules Header3MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
88GHO_NW_UOM_RULEOBSOLETE - UoM Rule for Network3MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
89GHO_REP_MATReproduced Material details table4MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
90GHO_RULE_LOG_HAllocation Rule Log Header7MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
91GHO_SIMU_CAPSimulation: Modified network object capacities5MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
92GHO_SIMU_DS_SP_HSimulation: Node Down Stream Split rules header6MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
93GHO_SIMU_FLRT_ISimulation: Flow Rate Item3MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
94GHO_SIMU_NDRHSimulation: Node Allocation Rules Header5MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
95GHO_SIMU_NWRHSimulation: Network Allocation Rules Header5MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
96GHO_SIMU_REP_MATSimulation: Reproduced Material details table4MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
97GHO_SIMU_TOR_HSimulation: Theoretical Override Header7MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
98GHO_SIMU_UOMRHSimulation: Network UoM Rule Header5MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
99GHO_SIMU_WCOM_HSimulation: Commingled Well Completion Header6MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
100GHO_SIMU_WC_OVRSimulation: Well Completion Override Details Table5MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
101GHO_THEO_OVR_HAllocation Theoretical Override Header6MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
102GHO_UOM_RULE_HNetwork UoM Rule Header4MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
103GHO_WC_OVRWell Completion Override Details Table5MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
104GHO_WC_RULE_LOGLog table for Well Completion Override, Reproduce material5MEDIUMProduct on Which Allocation is Performed (Oil, Gas, Water)nvarchar60
TOPPromotion
105RDMT_MEDIUMPromotion Media3MEDIUMPromotion Mediumnvarchar20
106RDMT_MEDIUMTPromotion Media Texts4MEDIUMPromotion Mediumnvarchar20
TOPRecords and Case Management
107RMPS_DISELEMSRetention Elements (Data Record Descriptions)21MEDIUMPaper Form or Electronic Formnvarchar10
TOPSoftware Agent Framework
108CRMD_EI_SOL_CARTEI: Persist user selected solution out of SDB13MEDIUMChannel for Delivering Solutionnvarchar120
109CRMD_SAF_KB_STATSAF: Knowledge entity access statistics8MEDIUMChannel for Delivering Solutionnvarchar120