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

52 columns | Print definition?ERP 6.0  | PSTL2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPRCPTDetail of receipt20PSTL2P.O. Box Postal Codenvarchar100
2/ATL/KPRCPTKPDetail of temporary receipt20PSTL2P.O. Box Postal Codenvarchar100
3BSECOne-Time Account Data Document Segment15PSTL2P.O. Box Postal Codenvarchar100
4CNV_20305_CEPCSAP LT: Backup table of CEPC25PSTL2P.O. Box Postal Codenvarchar100
5FUDT_VDOCBSECOne-Time Account Data Segment of Verification Document15PSTL2P.O. Box Postal Codenvarchar100
6FUDT_VDOCBSECHOne-Time Account Data Segment of Verification Doc(History)15PSTL2P.O. Box Postal Codenvarchar100
TOPAddress ManagementBusiness Address
7SADRAddress Management: Company Data12PSTL2PO Box postal codenvarchar100
TOPAssortment List
8WBBHAssortment list header18PSTL2P.O. Box Postal Codenvarchar100
TOPAutomatic Payments
9PAYRQPayment Requests37PSTL2P.O. Box Postal Codenvarchar100
TOPBank Customer Accounts
10BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA117PSTL2P.O. Box postal codenvarchar90
TOPBusiness Partner Enhancements for Financial Services
11BP030BP: Business partner - address16PSTL2P.O. Box Postal Codenvarchar100
TOPControlling
12CSKSCost Center Master Data44PSTL2P.O. Box Postal Codenvarchar100
TOPCross-Application Components
13BC490KKNA1General data in customer master47PSTL2P.O. Box Postal Codenvarchar100
14KKNA1General Data in Customer Master47PSTL2P.O. Box Postal Codenvarchar100
15SKNA1Customer Master table for BC417 Course47PSTL2P.O. Box Postal Codenvarchar100
TOPCustomer Master
16KNA1General Data in Customer Master47PSTL2P.O. Box Postal Codenvarchar100
TOPFinancial Accounting
17LFA1Vendor Master (General Section)11PSTL2P.O. Box Postal Codenvarchar100
18VBSECDocument Parking One-Time Data Document Segment15PSTL2P.O. Box Postal Codenvarchar100
TOPFSCM In-House Cash
19IHC_DB_PN_BPIHC: Address Data of Bus. Partners Involved in Payment Order14PSTL2P.O. Box Postal Codenvarchar100
TOPFunds Management-Specific Postings
20PAYRCAdditional Header Data for Recovery Order20PSTL2P.O. Box Postal Codenvarchar100
21PSOSECRecurring Request Document Segment, One-Time Data17PSTL2P.O. Box Postal Codenvarchar100
TOPGL Account Posting
22TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items16PSTL2P.O. Box Postal Codenvarchar100
TOPHong Kong
23T7HK2HProvider Attributes11PSTL2Postal Codenvarchar100
TOPInformation System
24DKKOSBalance Audit Trail16PSTL2P.O. Box Postal Codenvarchar100
25DKOKSOpen Item Account Balance Audit Trail Master Record17PSTL2P.O. Box Postal Codenvarchar100
TOPInvoice Verification
26RBKPDocument Header: Invoice Receipt90PSTL2P.O. Box Postal Codenvarchar100
TOPLoans Management
27VDAUSZDrawings on Disbursement27PSTL2P.O. Box Postal Codenvarchar100
28VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity41PSTL2P.O. Box Postal Codenvarchar100
29VZFZE_VDAUSZCentral Entry Table for Release Procedure29PSTL2P.O. Box Postal Codenvarchar100
30VZFZE_VDNBZECentral Entry Table for Release Procedure61PSTL2P.O. Box Postal Codenvarchar100
TOPLocalization
31J_1BNFCPDNota Fiscal one-time accounts13PSTL2P.O. Box Postal Codenvarchar100
32J_1BNFDOCNota Fiscal Header79PSTL2P.O. Box Postal Codenvarchar100
33J_1BNFNADNota Fiscal partners19PSTL2P.O. Box Postal Codenvarchar100
TOPMaster Data
34JGTSADRIS-M: Extended Address Management26PSTL2IS-M: Postal Code for PO Boxnvarchar100
35JSTALIASIS-M: Alias Table for Streets12PSTL2IS-M: Postal Code for PO Boxnvarchar100
TOPOverhead Cost Controlling
36CMDT_ADRGeneric Master Record: Address17PSTL2P.O. Box Postal Codenvarchar100
TOPPayment Transactions
37REGUHSettlement data from payment program95PSTL2P.O. Box Postal Codenvarchar100
TOPPeriodical Sales and Distribution
38JKWWWTEMP_BPIS-M/SD: WWW, Temporary Table for BP Data from Internet12PSTL2IS-M: Postal Code for PO Boxnvarchar100
39JKWWWTEMP_GIFTIS-M: Internet Temporary Table: Gift Data30PSTL2IS-M: Postal Code for PO Boxnvarchar100
40JKWWWTEMP_REDIRIS-M: Temporary Internet Table: Redirection Data30PSTL2IS-M: Postal Code for PO Boxnvarchar100
41JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet11PSTL2IS-M: Postal Code for PO Boxnvarchar100
TOPProduct Cost Planning
42CKBSBase Planning Object - Unit Costing31PSTL2P.O. Box Postal Codenvarchar100
TOPProfit Center Accounting
43CEPCProfit Center Master Data Table25PSTL2P.O. Box Postal Codenvarchar100
TOPPurchasing
44EKANVendor Address: Purchasing Document12PSTL2P.O. Box Postal Codenvarchar100
TOPReal Estate Management
45VIAKBSEGDocument Line Item from SCS for Interface77PSTL2Postal Codenvarchar100
TOPRecycling Administration Core Functions
46J_7LSADRAddress Management: Company Data12PSTL2PO Box postal codenvarchar100
TOPRemaining Beverage - Obsolete Objects
47/BEV1/CLDEBCustomer Information11PSTL2P.O. Box Postal Codenvarchar100
TOPShipping
48DVK01R/2-R/3 Link: Delivery Header Data R2 -> R314PSTL2P.O. Box Postal Codenvarchar100
TOPTransfer Postings
49J_1AAWAYBLWay Bills for asset movements33PSTL2P.O. Box Postal Codenvarchar100
TOPTreasury
50SANO1Address-object relationship8PSTL2P.O. Box Postal Codenvarchar100
51VZKNA1Collector for batch input KNA1 from RF-VV23PSTL2P.O. Box Postal Codenvarchar100
TOPUser and Authorization Management
52USR03User address data27PSTL2District Postal Codenvarchar100