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

42 columns | Print definition?ERP 6.0  | STCD2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPRCPTDetail of receipt26STCD2Tax Number 2nvarchar110
2/ATL/KPRCPTKPDetail of temporary receipt26STCD2Tax Number 2nvarchar110
3/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)57STCD2Tax Number 2nvarchar110
4BSECOne-Time Account Data Document Segment21STCD2Tax Number 2nvarchar110
5FUDT_VDOCBSECOne-Time Account Data Segment of Verification Document21STCD2Tax Number 2nvarchar110
6FUDT_VDOCBSECHOne-Time Account Data Segment of Verification Doc(History)21STCD2Tax Number 2nvarchar110
7TZD0ADarwin: Customer default values per trans. type for KNA115STCD2Tax Number 2nvarchar110
8WBRDAgency Business: Bank Data Suspense Account16STCD2Tax Number 2nvarchar110
TOPBasic Functions
9VBPA3Tax Numbers for One-Time Customers6STCD2Tax Number 2nvarchar110
TOPBusiness Partner
10TIVBPVENDORGENVendor Preassignment (General Data)25STCD2Tax Number 2nvarchar110
TOPBusiness Partner Enhancements for Financial Services
11BP1020BP: Business Partner - Fiscal Data4STCD2Tax Number 2nvarchar110
TOPCross-Application Components
12BC490KKNA1General data in customer master54STCD2Tax Number 2nvarchar110
13KKNA1General Data in Customer Master54STCD2Tax Number 2nvarchar110
14SKNA1Customer Master table for BC417 Course54STCD2Tax Number 2nvarchar110
TOPCustomer Master
15KNA1General Data in Customer Master54STCD2Tax Number 2nvarchar110
TOPFinancial Accounting
16LFA1Vendor Master (General Section)42STCD2Tax Number 2nvarchar110
17VBSECDocument Parking One-Time Data Document Segment21STCD2Tax Number 2nvarchar110
TOPFunds Management-Specific Postings
18PSOSECRecurring Request Document Segment, One-Time Data23STCD2Tax Number 2nvarchar110
TOPGL Account Posting
19TCJ_CPDFBCJ: One-Time Account Data of Cash Journal Document Items22STCD2Tax Number 2nvarchar110
TOPInformation System
20DKKOSBalance Audit Trail53STCD2Tax Number 2nvarchar110
21DKOKSOpen Item Account Balance Audit Trail Master Record56STCD2Tax Number 2nvarchar110
TOPInvoice Verification
22RBKPDocument Header: Invoice Receipt96STCD2Tax Number 2nvarchar110
TOPLoans Management
23VDAUSZDrawings on Disbursement33STCD2Tax Number 2nvarchar110
24VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity47STCD2Tax Number 2nvarchar110
25VZFZE_VDAUSZCentral Entry Table for Release Procedure35STCD2Tax Number 2nvarchar110
26VZFZE_VDNBZECentral Entry Table for Release Procedure67STCD2Tax Number 2nvarchar110
TOPLocalization
27IDKR_CUSTVATVAT registration number against customer on a time basis5STCD2Tax Number 2nvarchar110
28IDKR_VENVATVAT registration number against vendor on a time basis5STCD2Tax Number 2nvarchar110
29J_1BBRANCHBusiness Place16STCD2Tax Number 2nvarchar110
30J_1BNFCPDNota Fiscal one-time accounts19STCD2Tax Number 2nvarchar110
TOPLogistics - General
31WBHPTrading Contract: Partner Assignment18STCD2Tax Number 2nvarchar110
TOPPayment Transactions
32FPCR_CESSGarnishment Register Attributes23STCD2Tax Number 2nvarchar110
33FPRL_ITEMItem Data107STCD2Tax Number 2nvarchar110
TOPPayroll
34T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000946STCD2Danové císlo 2nvarchar110
35T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001151STCD2Danové císlo 2nvarchar110
TOPPersonnel Administration
36PA0009HR Master Record: Infotype 0009 (Bank Details)43STCD2Tax Number 2nvarchar110
37PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)48STCD2Tax Number 2nvarchar110
TOPReal Estate Management
38VIAKBSEGDocument Line Item from SCS for Interface75STCD2Tax Number 2nvarchar110
TOPRecruitment
39PB0009HR Master Record: Infotype 0009 (Bank Details)43STCD2Tax Number 2nvarchar110
TOPTransfer Postings
40J_1AAWAYBLWay Bills for asset movements41STCD2Tax Number 2nvarchar110
TOPTreasury
41VZKNA1Collector for batch input KNA1 from RF-VV31STCD2Tax Number 2nvarchar110
42VZPARZAPartner addit. data (general part)27STCD2Tax Number 2nvarchar110