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

86 columns | Print definition?ERP 6.0  | ZBUKR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/FORECPYMNTForeclosure payments8ZBUKRPaying company codenvarchar40
2ARBERP_D_PAYTRIGTrigger table: send cXML payment remittance request messages8ZBUKRPaying company codenvarchar40
3COPC_PAYRQ_DTLCOPC: PAYRQ Detail6ZBUKRCompany Code on Opposite Sidenvarchar40
4EPIC_BACOM_DATBank Communication Program Data3ZBUKRCompany Codenvarchar40
5EPIC_BC_UAEPIC: User Assignment Bank Communication2ZBUKRPaying company codenvarchar40
6EPIC_C_BCDBank Communication Details2ZBUKRPaying company codenvarchar40
7EPIC_C_BCSBank Communication Steps2ZBUKRPaying company codenvarchar40
8EPIC_C_BSTBank Statement Format2ZBUKRPaying company codenvarchar40
9EPIC_ZBUKR_MAPcompany code map for ccb request sn2ZBUKRPaying company codenvarchar40
10REGUC5ZBUKRnvarchar40
11REGUPProcessed items from payment program5ZBUKRPaying company codenvarchar40
12REGUVM_HDecision for Cross-Payment-Run Payment Media (BAdI)5ZBUKRPaying company codenvarchar40
13T012EEDI-compatible house banks and payment methods2ZBUKRPaying company codenvarchar40
14T028Y_SEPAReturns Activities: Change Mandate Status3ZBUKRPaying company codenvarchar40
15T042Parameters for payment transactions3ZBUKRPaying company codenvarchar40
16T042ABank selection for payment program2ZBUKRPaying company codenvarchar40
17T042IAccount determination for payment program2ZBUKRPaying company codenvarchar40
18T042IYAccount Determination for Payment Programs2ZBUKRPaying company codenvarchar40
19T042JBank charges determination2ZBUKRPaying company codenvarchar40
20T042KAccounts for bank charges2ZBUKRPaying company codenvarchar40
21T042SCharges/expenses for automatic pmnt transactions2ZBUKRPaying company codenvarchar40
22T042ZA_FORMATDifferent PMW Format2ZBUKRPaying company codenvarchar40
23T042ZA_PREFTYPDifferent PMW Format2ZBUKRPaying company codenvarchar40
TOPAccounts Receivable Accounting Process Integration
24T042ICCAccount Determination Payment Cards in Payment Program2ZBUKRPaying company codenvarchar40
25T042ZEBPPBiller Direct Payment Methods2ZBUKRPaying company codenvarchar40
TOPAutomatic Payments
26PAYRQPayment Requests3ZBUKRPaying Company Code for this Payment Requestnvarchar40
27T042EAPayment method capability for ALE distribution2ZBUKRPaying company codenvarchar40
28T042YAccount Determination for Bank to Bank Payments2ZBUKRPaying company codenvarchar40
29TBKPVTime Between Payment Run and Value Date at House Bank2ZBUKRPaying company codenvarchar40
TOPBank Accounting
30DFPAYGPayment date: Grouping7ZBUKRPaying company codenvarchar40
31DFPAYVPayment Medium: Selection Variants3ZBUKRPaying company codenvarchar40
32REGUTTemSe - Administration Data2ZBUKRPaying company codenvarchar40
33REGUTAPaying Company Codes for DME Files8ZBUKRPaying company codenvarchar40
TOPBasic Functions
34T018ZCash Transfer: Payment Method Determination Payment Requests2ZBUKRPaying company codenvarchar40
TOPContract Accounts Receivable and Payable
35DFKKBRSEQBrazil : Control of DME file Sequence Number2ZBUKRCompany Code for Automatic Payment Transactionsnvarchar40
TOPData Transfer
36PPMIXIndex Payroll Results Lines -> Posting Lines for Payment28ZBUKRCompany Codenvarchar40
TOPFinancial Accounting
37BWPOSIValuations for Open Items5ZBUKRTarget Company Code for Evaluationnvarchar40
38DEFTAX_ITEMData for Deferred Taxes7ZBUKRCompany Codenvarchar40
TOPFinancial Supply Chain Management
39BNK_BATCH_HEADERBatch Header25ZBUKRPaying company codenvarchar40
40BNK_BATCH_ITEMBatch Payment Items13ZBUKRPaying company codenvarchar40
TOPInformation System
41BWPOSValuations for Open Items5ZBUKRTarget Company Code for Evaluationnvarchar40
TOPLocalization
42EPIC_C_BPSOTC_ASEPIC: Bank Payment Service Operation Type Code Assignment2ZBUKRPaying company codenvarchar40
43EPIC_C_HB_COMMElectronic Payment Integration: House Bank Commun. Settings2ZBUKRPaying company codenvarchar40
44J_3R0Payment with correspondent account2ZBUKRPaying company codenvarchar40
45J_3RFSEC_ITEMData for Secondary events for deferred tax6ZBUKRCompany Codenvarchar40
TOPPayment Transactions
46FEDIWF1FI EDI: Person with signing authority2ZBUKRPaying company codenvarchar40
47FPRL_ITEMItem Data118ZBUKRPaying company codenvarchar40
48PAYRPayment Medium File2ZBUKRPaying company codenvarchar40
49PCECPrenumbered Checks2ZBUKRPaying company codenvarchar40
50PNHDPrenotification: Files created in ACH format5ZBUKRPaying company codenvarchar40
51PYORDHPayment order header data7ZBUKRPaying company codenvarchar40
52REGUAChange of payment proposals: user and time4ZBUKRPaying company codenvarchar40
53REGUHSettlement data from payment program5ZBUKRPaying company codenvarchar40
54REGUHHREGUH version before the 'n'th change4ZBUKRPaying company codenvarchar40
55REGUHMPayment Data for Cross-Payment Run Payment Medium4ZBUKRPaying company codenvarchar40
56REGUHOREGUH version before the 'n'th change4ZBUKRPaying company codenvarchar40
57REGUP_COREProcessed Items from Payment Program2ZBUKRPaying company codenvarchar40
58T042BDetails on the company codes that must pay2ZBUKRPaying company codenvarchar40
59T042ECompany Code-Specific Specifications for Payment Methods2ZBUKRPaying company codenvarchar40
60T042JBCustomizing table for Japan Bank Mergers2ZBUKRPaying company codenvarchar40
61T042JB1Customizing table for Japan Bank/Branch Mergers2ZBUKRPaying company codenvarchar40
62T042UBlock Entries for Debit Customers/Credit Vendors4ZBUKRPaying company codenvarchar40
63T042YPAccount Determination for HR Payments2ZBUKRPaying company codenvarchar40
64TFIBLHBGGroup of House Bank Accounts2ZBUKRPaying company codenvarchar40
65TFIBLHBG1Group of House Bank Accounts: Details2ZBUKRPaying company codenvarchar40
66TFIBLHBGTName of the House Bank Groups3ZBUKRPaying company codenvarchar40
TOPPayroll
67T5T1LBank accounts of authorities (tax,insurance)15ZBUKRPaying company codenvarchar40
68T5TA1External transfers59ZBUKRPaying company codenvarchar40
69T5TPS1LBank accounts of authorities (tax,insurance)17ZBUKRPaying company codenvarchar40
70T7BGA1Bank transfer - interface table5ZBUKRCompany Codenvarchar40
71T7ROA1Bank transfer - interface table5ZBUKRCompany Codenvarchar40
72T7SIA6Bank transfer - interface table5ZBUKRCompany Codenvarchar40
73T7SK1LBank accounts of authorities (tax,insurance)18ZBUKRPaying company codenvarchar40
74T7SKA1External transfers59ZBUKRPaying company codenvarchar40
TOPPersonnel Management
75T7HRA1Bank transfer - interface table5ZBUKRCompany Codenvarchar40
TOPTreasury
76FLQCOMPANYLiquidity Calculation - Company Codes2ZBUKRPaying company codenvarchar40
77FLQHEADMALiquidity Calculation - Header for Manual Transfer Postings2ZBUKRLiquidity Calculation: Paying Company Codenvarchar40
78FLQITEMBSLiquidity Calculation - Line Items for Bank Statement Docs2ZBUKRLiquidity Calculation: Paying Company Codenvarchar40
79FLQITEMFILiquidity Calculation - Line Items for Other FI Documents2ZBUKRLiquidity Calculation: Paying Company Codenvarchar40
80FLQITEMFI_FCLiquidity Calculation - Forecast Line Items for FI Documents2ZBUKRLiquidity Calculation: Paying Company Codenvarchar40
81FLQITEMFI_TPLiquidity Calculation: Actual Line Items at Top Level2ZBUKRLiquidity Calculation: Paying Company Codenvarchar40
82FLQITEMMALiquidity Calculation - Line Items for Manual Transfers2ZBUKRLiquidity Calculation: Paying Company Codenvarchar40
83FLQSUMLiquidity Calculation - Totals Records6ZBUKRLiquidity Calculation: Paying Company Codenvarchar40
84FLQSUM_FCLiquidity Calculation - Forecast Totals Records7ZBUKRLiquidity Calculation: Paying Company Codenvarchar40
85FLQSUM_TPLiquidity Calculation: Totals Records at Top Level6ZBUKRLiquidity Calculation: Paying Company Codenvarchar40
TOPUS Prompt Payment Act
86T043UNegative grace period2ZBUKRPaying company codenvarchar40