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

37 columns | Print definition?ERP 6.0  | KTOKD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____00PZSID-Tabelle fuer Account group3KTOKDCustomer Account Groupnvarchar40
2CNV_20800_T077DCNV table that states which customer account groups match3KTOKDCustomer Account Groupnvarchar40
3CNV_20900_T077KVendor account groups19KTOKDDefault value for customer account groupnvarchar40
4J_1BCUST_SCFSELField Selection for Customer Master Data2KTOKDCustomer Account Groupnvarchar40
5SEPA_NR_CUSTSEPA Mandate Reference ID: Number Range Customizing2KTOKDCustomer Account Groupnvarchar40
6T077DFCustomer Group: FI-CA Integration (Distributed Systems)2KTOKDCustomer Account Groupnvarchar40
7T077XAccount Group Names (Table T077D)3KTOKDCustomer Account Groupnvarchar40
8THIZUCustomer Hierarchy: Allowed Account Group Assignments3KTOKDCustomer Account Groupnvarchar40
9TKUPABusiness Partners: Customer Master Groups2KTOKDCustomer Account Groupnvarchar40
10TNDR2IS-H: Screens Used to Create & Change RF Customer in R/21KTOKDIS-H: Account group RF customer SAP R/2nvarchar40
11TPAKDBusiness Partner: Valid Acct Groups per Partner Function3KTOKDCustomer Account Groupnvarchar40
12TZ10Customer application type4KTOKDCustomer Account Groupnvarchar40
TOPBusiness Partner
13TECSTAccount Groups for Ref. Customers in IS-U2KTOKDCustomer Account Groupnvarchar40
14TUKTOAccount Groups Belonging to IS-U2KTOKDCustomer Account Groupnvarchar40
TOPBusiness Partner Enhancements for Financial Services
15TBD001Business Partner: Assignment of Account Groups and Grouping3KTOKDCustomer Account Groupnvarchar40
16TPZ2Business Partner: Customizing BP Grouping4KTOKDCustomer Account Groupnvarchar40
TOPCross-Application Components
17BC490KKNA1General data in customer master36KTOKDCustomer Account Groupnvarchar40
18KKNA1General Data in Customer Master36KTOKDCustomer Account Groupnvarchar40
19SKNA1Customer Master table for BC417 Course36KTOKDCustomer Account Groupnvarchar40
TOPCustomer Master
20KNA1General Data in Customer Master36KTOKDCustomer Account Groupnvarchar40
TOPData Collection
21S018SIS: Address list for sales promotion12KTOKDCustomer Account Groupnvarchar40
22S018ES018 - Structural Information7KTOKDCustomer Account Groupnvarchar40
TOPFunds Management-Specific Postings
23PSO34Allocation of revenue type to account group3KTOKDCustomer Account Groupnvarchar40
TOPInformation System
24DKKOSBalance Audit Trail24KTOKDCustomer Account Groupnvarchar40
25DKOKSOpen Item Account Balance Audit Trail Master Record27KTOKDCustomer Account Groupnvarchar40
TOPIntegration
26TFK077DFI-CA: SD/FI-CA Customer Account Group Enhancement2KTOKDCustomer Account Groupnvarchar40
TOPMarketing Retail Network
27OIFBRT1Business partner roles - technical category (IS-Oil MRN)5KTOKDCustomer Account Groupnvarchar40
TOPMaster Data
28TJG37IS-M/SD: Business Partner Account Groups5KTOKDCustomer Account Groupnvarchar40
TOPPayment Transactions
29T077DCustomer account groups2KTOKDCustomer Account Groupnvarchar40
30T077KVendor account groups17KTOKDDefault value for customer account groupnvarchar40
TOPPlant Master
31TWRF2Plant Profiles11KTOKDCustomer account groupnvarchar40
TOPProduction and Revenue Accounting
32OIUCM_CUST_KTOKDValid Customer Account Groups for Business Associates2KTOKDCustomer Account Groupnvarchar40
TOPRemaining Beverage - Obsolete Objects
33/BEV3/CHCKTGWEAccount group of the ship-to party2KTOKDCustomer Account Groupnvarchar40
TOPSales Promotions
34SADLSTRECBDynamic Part of Address List (Record Body)53KTOKDCustomer Account Groupnvarchar40
TOPTransportation Planning
35/DSD/RP_DRVKTOKDDefine Account Group as Account Group for Driver2KTOKDCustomer Account Groupnvarchar40
TOPTreasury
36VZKNA1Collector for batch input KNA1 from RF-VV13KTOKDCustomer Account Groupnvarchar40
TOPUse AP-MD-BP Components
37TB001BP groupings7KTOKDCustomer Account Groupnvarchar40