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

85 columns | Print definition?ERP 6.0  | KUNWE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010MIItems for Class SD01 - Raw Data89KUNWEShip-to partynvarchar100
2A968Material/Plant/Ship-to6KUNWEShip-to partynvarchar100
3CE1PR22Périm. résultat IDES71KUNWERéceptionnaire de marchandisesnvarchar100
4CE2PR22Périm. résultat IDES55KUNWERéceptionnaire de marchandisesnvarchar100
5CE4PR22Périm. résultat IDES40KUNWERéceptionnaire de marchandisesnvarchar100
6CE4PR22_ACCTPérim. résultat IDES41KUNWERéceptionnaire de marchandisesnvarchar100
7CE4PR22_FLAGPérim. résultat IDES37KUNWEFlag : caract. imputée manuellement ou via TKEZUnvarchar10
8CE4PR22_KENCPérim. résultat IDES39KUNWERéceptionnaire de marchandisesnvarchar100
9CNVTDMS_05_J3AVAFill Header for AFS - J_3_AVA*7KUNWEBELNR for CNVTDMS_05_*nvarchar100
10KOTP511Material/Plant/Route/Ship-to pt/Ship.type/Stor. Loc./Door7KUNWEShip-to party for packing instruction determinationnvarchar100
TOPBasic Functions
11VETVGDelivery Due Index for Stock Transfer8KUNWEShip-to partynvarchar100
TOPBilling
12A146Customer Hierarchy12KUNWEShip-to partynvarchar100
13A147Customer Hierarchy (Sales Deal)12KUNWEShip-to partynvarchar100
14A149Customer-dependent data determination8KUNWEShip-to partynvarchar100
TOPConditions
15A371Country/Plant/Ctrl code/Ship-to7KUNWEShip-to partynvarchar100
16A801Sales Org/ Dis Channel/Ship-to Party6KUNWEShip-to partynvarchar100
17A910Sales org./Distr. Chl/Ship-to/Incoterms/Inco. 26KUNWEShip-to partynvarchar100
18A936Sales org./Distr. Chl/Shpg Cond./Incoterms/Plant/Ship-to9KUNWEShip-to partynvarchar100
19B028Ship-to party/shipping mat.4KUNWEShip-to partynvarchar100
TOPConsumption-Based Planning See Also PP-MRP
20EDMMSAssignment of EDI partner to purchasing org. and plant4KUNWEShip-to party at customer, transferred via EDI by vendornvarchar200
TOPContract Accounts Receivable and Payable
21FKK_JFRP_SHORTItem Data for IS-M/SD Billing Document - Extracts19KUNWEShip-to partynvarchar100
TOPEmpties Management
22/BEV1/EMLGBSDCustomer Empties Stock per Month8KUNWEShip-to partynvarchar100
23/BEV1/EMLGBWDPEmpties Movement Account Customer11KUNWEShip-to partynvarchar100
TOPExcise Duty
24/BEV2/CS_HDEMCS Process: Header Data8KUNWEShip-to partynvarchar100
25/BEV2/CS_HD_HEMCS Process: Header Data - History9KUNWEShip-to partynvarchar100
TOPInventory Management
26MWXVM07MFields: Update Control of Module Pool SAPMM07M176KUNWEShip-to-party for delivery for WMSnvarchar100
27MWZVM07MFields: Update Control of Module Pool SAPMM07M176KUNWEShip-to-party for delivery for WMSnvarchar100
TOPLocalization
28J_1IEXCHDRExcise invoice header detail27KUNWEShip-to partynvarchar100
29J_1ILICHDRExcise Bonding: License Header10KUNWEShip-to partynvarchar100
30J_3RSCCDHEADERCargo Customs Declaration Header17KUNWEShip-to Partynvarchar100
TOPLogistics - General
31A192Country/Goods Rec./StCla-Mat5KUNWEShip-to partynvarchar100
TOPMaster data
32KOTP003Material/Ship-To Party/Unloading Point5KUNWEShip-to partynvarchar100
33KOTP004Material/Ship-To Party/Shipping Type5KUNWEShip-to partynvarchar100
34KOTP100Material/ship-to party5KUNWEShip-to party for packing instruction determinationnvarchar100
35KOTP110Material/Ship-To Party/Use5KUNWEShip-to party for packing instruction determinationnvarchar100
TOPMedia Sales and Distribution
36/NAM/JKDISPATCHDispatching object12KUNWEIS-M: Business Partner Ship-to Partynvarchar100
TOPPeriodical Sales and Distribution
37JKAPSales Order - Item Data10KUNWEIS-M: Business Partner Ship-to Partynvarchar100
38JKAP_INACTIVEPublishing Sales Order: Inactive Item Data12KUNWEIS-M: Business Partner Ship-to Partynvarchar100
39JKWWWTEMP_GIFTIS-M: Internet Temporary Table: Gift Data13KUNWEShip-to partynvarchar100
40JKWWWTEMP_REDIRIS-M: Temporary Internet Table: Redirection Data13KUNWEShip-to partynvarchar100
41JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet53KUNWEIS-M: Business Partner Ship-to Partynvarchar100
42JKWWWTEMP_SUSPIS-M: Temporary Internet Table: Suspension Data13KUNWEShip-to partynvarchar100
43JKWWWTEMP_TRNSFIS-M: Internet Temporary Table: Transfer Data13KUNWEShip-to partynvarchar100
TOPProfitability Analysis
44CE1IDEAOp. Concern BR World71KUNWEShip-to partynvarchar100
45CE1IDESErgebnisbereich IDES71KUNWEWarenempfängernvarchar100
46CE1INT1Ergebnisbereich IDES71KUNWEWarenempfängernvarchar100
47CE1OC01Bike International67KUNWEShip-to partynvarchar100
48CE2IDEAOp. Concern BR World55KUNWEShip-to partynvarchar100
49CE2IDESErgebnisbereich IDES55KUNWEWarenempfängernvarchar100
50CE2INT1Ergebnisbereich IDES55KUNWEWarenempfängernvarchar100
51CE2OC01Bike International51KUNWEShip-to partynvarchar100
52CE4IDEAOp. Concern BR World40KUNWEShip-to partynvarchar100
53CE4IDEA_ACCTOp. Concern BR World41KUNWEShip-to partynvarchar100
54CE4IDEA_FLAGOp. Concern BR World37KUNWEFlag: Characteristic Assigned Manually or Using TKEZUnvarchar10
55CE4IDEA_KENCOp. Concern BR World39KUNWEShip-to partynvarchar100
56CE4IDESErgebnisbereich IDES40KUNWEWarenempfängernvarchar100
57CE4IDES_ACCTErgebnisbereich IDES41KUNWEWarenempfängernvarchar100
58CE4IDES_FLAGErgebnisbereich IDES37KUNWEFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
59CE4IDES_KENCErgebnisbereich IDES39KUNWEWarenempfängernvarchar100
60CE4INT1Ergebnisbereich IDES40KUNWEWarenempfängernvarchar100
61CE4INT1_ACCTErgebnisbereich IDES41KUNWEWarenempfängernvarchar100
62CE4INT1_FLAGErgebnisbereich IDES37KUNWEFlag: Merkmal manuell oder über TKEZU kontiertnvarchar10
63CE4INT1_KENCErgebnisbereich IDES39KUNWEWarenempfängernvarchar100
64CE4OC01Bike International36KUNWEShip-to partynvarchar100
65CE4OC01_ACCTBike International37KUNWEShip-to partynvarchar100
66CE4OC01_KENCBike International35KUNWEShip-to partynvarchar100
TOPRemaining Beverage - Obsolete Objects
67/BEV1/BO_DATAProof Table for Rebate Processing4KUNWEShip-to partynvarchar100
68/BEV1/RBWEItemized Proof Rebate Settlement3KUNWECustomer Numbernvarchar100
TOPRemote Logistics Management
69OIO_MX_OBJECTRLM tracking extract object data30KUNWEShip-to party for document flow objectnvarchar100
70OIO_RT_RTDOC_CTReturns document - container items19KUNWEShip-to external partynvarchar100
71OIO_RT_RTDOC_MTReturns document - material items29KUNWEShip-to external partynvarchar100
TOPSales
72SLS_TMPL_HEADSales: Template Head6KUNWEShip-to partynvarchar100
73SLS_TMPL_KEYSales: Template Key4KUNWEShip-to partynvarchar100
74VEPVGDelivery Due Index8KUNWEShip-to partynvarchar100
TOPShipping
75VARKDelivery Plan: Customer-Specific Itinerary5KUNWEShip-to partynvarchar100
76VAWKDelivery Plan: Itinerary Determination, Customer-Specific3KUNWEShip-to partynvarchar100
TOPSupplier Managed Inventory
77SMI_HEADERSMI Header Data10KUNWEShip-to partynvarchar100
TOPTraders and Schedulers Workbench
78S430SIS: (OIL-TSW) Sales document statistics by TSW object13KUNWEShip-to partynvarchar100
TOPVehicle Management System
79CVLC23VELO : Assign Organization Data to VMS Roles9KUNWEShip-to partynvarchar100
80VLCBATCHACTVELO : Variant for Action Execution in Batch59KUNWEShip-to partynvarchar100
TOPWarehouse Management
81T321Assignment MM Movement Type --> MM-WM Movement Type19KUNWEShip-to-party for delivery for WMSnvarchar100
82T340DWM Default Values45KUNWEShip-to-party for delivery for WMSnvarchar100
83T345Client-Dependent Control Table for WM->PP Staging7KUNWEShip-to partynvarchar100
TOPWaste Management
84EEWA_BULK_DATABulk refuse order data7KUNWEBusiness Partner from whom Waste is to be Removednvarchar100
85EWA_ORDER_OBJECTItem Table for Waste Disposal Order35KUNWEShip-to partynvarchar100