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

93 columns | Print definition?ERP 6.0  | POSID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000108000PSA for /CPD/PFP_DS_WBS T90CLNT090 DataSource for WBS5POSIDnvarchar240
2/BIC/B0000108001PSA for /CPD/PFP_DS_WBS T90CLNT090 DataSource for WBS5POSIDnvarchar240
3/BIC/B0000109000PSA for /CPD/PFP_DS_WBS_DATE T90CLNT090 DataSource for WBS5POSIDnvarchar240
4/BIC/B0000109001PSA for /CPD/PFP_DS_WBS_DATE T90CLNT090 DataSource for WBS5POSIDnvarchar240
5/BIC/B0000110000PSA for /CPD/PFP_DS_WBS_TEXT T90CLNT090 DataSource for WBS7POSIDnvarchar240
6/BIC/B0000119000Error Stack DTP_00O2TFWN1YKGA5W5VZK10EVE8 00014POSIDnvarchar240
7/BIC/B0000122000Error Stack DTP_00O2TFWN1YKGA5W5VZK10FECW 00014POSIDnvarchar240
8/BIC/B0000225000Error Stack DTP_00O2TFWN1YKGA5W5VZK10FKOG 00015POSIDnvarchar240
9/PLMB/PR_DECProcess Route Decision4POSIDItem Number in Process Routenvarchar50
10/PLMB/PR_GRP_ITMProcess Route Grouping item table4POSIDItem Number in Process Routenvarchar50
11/PLMB/PR_SRVProcess Route Service4POSIDItem Number in Process Routenvarchar50
12/PLMI/PRT_LINEProcess Route Template Line3POSIDItem Number in Process Routenvarchar50
13/PLMI/PRT_TREEtemplate tasks relation tree node3POSIDItem Number in Process Routenvarchar50
14/PLMI/TD_AGT_LSTTeam Definition: Agent List6POSIDItem Number in Process Routenvarchar50
15CMCBD_CONSUMECash Budgeting Consumption38POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
16P2B2_CWSTHCM Declustering B2 - PDC Time Tickets102POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
17P2B2_WSTHCM Declustering B2 - PDC Time Tickets102POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
18P2RD_ZTPayroll Result: Time Data for Reduced Hours Compensation5POSIDRelative day in periodnvarchar20
19P2RD_ZTBAUPayroll Result: Construction Pay Daily Statement5POSIDDay in the monthnvarchar20
20T7CNRM_CHNGCNTNTDetail of Change Management3POSIDSequence Numbernvarchar40
21T7CNRM_GRPDIMGrouping Dimension3POSIDSequence Numbernvarchar40
22T7CNRM_GRPDIMTGrouping Dimension Text4POSIDSequence Numbernvarchar40
23T7CNRM_RPTSTAStatistical Dimension Definition3POSIDSequence Numbernvarchar40
24T7CNRM_RPTSTATStatistical Dimension Name4POSIDSequence Numbernvarchar40
25ZARIXCO1APPREQUEST: Indextabelle zur Selektion von Datenobjekten5POSIDMaßnahmenanforderung externe Darstellungnvarchar240
TOPAppropriation Requests
26ARC_IDX_APPREQIM: Index Table for Archiving Appropriation Requests4POSIDAppropriation Request Number (Formatted for Coding Mask)nvarchar240
27IMAKAppropriation requests - general data4POSIDAppropriation Request Number (Formatted for Coding Mask)nvarchar240
TOPCross-Application Components
28MAAVC_CONFMPO: Confirmations Cumulated on WBS Element1POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
29MAAVC_MDMPO: Individual Master Data for WBS Elements1POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
30MAAVC_MILESTMPO: Milestones for WBS Elements1POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPCustomer Bill of Services
31BOSPS_ASSIGNMENTBOSPS: PS object links to the specified sales document5POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPDelivery Confirmation
32DELCONJITITDelivery Confirmation: Result of Log. Matching - Comp. Group3POSIDComponents Group Numbernvarchar100
TOPESS Based on WD ABAP
33HRESS_D_CATS_FAVCATS Favorites: database table130POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPFlow Manufacturing
34LDLBPLine balance items4POSIDNumeric field: Length 6nvarchar60
35LDLBTLine hierarchy entry and exit takts4POSIDNumeric field: Length 6nvarchar60
TOPGeneric Project Planning
36CGPL_R3_ATTRIBUTR/3 Interface: Attributes of R/3 Shadow Objects3POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPGlobal Trade Services
37/SAPSLL/CUSWLDCustoms Processing: Procedures Completed for Customs Decl.84POSIDInventory Management: Item IDnvarchar60
38/SAPSLL/CUSWLFCustoms Worklist: Domestic Issues - Completed Transactions40POSIDInventory Management: Item IDnvarchar60
39/SAPSLL/CUSWLOWorklist for Transactions with Reference to Delivery or PO91POSIDInventory Management: Item IDnvarchar60
TOPInterface to External Project Software
40PRGUIDGUIDs for WBS Element4POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPInvestment Programs
41IMPRInvestment Program Positions4POSIDIdentification for an investment program positionnvarchar240
42IMPZInvestment Program Positions4POSIDIdentification for an investment program positionnvarchar240
43TAI02Editing Masks for CI Program Positions3POSIDEditing mask for cap.inv.program position codingnvarchar240
TOPJust-In-Time Processing
44JITCOCall components2POSIDComponents Group Numbernvarchar100
45JITITComponents Group2POSIDComponents Group Numbernvarchar100
46JITLOLock Table for Lock Object E_JITL01 (Dummy)4POSIDComponents Group Numbernvarchar100
47JITOITComponents Group JIT Outbound4POSIDComponents Group Numbernvarchar100
48JITTEJIT : Texts / Additional Data for JIT Call3POSIDComponents Group Numbernvarchar100
TOPLocalization
49J_3RNDSINVTarget use of ingoing invoice positions for AuC14POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPMaintenance Orders
50/CUM/CONMSCU: Construction Measure Master Data9POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
51/CUM/CUDESIGNCU: Design Header Data17POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
52/MRSS/D_SQM_KPQualification Catalog: Items3POSIDQualification Numbernvarchar100
53/MRSS/D_SQM_KPFQualification Catalog: Person-Specific Filter4POSIDQualification Numbernvarchar100
54/MRSS/D_SQM_KPOQualification Catalog: Organization-Specific Filter5POSIDQualification Numbernvarchar100
55/MRSS/D_SQM_KPTQualification Catalog: Item Texts3POSIDQualification Numbernvarchar100
TOPMarketing Retail Network
56OIFOPROJObject links - PS project or project item (IS-Oil MRN)13POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPMedia Product Sales and Distribution
57TJVSDSHPOPTIMOptimization Methods in Shipping Plan5POSIDSort Sequence of Optimization Methods in Shipping Schedulenvarchar30
58TJVSDSHPSTEPShipping Schedule, Other Functions4POSIDSort Sequence for Additional Functions in Shipping Schedulenvarchar30
59TJVSDSHPZFILTERAssignment of Filters to Filter Groups in Shipping Plan4POSIDSort Sequence for Filters in Shipping Plannvarchar30
60TJVSDWL_ADDINOptimization Methods in Shipping Worklist2POSIDSort Sequence for Optimization Methods in Shipping Worklistnvarchar50
TOPOperative Structures
61NHPRPSNumber history for reorganization of WBS elements4POSIDWork breakdown structure element (WBS element)nvarchar400
62PRPSWBS (Work Breakdown Structure) Element Master Data3POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
63TCJEDTable for Project Number Editing3POSIDMask for coding project definition and WBS elementnvarchar240
TOPPersonnel Time Events
64TPTCOR_KOSTLCost Assignment (Correction Scenario)5POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPPersonnel Time Management
65CC1ERPIncorrect Time Events from CC1, Postings104POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
66CC1TEVTemporary Buffer for Time Events from CC127POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
67TEVEN_MOREAdditional Data for Time Events103POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPPlanned Costs
68CNFOWWBS_CI_TABCustomer Table for WBS2POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPProduct Configurator
69COMM_CFGCLPARTDecomposition Item4POSIDClass positionsmallint50
70COMM_CFGCLPRECClass Precedence List4POSIDClass positionsmallint50
71COMM_CFGPRTDEPDependencies that are attached to BOM positions4POSIDInternal identifier of a model elementint100
TOPProduct Safety
72CVDDCSEHS: Control Structure (Report Shipping)23POSIDReference Identifier of Ins. Cont. Log.: Instance, Positionnvarchar60
73ESTDCSEHS: Control Structure (Report Body)23POSIDReference Identifier of Ins. Cont. Log.: Instance, Positionnvarchar60
74ESTDSCSEHS: eSDS Control Structure24POSIDReference Identifier of Ins. Cont. Log.: Instance, Positionnvarchar60
TOPProject Summarization
75PSERBInheritance data, Project System4POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPProject System
76PSHLPDB_HIER_TMPTable to store temporary hierarchy data10POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
77PSHLP_DRAFT_DBTable holds Draft Workbench Information6POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
78PSHLP_DRAFT_DB_NTable holds Draft Workbench Information6POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
79PSHLP_HIER_DBLocal cache:Project/Independent Network hierarchy10POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPRecords and Case Management
80RMPSPATHFIELDSProcess Route Fields for Public Services4POSIDItem Number in Process Routenvarchar50
TOPSales and Distribution
81SCECLPRECPrecedence List for OO Classes4POSIDInternal counter for objects in an SCE knowledge basenvarchar60
82SCEHASPRTComponents of Decomposition (BOM and so on)4POSIDInternal counter for objects in an SCE knowledge basenvarchar60
83SCEPRTDEPAssignment of Dependencies to Components (of BOM)4POSIDInternal counter for objects in an SCE knowledge basenvarchar60
TOPSAP Records Management
84SRMDPOBJPTCircular - Object Log4POSIDItem Number in Process Routenvarchar50
85SRMWFPTHFIELDSAdditional Customer-Specific Fields in Process Route4POSIDItem Number in Process Routenvarchar50
86SRMWFPTHPSProcess Route Item for Workflow4POSIDItem Number in Process Routenvarchar50
TOPSCM Basis
87CIFPOMAPMapping Table NR/POS/ET <-> APO GUID (Purch. Ord. Docs)8POSIDGUID for Itemsvarbinary160
TOPService Station Retailing
88OIRBOPROJObject links - PS project or project item (IS-Oil SSR)14POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPSimulation
89VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data4POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPStructures
90PSHLP_WBSWL_DBWBS Elements ACL Worklist3POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPTemplates
91PRPSSStandard WBS Element (WBS element) - Master Data3POSIDWBS element in standard projectnvarchar240
TOPTime Sheet
92CATS_TEMPCATS: Database Table for Templates80POSIDWork Breakdown Structure Element (WBS Element)nvarchar240
TOPTranslation Tools
93LXE_DOMA_PDomains1POSIDText Line with 80 Charactersnvarchar800