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

63 columns | Print definition?ERP 6.0  | SOURCE_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/D_MP_TEAM_RTeam Role Subnodes7SOURCE_IDSource IDnvarchar400
2BBPD_CMS_DOCCMS Documents40SOURCE_IDCMS Document IDnvarchar100
3CMCBD_BRF_LINKSCash Budget Workflow Node Links for BRF+4SOURCE_IDInternal ID number of a hierarchy nodenvarchar80
4CMCBD_CONSUMECash Budgeting Consumption30SOURCE_IDCash budget integration sourcenvarchar10
5CMCBD_WF_LINKSCash Budgeting Workflow Node Links for Positions3SOURCE_IDInternal ID number of a hierarchy nodenvarchar80
6DOCRP_FLDBMPDBOS Cockpit: CRP: Source Field3SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
7DOCRP_SOURCEDBOSC: CBR: CIM Data Source3SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
8DOCRP_SRCBMPDBOSC: CBR: CIM Data Source3SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
9DODP_MAP_SOURCEDBOSC-DP: Map Data Provider to Data Source6SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
10DORAN_FIELDDBOSC-RAN: Data Source Field4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
11DORAN_SOURCEDBOSC-RAN: Request Processor for All - Native4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
12DORDS_ACCESSDBOSC-DRS: Request Process Database SQL Access4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
13DORDS_ANSIJOINDBOSC-RDS: Request Process Database SQL Virtual4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
14DORDS_FIELDDBOSC-RDS: Reques Process DB SQL Data Source Field4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
15DORDS_FUNCTIONDBOSC-DRS: Request Process Database SQL Function4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
16DORDS_INVIEWDBOSC-DRS: Request Process Database SQL Inlined View4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
17DORDS_JOIN_CONDDBOSC-DRS: Request Process Database SQL Join Condition4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
18DORDS_JOIN_EQDBOSC-RDS: Reques Process DB SQL Data Source Join Field EQ4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
19DORDS_JOIN_PARTDBOSC-DRS: Request Process Database SQL Join parts4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
20DORDS_OPTIONDBOSC-DRS: Request Processor Database Option4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
21DORDS_PARAMETERDBOSC-RDS: Request Process DB SQL Parameter4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
22DORDS_SETDBOSC-DRS: Request Process Database SQL Virtual4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
23DORDS_SET_EQDBOSC-RDS: Reques Process DB SQL Data Source Set Field EQ4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
24DORDS_SET_PARTDBOSC-DRS: Request Process Database SQL Set parts4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
25DORDS_SET_UNITEDBOSC-DRS: Request Process Database SQL Set combination4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
26DORDS_SOURCEDBOSC-RDS: Reques Processor DB SQL Data Source4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
27DORDS_TABLEDBOSC-DRS: Request Process Database SQL Table4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
28DORDS_VIRTUALDBOSC-DRS: Request Process Database SQL Virtual4SOURCE_IDDBOSC-CR: Generated ID (30)nvarchar300
29FIEUD_SBINV_HSAFT: Self Billing Invoices (Header)- (MM)27SOURCE_IDSAFT PT: Source ID (User Name)nvarchar300
30FIEUD_SDINV_HSAFT: Invoices from SD module(Header)25SOURCE_IDSAFT PT: Source ID (User Name)nvarchar300
31GRFNPOLICYSOURCEDB table for policy source in Policy management3SOURCE_IDPolicy Source IDnvarchar500
32HRP5058DB Table for Infotype 505820SOURCE_IDID of Related Objectnvarchar450
TOPApplication Frame
33CRMC_UI_CMP_OP_TComponent Outbound Plug Definition.3SOURCE_IDOutbound Plug Source IDnvarchar100
34CRMC_UI_CMP_PLUGDefine Specific Outbound Plug Mapping5SOURCE_IDOutbound Plug Source IDnvarchar100
35CRMC_UI_COMP_OPComponent Outbound Plug Definition3SOURCE_IDOutbound Plug Source IDnvarchar100
TOPAuthentication and SSO
36SAML2_ARTIFACTStorage Table for SMAL2 Artifacts4SOURCE_IDHash Value of the SAML2 Entity Namevarbinary200
TOPBRFplus - ABAP-Based Business Rules
37FDT_EXPR_1601FDT: Expression - FDT Function Call Context Mapping5SOURCE_IDFDT: Universal Unique Identifiernvarchar320
38FDT_EXPR_1601AFDT: Expression - FDT Function Call Context Mapping5SOURCE_IDFDT: Universal Unique Identifiernvarchar320
39FDT_EXPR_1601SFDT: Expression - FDT Function Call Context Mapping4SOURCE_IDFDT: Universal Unique Identifiernvarchar320
40FDT_EXPR_1601TFDT: Expression - FDT Function Call Context Mapping4SOURCE_IDFDT: Universal Unique Identifiernvarchar320
TOPBusiness Partner
41FSBP_CC_MAP_BKDTTable for Mapping Bank Detail IDs in Cleansing4SOURCE_IDBank details IDnvarchar40
42FSBP_CC_MAP_PAYCTable for Mapping Payment Card IDs in Cleansing4SOURCE_IDPayment Card IDnvarchar60
TOPCross-Application Components
43ZGADGETS_CONFIGGadgets Page Configuration for NWBC4SOURCE_IDObject Entry Source IDnvarchar10
44ZGADGETS_CUSTURL Maintenance for Gadgets5SOURCE_IDObject Entry Source IDnvarchar10
45ZGADGETS_URLSURL Maintenance for Gadgets4SOURCE_IDObject Entry Source IDnvarchar10
46ZGAD_CONFIG_CUSTGadgets Page Configuration for NWBC5SOURCE_IDObject Entry Source IDnvarchar10
47ZPAGE_LAYOUTGadgets Page Layout Configuration2SOURCE_IDObject Entry Source IDnvarchar10
TOPData Conversion
48DMC_COBJDMC: Conversion Object29SOURCE_IDMWB: Source Object IDnvarchar50
TOPData Warehousing Workbench
49RSGMDDMODLINKSLinks in the Data Models3SOURCE_IDInternal Node ID of a Node in the Data Modelint100
TOPECM ABAP Stack
50NWECMD_RELATIONSnwecm: persistent representation of relations3SOURCE_IDGlobally Unique Identifiervarbinary160
TOPInteraction Center WebClient
51CRMC_IC_ACTPROFSActivity Clipboard Additional Sources Definitions3SOURCE_IDSource IDnvarchar100
52CRMC_IC_ACTSRCActivity Clipboard Additional Sources Definitions2SOURCE_IDSource IDnvarchar100
TOPMaintenance Orders
53/MRSS/D_ADDRESSStores Primary/Secondary address18SOURCE_IDGeolocation Data Source ID/Geocoder IDnvarchar40
54/MRSS/D_TOUR_ATTAttributes of Tour (Centroid)10SOURCE_IDGeolocation Data Source ID/Geocoder IDnvarchar40
TOPPerishables Procurement
55FIP_D_ORDER_LINEOrder lines for FIP6SOURCE_IDAccount Number of Vendor or Creditornvarchar100
TOPProcess Controls
56GRPCRISKASSRisk Data5SOURCE_IDGRPC ID of the individual objectnvarchar500
TOPPurchasing
57EKPOPurchasing Document Item360SOURCE_IDOrigin Profilenvarchar30
58WRFT_POHF_SOURCEValue Table for Source ID2SOURCE_IDOrigin Profilenvarchar30
59WRFT_POHF_SRC_TXValue Table Source ID Texts3SOURCE_IDOrigin Profilenvarchar30
60WRF_POHF_POLOrder list60SOURCE_IDOrigin Profilenvarchar30
TOPStatus and Action Management
61SAMDT_RELATIONSS&AM DT Relation5SOURCE_IDS&AM GUIDnvarchar320
TOPTools
62HRPYO_D_DEPCYSchedule Dependency2SOURCE_IDEntity Idnvarchar320
TOPWithout Description
63RSDMESCGENERATEDGenerated Objects for Scoring Models2SOURCE_IDSource GUIDnvarchar320