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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

63 columns | Print definition?ERP 6.0  | DELFLAG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PLMI/PRT_LINEProcess Route Template Line13DELFLAGIndicator, Whether Process Route Item Was Deletednvarchar10
2/PLMI/PRT_MAPglobal template and local template mapping7DELFLAGIndicator, Whether Process Route Item Was Deletednvarchar10
3/PLMI/PRT_RELSPredecessor-Successor Relations of Process Route Items5DELFLAGIndicator, Whether Process Route Item Was Deletednvarchar10
4/PLMI/PRT_TREEtemplate tasks relation tree node6DELFLAGIndicator, Whether Process Route Item Was Deletednvarchar10
5CNVCMIS_A_1_MCIDMCID type Repository Analysis13DELFLAGDeletion flagnvarchar10
6SCI_HANA_TEST1Katalog der Repository-Objekte17DELFLAGLöschungskennzeichennvarchar10
7SCI_HANA_TEST2single records buffering17DELFLAGLöschungskennzeichennvarchar10
8SCI_HANA_TEST2Ageneric buffering17DELFLAGLöschungskennzeichennvarchar10
9SCI_HANA_TEST2Bfully buffered17DELFLAGLöschungskennzeichennvarchar10
10SCI_HANA_TEST2Csingle records buffering17DELFLAGLöschungskennzeichennvarchar10
11SCI_HANA_TEST3buffering allowed but turned off17DELFLAGLöschungskennzeichennvarchar10
12TSCITKatalog der Repository-Objekte17DELFLAGLöschungskennzeichennvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
13DBDCGENTBDD: Persisting Activating Ojects in Mass Activation27DELFLAGnvarchar10
14DD23LMatchcode ID10DELFLAGDeletion flagnvarchar10
15TSPDDTable, Old SAP Version6DELFLAGFlag: Was field deleted by SAP?nvarchar10
16TSPDD2Table, Old SAP Version6DELFLAGFlag: Was field deleted by SAP?nvarchar10
TOPClinical System
17N2GL_ACTpathways Activity25DELFLAGDeletion Indicatornvarchar10
18N2GL_ACT_NOTEPathways: Comment on Activity16DELFLAGDeletion Indicatornvarchar10
19N2GL_DIApathways Diagnosis String for Pathways Proposal8DELFLAGDeletion Indicatornvarchar10
20N2GL_GUIDELINEpathways Treatment Pathway43DELFLAGDeletion Indicatornvarchar10
21N2GL_PROCIS-H*MED: Procedure String of a Pathway for Assignment8DELFLAGDeletion Indicatornvarchar10
22N2GL_TM_SCHEDULEpathways Patient Pathway48DELFLAGDeletion Indicatornvarchar10
23N2GL_TM_STEPpathways Step of Patient Pathway43DELFLAGDeletion Indicatornvarchar10
24TN2CATCategories: Categories in Category Set15DELFLAGDeletion Indicatornvarchar10
25TN2CATAREACategories: Category Areas10DELFLAGDeletion Indicatornvarchar10
26TN2CATCCategories: Categories for End Users11DELFLAGDeletion Indicatornvarchar10
27TN2CATCMCategories: Main Categories10DELFLAGDeletion Indicatornvarchar10
28TN2CATCONTCategories: Category Container12DELFLAGDeletion Indicatornvarchar10
29TN2CATSETCategories: Category Set12DELFLAGDeletion Indicatornvarchar10
30TN2PDCS2OEIPPD: Assignments: SET - OU - Occupational Group13DELFLAGDeletion Indicatornvarchar10
TOPComplaints and Returns
31/SPE/INSPECRESCInspection Outcome: Item Codes11DELFLAGInspection Outcome: Delete flagnvarchar10
32/SPE/INSPECRESHInspection Outcome: Header14DELFLAGInspection Outcome: Delete flagnvarchar10
33/SPE/INSPECRESPInspection Outcome: Item6DELFLAGInspection Outcome: Delete flagnvarchar10
TOPConfiguration management
34IBINCMIB: Config.Mang.: Component/Instance6DELFLAGYes/No (X/ )nvarchar10
35IBSPCMIB: Config.Mang.: Specialization6DELFLAGYes/No (X/ )nvarchar10
36IBSTCMIB: Conf.Mang.:Structure6DELFLAGYes/No (X/ )nvarchar10
TOPData Basis
37RSLPO_DFG_DTPGENTable of Generated DTPs10DELFLAGBooleannvarchar10
TOPData Staging
38RSAFORMMAPMapping Formula External/Internal GUID4DELFLAGDeletion Flag BW Formulanvarchar10
39RSTSODSPARTPartitioning Information5DELFLAGDeletion indicatornvarchar10
TOPDistributed Maintenance
40/ISDFPS/PMDISEQDistributed Maintenance - Dismantled Equipment8DELFLAGDeletion Indicatornvarchar10
41/ISDFPS/PMDISFLDistributed Maintenance - Dismantled Functional Locations9DELFLAGDeletion Indicatornvarchar10
TOPDocument Management System
42DRADDocument-Object Link15DELFLAGDeletion indicator: object linknvarchar10
TOPExpenditure Certification
43FMEUFFNSFinancing Source35DELFLAGLogical Deletion Indicatornvarchar10
44FMEUFOPHDefine Operation Header11DELFLAGLogical Deletion Indicatornvarchar10
45FMEUFRUNCertification Run Parameter30DELFLAGLogical Deletion Indicatornvarchar10
TOPFlexible Real Estate Management
46VILUROCTODOLUM: To-Do-Liste zum Veränderungsnachweis8DELFLAGLöschvormerkung To-do VNnvarchar10
TOPInstalled Base
47IBINIB: IBase Components - Condition6DELFLAGYes/No (X/ )nvarchar10
48IBINOWNIB: Owner of an IBase Component5DELFLAGYes/No (X/ )nvarchar10
49IBSPIB: Installed Base Component - Enhancement/Specialization6DELFLAGYes/No (X/ )nvarchar10
50IBSTIB: Installation Component - Structure6DELFLAGYes/No (X/ )nvarchar10
TOPMaterial Master
51WRF_PRGRPPrice Level Groups9DELFLAGDeletion Flag for Price Level Groupnvarchar10
52WRF_PRGRPLEVELSPrice Levels of a Price Pattern8DELFLAGDeletion Flag Price Levelnvarchar10
53WRF_PRGRPSCHEMAPrice Pattern7DELFLAGDeletion Flag Price Patternnvarchar10
TOPMonitoring
54ALPERFDBAlert: Performance database16DELFLAGMonitoring infra. perf DB record statusnvarchar10
55ALPERFDB_CAlert: Performance Database14DELFLAGMonitoring infra. perf DB record statusnvarchar10
TOPPatient Management
56TN1TC_OU_RESP_OUTreatment Contract - OU Constellations for OU Jurisdiction6DELFLAGDeletion Flag/Indicatornvarchar10
TOPProcess Monitoring Infrastructure
57SSPICSTRHEADSPI: Central Store Tracking Records Header25DELFLAGSPI: Deletion Indicatorvarbinary10
TOPProduction Orders
58DRAD_PORDERAttributes for Links: Document to Production Order23DELFLAGDeletion indicator: object linknvarchar10
TOPSales and Distribution
59SCEKBOBJKnowledge-Base Object (SCE)11DELFLAGDeletion Indicatornvarchar10
TOPSAP Records Management
60SRMWFPTHPSProcess Route Item for Workflow17DELFLAGIndicator, Whether Process Route Item Was Deletednvarchar10
TOPService Implementation Workbench
61TSIW_TEST_TABTest Table for SIW Mass TABU Producer18DELFLAGDeletion Flagnvarchar10
TOPTransport Organizer
62KTADIRDirectory of Repository Objects18DELFLAGDeletion Flagnvarchar10
63TADIRDirectory of Repository Objects18DELFLAGDeletion Flagnvarchar10