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

42 columns | Print definition?ERP 6.0  | ORIGINAL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XFT/MIG_CUSTT1Customizing Ablagestrategien6ORIGINALOriginalnvarchar10
2J_8AMTATYPIXOS-ARCHIVE Office Archiving, Target format determination4ORIGINALarchive Original and e.g. Tiff - Old Version, don't usenvarchar10
3SCPLT_REMAKERemakes - Allows "Destructive" Multi-Layering in Screenplay2ORIGINALOriginal of a Remakenvarchar300
TOPAudit trail enhancements ILM
4AUT_C_DTELLOGAudit Trail (ILM): Customizing Change Document Creation3ORIGINALAudit Trail (ILM): Original Status Ind. Change Documentsnvarchar10
5AUT_C_TABLOGAudit Trail (ILM): Customizing of Table Logging3ORIGINALAudit Trail (ILM): Original Status of Table Logging Flagnvarchar10
TOPBusiness Navigator
6DF16LGroups13ORIGINALReference Groupnvarchar200
7DF52LFilter3ORIGINALFilternvarchar200
TOPClinical System
8N2RL_FIRMAIS-H*MED: Rote Liste Firma4ORIGINALntext10737418230
9N2RL_GLIEDERIS-H*MED: Rote Liste Gliederungsthemen4ORIGINALntext10737418230
10N2RL_PRAEPIS-H*MED: Rote Liste Name der Präperate4ORIGINALntext10737418230
11N2RL_SIGNS4ORIGINALntext10737418230
12N2RL_STOFFEIS-H*MED: Rote Liste Stoffe4ORIGINALntext10737418230
13N2RL_STWSIS-H*MED: Rote Liste Stoffwechselwirkungen4ORIGINALntext10737418230
TOPCross-Application Components
14J_8A3T0015target format determination4ORIGINALarchive also original documentnvarchar10
TOPDistribution Unit Distribution Packet
15DSPHDRALE Distribution Packet : Header data7ORIGINALOwner of Original Packet : Original Packet Numbernvarchar200
16UPSHDRALE Distribution Unit: Header Data7ORIGINALOwner of Original Packet : Original Packet Numbernvarchar100
TOPDocument Management System
17DRZADDS: Recipient list (document <-> recipient allocations)11ORIGINALOriginalsnvarchar40
18DRZOCDDS: partial order10ORIGINALOriginalsnvarchar40
19TDIBPDDS: context7ORIGINALOriginalsnvarchar40
TOPElectronic Data Records
20AUTDTELLOGCustomizing for Change Document Creation3ORIGINALOriginal Status of Indic. for Creation of Change Documentsnvarchar10
21AUTTABLOGCustomizing for Table Logging3ORIGINALOriginal Status of Indicator for Table Loggingnvarchar10
TOPIncentive and Commission Management ICM
22TCACS_MAPLC1Names of Locally Copied Structures of Other Systems1ORIGINALTable Namenvarchar300
23TCACS_MAPLC2Names of Locally Copied Data Elements of Other Systems1ORIGINALData element (semantic domain)nvarchar300
TOPPortfolio Management
24/RPM/CAP_B_CATDemand planning for bucket categories8ORIGINALOriginal flagnvarchar10
25/RPM/CAP_B_GROUPDemand planning bucket category groups9ORIGINALOriginal flagnvarchar10
26/RPM/CAP_CATDemand Planning Category8ORIGINALOriginal flagnvarchar10
27/RPM/CAP_GROUPxRPM Demand planning group object9ORIGINALOriginal flagnvarchar10
28/RPM/FIN_B_CATFinancial planning for bucket categories8ORIGINALOriginal flagnvarchar10
29/RPM/FIN_B_GROUPFinancial planning bucket category groups9ORIGINALOriginal flagnvarchar10
30/RPM/FIN_CATFinancial Category8ORIGINALOriginal flagnvarchar10
31/RPM/FIN_GROUPxRPM Financial Group Object9ORIGINALOriginal flagnvarchar10
32RPM_CAP_B_CAT_CDBucket demand category - Pseudo table for change documents8ORIGINALOriginal flagnvarchar10
33RPM_CAP_B_GRP_CDBucket demand groups - Pseudo table for change docu9ORIGINALOriginal flagnvarchar10
34RPM_CAP_CAT_CDDemand Planning Category- Pseudo table for change documents8ORIGINALOriginal flagnvarchar10
35RPM_CAP_GRP_CDDemand planning groups - Pseudo table for change documents9ORIGINALOriginal flagnvarchar10
36RPM_FIN_B_CAT_CDBucket Financial Categories - Pseudo table for change docu8ORIGINALOriginal flagnvarchar10
37RPM_FIN_B_GRP_CDBucket financial groups - Pseudo table for change docu9ORIGINALOriginal flagnvarchar10
38RPM_FIN_CAT_CDFinancial Category - Pseudo table for change documents8ORIGINALOriginal flagnvarchar10
39RPM_FIN_GRP_CDFinancial Group Object - Pseudo table for change documents9ORIGINALOriginal flagnvarchar10
TOPReal Estate Management
40VICN03Real Estate Contract: Posting Distribution9ORIGINALSingle-Character Indicatornvarchar10
TOPStructural Graphics
41T777NAME2CHR Namespace: Software Components of the Systems6ORIGINALOriginalnvarchar10
TOPTranslation Tools
42DXLFT_ORIGXLIFF Originals3ORIGINALBLOBimage21474836470