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

79 columns | Print definition?ERP 6.0  | KONTO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items30KONTOnvarchar100
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact30KONTOnvarchar100
3/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items36KONTOnvarchar100
4/CCEE/SIFIPOBOTIePoboti: Obligatory manysided reconciliation - XML output30KONTOAccount Numbernvarchar100
5/SAPSRM/TT_DATATest Data for SRM Test Tool18KONTOG/L Account Numbernvarchar100
6CNVA_PCREA_AA_OLT PC Reorg Analysis: Asset Reconciliation results (Level 2)7KONTOG/L Account Numbernvarchar100
7CNVA_PCREA_AA_RLT PC Reorg Analysis: Asset Reconciliation results (Level 1)6KONTOG/L Account Numbernvarchar100
8CNVA_PCREA_WIP_OLT PC Reorg Analysis: WIP Reconciliation results (Level 2)7KONTOG/L Account Numbernvarchar100
9CNVA_PCREA_WIP_RLT PC Reorg Analysis: WIP Reconciliation results (Level 1)7KONTOG/L Account Numbernvarchar100
10CNV_20100_AVSPOMapping for AVIP: AVSPO(old) - AVSPO(new)5KONTOnvarchar100
11EPIC_EBR_AVAdditional Data on Payment Advice Line Item for Bank Receipt5KONTOAccount Numbernvarchar100
12FUDT_VDOCAVIKKEHPayment advice key for Document Verification4KONTOAccount Numbernvarchar100
13FUDT_VDOCAVIKKEYPayment Advice Note Key for Document Verification4KONTOAccount Numbernvarchar100
14T018CCash Concentration: Intermediate Acct and Amt Stipulations3KONTOBank accountnvarchar100
15T033GAcct determination: Replacing the account symbols7KONTOAccount Determination: G/L Account Numbernvarchar100
16TDVKAccts to be summarized during data transfer from R/3 -> R/21KONTOGeneral Ledger Accountnvarchar100
17TFE05BDF: State CB Indic.3KONTOG/L Account Numbernvarchar100
18TTRCDIntermediate accts and min. balances for cash concentration3KONTOBank accountnvarchar100
19ZEIM_LIPSSD document: Delivery: Item data227KONTOG/L Account Numbernvarchar100
20ZPR02SD-Profiles - Other Objects4KONTOAccount Number or Matchcode for the Account To Be Postednvarchar160
TOPAccounts Receivable Accounting Process Integration
21FDM_CONTACT_BUFPersonalization of Contact Person Data4KONTOCustomer/Vendor Account Numbernvarchar100
TOPBalance Sheet Valuation Procedures
22MYLAUFITObject Table for Delta Run Using MRN912KONTOG/L Account Numbernvarchar100
TOPData Collection
23CF006Balance Sheet9KONTOAccountnvarchar80
TOPData Transfer
24PPKIXTransfer FI/CO: Index of Account Assignment Combinations4KONTOGeneral Ledger Accountnvarchar100
TOPDenmark
25PA0073HR Master Record: Infotype 0073 (Private Pensions - DK)26KONTOAccount numbernvarchar100
TOPElectronic Bank Statement
26FEB_AVIR_EXTDAdvice Note Subitem Enhancement (Bank Statement Postproc.)4KONTOAccount Numbernvarchar100
TOPFinancial Accounting
27AVIKPayment Advice Header4KONTOAccount Numbernvarchar100
28AVIPPayment Advice Line Item4KONTOAccount Numbernvarchar100
29AVIRPayment Advice Subitem4KONTOAccount Numbernvarchar100
30AVITAdvice Header: User-Definable Text4KONTOAccount Numbernvarchar100
31BKORMAccounting Correspondence Requests5KONTOOpen item account numbernvarchar100
32BKORRAccounting correspondence requests5KONTOOpen item account numbernvarchar100
33BWFI_AEDA2BW FI: Log Table for Changed Transaction Figures3KONTOFI Acct No.nvarchar100
34BWFI_AEDA3BW FI: Log Table for Changed Credit Management Data3KONTOFI Acct No.nvarchar100
35T076AAssign Payment Advice Notes to Posting Rules5KONTOAccount numbernvarchar100
36T076BEDI: Assign Name in the Invoice <-> Company Code3KONTOPartner numbernvarchar100
37T076EFI-EDI: Assignment Pymt Method - External Pymt Method (Bank)3KONTOPartner numbernvarchar100
38T076IFI-EDI: G/L Accounts3KONTOPartner numbernvarchar100
39T076KFI-EDI: Additional Account Assignments3KONTOPartner numbernvarchar100
40T076MEDI: Conversion of External Tax Rate <-> Tax Code3KONTOPartner numbernvarchar100
41T076SEDI-INVOIC: Program Parameters3KONTOPartner numbernvarchar100
TOPHandling Unit Management
42THUWBEVENTDefinition of Possible Events for HU Goods Movements10KONTOAccount Field is Avaliable for Input at Goods Movementnvarchar10
TOPIncentive and Commission Management ICM
43CACSCD_DOCCD_PDSettlement to FS-CD: Reference Document Line Items7KONTOPayment Rec. in Collections/Disbursements (Insurance Object)nvarchar200
44CACSFI_DOCFI_PDSettlement to FI: Reference Line Item7KONTOGeneral Ledger Accountnvarchar100
TOPInformation System
45DKKOPBalance Audit Trail4KONTOCustomer Numbernvarchar100
46DKKOSBalance Audit Trail4KONTOCustomer Numbernvarchar100
47DKOKPOpen Item Account Balance Audit Trail4KONTOCustomer Numbernvarchar100
48DKOKSOpen Item Account Balance Audit Trail Master Record4KONTOCustomer Numbernvarchar100
49DSKOPBalance Audit Trail4KONTOCustomer Numbernvarchar100
50DSKOSBalance Audit Trail4KONTOCustomer Numbernvarchar100
TOPInventory Management
51MWZDM07M1ZDM07M17KONTOG/L Account Numbernvarchar100
52T159ATest Data for Batch Input in Inventory Management23KONTOAccount numbernvarchar160
TOPLocal Currency Changeover
53EWUFIAASUMEWU conversion: Table for asset totals at account level5KONTOAccount number (G/L account/customers/vendors)nvarchar100
54EWUFI_BALEMU conversion: Logging transaction figures change7KONTOAccount number (G/L account/customers/vendors)nvarchar100
55EWUFI_BALPEMU conversion: Logging transaction figures change8KONTOAccount numbernvarchar160
56EWUFI_SCAEMU conversion: Table of the clearings to be adjusted7KONTOAccount number (G/L account/customers/vendors)nvarchar100
57EWUFI_SOPEMU conversion: Table for open items total5KONTOAccount number (G/L account/customers/vendors)nvarchar100
TOPLocalization
58J_3RFTAX_EXTRDTax Extract Detail Lines39KONTOAccount Numbernvarchar100
59RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions3KONTOAccount Numbernvarchar100
60RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions3KONTOAccount Numbernvarchar100
61RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions3KONTOAccount Numbernvarchar100
TOPPatient Accounting
62NFALACPIS-H: Case Accrual per Day23KONTOIS-H: Receivables Account for Accrualnvarchar100
63TN21ZIS-H: Incoming Payments Control Parameters6KONTOIS-H: Cash Account/Cash Clearing Accountnvarchar100
64TN22PIS-H: Control Parameters FI Posting Down Payment12KONTOIS-H: Bank Accountnvarchar100
65TN22RIS-H: Control Params FI Posting Copayment/Copay.Cred.Memo10KONTOIS-H: Bank Accountnvarchar100
TOPPOS Interface
66TWPIWPOS interface: default values for movement types/inv. man.5KONTOG/L Account Numbernvarchar100
TOPQuality Inspection
67QALSInspection lot record198KONTOG/L Account Numbernvarchar100
TOPRemaining Beverage - Obsolete Objects
68/BEV1/RSFFRBIBatch Input Table for Collection Assignment8KONTOAccount numbernvarchar160
69/BEV1/RSIMACollection Material13KONTOGeneral Ledger Accountnvarchar100
TOPRepetitive Manufacturing
70COMPMOVEGoods Movement of Components73KONTOG/L Account Numbernvarchar100
TOPSAP Healthcare - Industry-Specific Components for Hospitals
71TN22GIS-H: Steuerungsparameter FI-Buchung amb. Zuzahlung9KONTOIS-H: Bankkontonvarchar100
TOPShipping
72LIPSSD document: Delivery: Item data227KONTOG/L Account Numbernvarchar100
73TMAWBEVENTDefiniton of Possible Transactions for LE Goods Movements12KONTOAccount Field is Avaliable for Input at Goods Movementnvarchar10
TOPTariffs, Duties and Permits
74OIH30Two-step transfer control table16KONTOAccount numbernvarchar160
TOPTechnical Application Support
75CNV_20425_AASUMEWU conversion: Table for asset totals at account level4KONTOAccount number (G/L account/customers/vendors)nvarchar100
76CNV_20425_BALEMU conversion: Logging transaction figures change4KONTOGeneral Ledger Accountnvarchar100
77CNV_20425_SCAEMU conversion: Table of the clearings to be adjusted4KONTOGeneral Ledger Accountnvarchar100
78CNV_20425_SOPEMU conversion: Table for open items total4KONTOGeneral Ledger Accountnvarchar100
79CNV_20425_S_ABST20425: Reconciliation 2 / 3 local currency5KONTOAccount numbernvarchar160