SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8BSEG345Accounting Document Segment
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

1OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OPOR386Purchase Order
9JDT1124Journal Entry - Rows
10OACT114G/L Accounts

B1 8.8: Top 10 requests

2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction - the webs number one PHP Function reference tool

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
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
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
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