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

89 columns | Print definition?ERP 6.0  | MABER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000165000PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta13MABERnvarchar20
2/BIC/B0000166000PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta13MABERnvarchar20
3/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items32MABERnvarchar20
4/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact32MABERnvarchar20
5/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items38MABERnvarchar20
6/SMD/MD_____00NHSID-Tabelle fuer Dunning Area4MABERDunning Areanvarchar20
7BSAD_BAKAccounting: Secondary index for customers (cleared items)66MABERDunning Areanvarchar20
8BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)69MABERDunning Areanvarchar20
9BSEGAccounting Document Segment159MABERDunning Areanvarchar20
10BSID_BAKAccounting: Secondary Index for Customers66MABERDunning Areanvarchar20
11BSIK_BAKAccounting: Secondary index for vendors69MABERDunning Areanvarchar20
12BSSEGAccounting Document Segment148MABERDunning Areanvarchar20
13FUDT_VDOCBSEGVerification Document Item with Additional Info148MABERDunning Areanvarchar20
14FUDT_VDOCBSEGEVVerification Document Item in the Entry View148MABERDunning Areanvarchar20
15FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)148MABERDunning Areanvarchar20
16GLPOS_C_CTFI Document: Entry View168MABERDunning Areanvarchar20
17GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items168MABERDunning Areanvarchar20
18GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items168MABERDunning Areanvarchar20
19GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items168MABERDunning Areanvarchar20
20GLPOS_N_CTNew General Ledger: Line Item with Currency Type171MABERDunning Areanvarchar20
21GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type171MABERDunning Areanvarchar20
22MHNDDunning Data29MABERDunning Areanvarchar20
23REGUPProcessed items from payment program182MABERDunning Areanvarchar20
24T047EForm selection for dunning notices5MABERDunning Areanvarchar20
25T047MDunning areas3MABERDunning Areanvarchar20
26T047NDunning area texts4MABERDunning Areanvarchar20
TOPAccount Determination
27TVTAOrganizational Unit: Sales Area(s)9MABERDunning Areanvarchar20
TOPAccounting
28TDIOA_TEMPLTemplate for Interest On Arrears Calculation10MABERDunning Areanvarchar20
29VDDUNN_DISPDunning run data per loan and dunning run5MABERDunning Areanvarchar20
TOPAccounting Interface
30GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)118MABERDunning Areanvarchar20
31GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)118MABERDunning Areanvarchar20
TOPAdvertising Management
32JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header84MABERDunning Areanvarchar20
TOPBasic Functions
33KNKKF1Credit Management: FI Status Data11MABERA/R Summary: Dunning Area (Highest Dunning Level)nvarchar20
TOPBilling
34VBRKBilling Document: Header Data54MABERDunning Areanvarchar20
TOPBusiness Partner Enhancements for Financial Services
35MAHNS_DIAccounts blocked by dunning selection5MABERDunning Areanvarchar20
TOPCross-Application Components
36BBSIDAccounting: Secondary index for customers66MABERDunning Areanvarchar20
TOPDunning
37MAHNSAccounts blocked by dunning selection5MABERDunning Areanvarchar20
38T047IStandard texts for dunning notices3MABERDunning Areanvarchar20
TOPFinancial Accounting
39BSADAccounting: Secondary Index for Customers (Cleared Items)66MABERDunning Areanvarchar20
40BSAKAccounting: Secondary Index for Vendors (Cleared Items)69MABERDunning Areanvarchar20
41BSIDAccounting: Secondary Index for Customers66MABERDunning Areanvarchar20
42BSIKAccounting: Secondary Index for Vendors69MABERDunning Areanvarchar20
43KNB5Customer master (dunning data)4MABERDunning Areanvarchar20
44LFB5Vendor master (dunning data)4MABERDunning Areanvarchar20
45VBSEGDDocument Segment for Customer Document Parking79MABERDunning Areanvarchar20
46VBSEGKDocument Segment for Vendor Document Parking87MABERDunning Areanvarchar20
TOPFlexible Real Estate Management
47TIVXCRACHDUNNADunning Area per Posting Procedure4MABERDunning Areanvarchar20
TOPFunds Management-Specific Postings
48PSO06Assign Revenue Type/Dunning Area4MABERDunning Areanvarchar20
49PSO47Assign Dunning Procedure to Dunning Area3MABERDunning Areanvarchar20
50PSOSEGDDocument Segment: Recurring Request, Customer80MABERDunning Areanvarchar20
51PSOSEGKRecurring Request Document Segment, Vendors88MABERDunning Areanvarchar20
TOPInformation System
52BWPOSValuations for Open Items29MABERDunning Areanvarchar20
TOPLoans Management
53TD47EForm selection for dunning notices4MABERDunning Areanvarchar20
54TDDEFPRODControl Dunning Using Product Type4MABERDunning Areanvarchar20
55TDREPAY_TEMPLTable for Payoff and Notice Templates32MABERDunning Areanvarchar20
56TTONFTVDARLTest neue Fima: Grunddaten und VDARL83MABERMahnbereichnvarchar20
57TTONFTVVZZKOPOTest neue Fima: VVZZKOPO30MABERMahnbereichnvarchar20
58TTONFTVZZBEPPTest neue FIMA: VZZBEPP153MABERMahnbereichnvarchar20
59VDARLLoans69MABERDunning Areanvarchar20
60VDBEPIPosted line items for document header50MABERDunning Areanvarchar20
61VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)50MABERDunning Areanvarchar20
62VDBEPPFlow Data - Planned Item84MABERDunning Areanvarchar20
63VDBOBEPPBusiness Operation: Entered and Activated Flow Data84MABERDunning Areanvarchar20
64VDCFWAREHOUSECash Flow Management72MABERDunning Areanvarchar20
65VDDEF_COUNTERNumber of Times in Arrears per Days Past Due Category5MABERDunning Areanvarchar20
66VDDUNNDunning run data per loan and dunning run5MABERDunning Areanvarchar20
67VDREPAYMENTPayoff Master Data85MABERDunning Areanvarchar20
68VZFZE_VDBEPPCentral Entry Table for Release Procedure87MABERDunning Areanvarchar20
TOPLocalization
69J_3RFTAX_EXTRDTax Extract Detail Lines41MABERDunning Areanvarchar20
70RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions39MABERDunning Areanvarchar20
71RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions39MABERDunning Areanvarchar20
72RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions39MABERDunning Areanvarchar20
TOPMaster Data
73VDESCROWKOPO0TEMPORARY USE: Escrow Condition Items29MABERDunning Areanvarchar20
TOPPatient Accounting
74NVBRKIS-H: Billing document header data42MABERDunning Areanvarchar20
75TN22PIS-H: Control Parameters FI Posting Down Payment8MABERIS-H: Dunning Areanvarchar20
76TN22QIS-H: Control Parameters FI Posting Copayment Request7MABERIS-H: Dunning Areanvarchar20
77TN22RIS-H: Control Params FI Posting Copayment/Copay.Cred.Memo8MABERIS-H: Dunning Areanvarchar20
78TN22SIS-H: Control Parameters FI Posting Down Payment Request7MABERIS-H: Dunning Areanvarchar20
TOPPeriodical Sales and Distribution
79JFRKIS-M/SD: Billing - Header Data44MABERDunning Areanvarchar20
TOPReal Estate Management
80S407Rental agreements109MABERDunning: areanvarchar20
81VIAKBSEGDocument Line Item from SCS for Interface46MABERDunning Areanvarchar20
82VIMI04Old. replaced in 3.0 with VIMIMV88MABERDunning Areanvarchar20
83VIMIEVSupplementary lease-outs9MABERDunning Areanvarchar20
84VIMIMVLease-Out68MABERDunning: areanvarchar20
85VIRPS407Rental agreements109MABERDunning: areanvarchar20
TOPRemaining Beverage - Obsolete Objects
86/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1150MABERDunning Areanvarchar20
TOPTreasury
87TZPABFinancial Assets Management product types63MABERDunning Areanvarchar20
88VZZKOPOTable condition items32MABERDunning Areanvarchar20
89VZZPAROPartner / Role / Object relationship13MABERDunning Areanvarchar20