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

41 columns | Print definition?ERP 6.0  | ORDER_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BOFU/D_BFI_ROOT3ORDER_IDnvarchar300
2CNVTDMS_05_BAPCFill header table for Posting Control Order3ORDER_IDContract Part IDvarbinary160
3CNVTDMS_05_BPOFill Header to store Business Process Orders3ORDER_IDRAW16 for TDMSvarbinary160
4CNVTDMS_05_ORDERFill header table for Postprocessing Order3ORDER_IDContract Part IDvarbinary160
5CNVTDMS_11_SAMP3Sample table 3 for TDMS demo package - Rules Platform3ORDER_IDCommentnvarchar500
6JVTDPAMPROTIS-M/SD: Log Data for DPAG Order Management4ORDER_IDIS-M: Sales Order Numbernvarchar170
7WB2_C_BVTAB_ADDRebates: Business Volume Tables - additional tables5ORDER_IDCCS: Order ID for Business Volume Tablesnvarchar20
8ZPH_RESS_STATUSStatus table for resources (Logbook)6ORDER_IDOrder Numbernvarchar120
TOPAccounts Receivable Accounting Process Integration
9EBPP_ORDER_HDRZahlungsanweisungen über EBPP: Kopfdaten6ORDER_IDText field length 14nvarchar140
10EBPP_ORDER_ITMPayment Orders via Biller Direct: Items6ORDER_IDText field length 14nvarchar140
11EBPP_ORDER_PAYPayment Orders via Biller Direct: Payment Data6ORDER_IDText field length 14nvarchar140
TOPClassification System New
12COMM_IL_SCPCHRDefinition Scope -> Characteristic13ORDER_IDPosition of Characteristic Within Definition Scopenvarchar50
13COMM_IL_SCPCHR_HChange Graph for History Table14ORDER_IDPosition of Characteristic Within Definition Scopenvarchar50
TOPClinical System
14N1POPAKTEIS-H*Med: Patient Organizer - Redundant Structure68ORDER_IDKey of Physician Ordernvarchar330
15N2PHYO_ORDERPhysician Order2ORDER_IDKey of Physician Ordernvarchar330
TOPEnterprise SOA
16BSSOA_IAS_QUEUEInApplicationSequencing: Waiting Queue6ORDER_IDOrder IDvarbinary160
TOPGenerating, Monitoring for Mass Data Archiving Solutions
17AFX_OBJDATA_KEYKey Terms for Generated Runtime Data3ORDER_IDSorting ID for Object Datanvarchar30
18AFX_OBJDATA_TYPKey Categories for Generated Runtime Data2ORDER_IDSorting ID for Object Datanvarchar30
TOPMaintenance Processing
19ALM_ME_SIG_LINKMAM Signature to Order Link2ORDER_IDOrder Numbernvarchar120
TOPManagement of Internal Controls
20FOPC_AU_METABAP Unit Methods6ORDER_IDSequencenvarchar20
21FOPC_AU_RES_RESABAP Unit Restrictions - Restriction Code4ORDER_IDSequencenvarchar20
TOPMaterial Master
22WGDS_DIRECTORYDirectory where information about storage entries ar stored.2ORDER_IDOrder idvarbinary160
TOPPersonnel Categories
23PA0806Personnel Master Record for Infotype 080628ORDER_IDOrder Numbernvarchar120
TOPPersonnel Time Management
24PTARQ_EXTRA_INFOLeave Request: Additional Fields for Attendances/Absences7ORDER_IDOrder Numbernvarchar120
TOPPostprocessing Office
25/SAPPO/ORDER_DATAdditional Data for Postprocessing Order3ORDER_IDOrder IDvarbinary160
26/SAPPO/ORDER_HDRPostprocessing Order - Header Data2ORDER_IDOrder IDvarbinary160
27/SAPPO/ORDER_MSGMessages for Postprocessing Order2ORDER_IDOrder IDvarbinary160
28/SAPPO/ORDER_OBJRelated Objects for Postprocessing Order2ORDER_IDOrder IDvarbinary160
TOPProcess Controls
29GRPC_AU_METABAP Unit Methods6ORDER_IDSequencenvarchar20
30GRPC_AU_RES_RESABAP Unit Restrictions - Restriction Code4ORDER_IDSequencenvarchar20
TOPProcess Monitoring Infrastructure
31SSPIDEMOORDARTICPMI Demo: Orders2ORDER_IDPMI Demonstration: Order IDnvarchar40
32SSPIDEMOORDERPMI Demo: Orders2ORDER_IDPMI Demonstration: Order IDnvarchar40
33SSPIDEMOSHIPMENTPMI Demo: Shipment3ORDER_IDPMI Demonstration: Order IDnvarchar40
TOPReusable Components of Business Suite Foundation
34/BOBF/DM_SORD_RTSales Order Header4ORDER_IDSales Order Nonvarchar300
35/BOFU/DDMOSORDHDSales Order Header4ORDER_IDSales Order Nonvarchar300
36/BOFU/DEM_D_ROOT4ORDER_IDSales Order Nonvarchar300
37/BOFU/DTSTSORDHDSales Order Header3ORDER_IDSales Order Nonvarchar300
38/BOFU/SO_BUPA_RTSales Order Business Partner Root Table4ORDER_IDnvarchar300
39/BOFU/TEST_ADMINAdmin Data4ORDER_IDnvarchar100
TOPServices
40FINB_RP_CONFIG2Customizing for Fields in Reporting8ORDER_IDNatural Numberint100
TOPWorkforce Management Core
41WFDSD_DEMANDWork Force Deployment Demand6ORDER_IDBusiness Transaction Numbernvarchar100