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

67 columns | Print definition?ERP 6.0  | STATS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2IN_GEMPayroll India - Global Employment7STATSResident Status of employeenvarchar10
2P2IN_RIPGlobal Employment Past Information7STATSResident Status of employeenvarchar10
3P2RM_MTAXPayroll Result: Tax (DK)11STATSTax card Denmarknvarchar10
4PA0633HR Master Record: Infotype 063326STATSStatus of EEOC casenvarchar10
5PA3319Infotype 331924STATSStatusnvarchar20
6PB0633HR Master Record: Infotype 063326STATSStatus of EEOC casenvarchar10
7T7CNRM_PSTATSReporting Period Status8STATSReporting Statusnvarchar10
8T7CNTPM_ITMTPM: Item7STATSItem Statusnvarchar10
9T7CNTPM_ITMGRPTPM: Programme4STATSItem Statusnvarchar10
10T7CNTPM_ORGGRPTPM: Organization Group3STATSStatus of Organization Groupnvarchar10
11T7CNTPM_PLNTPM: Plan4STATSTotal Payment Planning Statusnvarchar10
12T7CNTPM_PROCRECTPM: Process Record6STATSProcess Statusnvarchar10
13T7INPEL1P2E: Request Log table11STATSP2E: Policy Request Statusnvarchar10
14T7INPEL2P2E: Policy Log table13STATSP2E: Policy Request Statusnvarchar10
15T7NOEDG_ERC_RATEEDAG - ERC rates2STATSEDAG - ERC Calculation Codenvarchar20
TOPBasic functions
16VEKPHandling Unit - Header Table118STATSVehicle Stock Statusnvarchar20
TOPBudgeting
17FMKF_TERM_RBKey Figures - FM Terms10STATSFunds Management Statistical Indicatornvarchar10
TOPClaims Processing Asia
18T7XASTClaims processing transaction table16STATSStatusnvarchar10
TOPConstruction Industry
19PDBKADCI: Social Fund Procedure: Records Management8STATSStatus of Data Record in Social Fund Procedurenvarchar20
20PDBKBESUMConstr. Ind. Social Fund Procedure: BEMEL Records (Total)8STATSStatus of Data Record in Social Fund Procedurenvarchar20
21T5DB9Construction Pay Evaluation Records for Social Fund Proc.12STATSUtilization Status for Evaluation Records SFP Constructionnvarchar10
TOPContract Accounts Receivable and Payable
22DFKKCMPManually Issued Checks Lot: Item Data40STATSStatus of Item in Lot for Manually Issued Checksnvarchar10
TOPDenmark
23PA0072HR Master Record: Infotype 0072 (Fiscal Data - DK)37STATSTax card Denmarknvarchar10
TOPFunds Management
24FCABPFI-CA: Document Item74STATSFunds Management Statistical Indicatornvarchar10
25FMCFAATR-FM: Commitments/Budget Carried Forward12STATSFunds Management Statistical Indicatornvarchar10
26FMCFAASTR-FM: Commitments/Budget Carried Forward (Interim Storage)12STATSFunds Management Statistical Indicatornvarchar10
27FMCFAAS_TRTR-FM: Commitments/Budget Carried Forward (Interim Storage)12STATSFunds Management Statistical Indicatornvarchar10
28FMCFAA_TRTR-FM: Commitments/Budget Carried Forward12STATSFunds Management Statistical Indicatornvarchar10
29FMCFABTR-FM: Commitments/Budget Carried Forward (Sender+Receiver)16STATSFunds Management Statistical Indicatornvarchar10
30FMCFABSTR-FM: Transferred Commitment/Budget (Senders+Receivers)16STATSFunds Management Statistical Indicatornvarchar10
31FMCFABS_TRTR-FM: Transferred Commitment/Budget (Senders+Receivers)16STATSFunds Management Statistical Indicatornvarchar10
32FMCFAB_TRTR-FM: Commitments/Budget Carried Forward (Sender+Receiver)16STATSFunds Management Statistical Indicatornvarchar10
33FMCFSIFFI-FM: Selected Open Documents from FI Update39STATSFunds Management Statistical Indicatornvarchar10
34FMCFSIF_TRSelected Open FI Documents (Settlement)37STATSFunds Management Statistical Indicatornvarchar10
35FMCFSIOFI-FM: Selected Open Commitment Documents42STATSFunds Management Statistical Indicatornvarchar10
36FMCFSIO_TRFI-FM: Selected Open Commitment Documents43STATSFunds Management Statistical Indicatornvarchar10
37FMCICommitment items master data17STATSStatistical commitment itemnvarchar10
38FMIFIITFI Line Item Table in Funds Management29STATSFunds Management Statistical Indicatornvarchar10
39FMIOObject Table for Funds Management15STATSFunds Management Statistical Indicatornvarchar10
40FMIOICommitment Documents Funds Management35STATSFunds Management Statistical Indicatornvarchar10
41FMPGCommitment Items in FM Area/Fiscal Year13STATSStatistical commitment itemnvarchar10
42KBLEDocument Item Processing: Manual Document Entry12STATSReduction is Statisticalnvarchar10
43KBLESUMTotals Table KBLE5STATSReduction is Statisticalnvarchar10
44KBLPDocument Item: Manual Document Entry58STATSFunds Management Statistical Indicatornvarchar10
TOPGeneral status management
45TJ49Table for Selection Conditions per SELID5STATSObject statusnvarchar50
TOPGrantee Management
46GMCOUPDCO Settings for Grants Management Update6STATSStatistical Indicatornvarchar10
47GMFIUPDFI Settings for Grants Management Update7STATSStatistical Indicatornvarchar10
TOPIndia
48T7INGEResident Status Details5STATSResident Status of employeenvarchar10
TOPInformation system
49FMKF_REPTERMKey Figure Terms for Reporting Because of New Budget Tables10STATSFunds Management Statistical Indicatornvarchar10
TOPMaterials Management
50/SAPNEA/JSCCHHI[SC] Chargeable <-> Nonchargeable changing history7STATS[SC] Status for changing component typenvarchar10
TOPNorway
51T5V2JNACE codes (Business area codes; Næringskoder)5STATSCompany status regarding branch and employers contributionnvarchar20
52T5V2NConnection rep. org. no and status for ERC reporting5STATSCompany status regarding branch and employers contributionnvarchar20
TOPPublic Sector
53PA0486HR-SG-PS: Master Data (National Service)26STATSStatus Of National Servicenvarchar20
54PA0756Public Sector Loan Infotype 0756 (Mexico)29STATSLoan Statusnvarchar10
55T5PBSR1BNational Service Status2STATSStatus Of National Servicenvarchar20
56T5PBSR1BTText For National Service Status3STATSStatus Of National Servicenvarchar20
TOPReuse Services for Country Development
57PA3213HR Pensions27STATSEmployee Statusnvarchar10
58T5F99SESubdocument status table12STATSStatusnvarchar20
59T5F99SRDocument status table9STATSStatusnvarchar20
60T5F99STStatus4STATSStatusnvarchar20
61T5F99STTStatus Description5STATSStatusnvarchar20
TOPSocial Insurance
62P01SV_B2ATRNSStatus Table Transfer to Social Insurance Agency4STATSSI: Status of the Transfernvarchar20
TOPTax
63P01E2_LISTMTL_STELStAM: Status Table for Monthly Change Lists4STATSELStAM: Processing Status of Change Listnvarchar20
64P01E2_LIST_STStatus Table for ELStAM Procedure Change Lists4STATSELStAM: Processing Status of Change Listnvarchar20
65P01E2_TRANS_STStatus Table Transfer for ELStAM Procedure6STATSELStAM: Transfer Statusnvarchar20
TOPUSA
66PA0076HR Master Record: Infotype 0076 (Workers Compensation NA)24STATSProcessing statusnvarchar10
TOPYard Management
67LYACTYard activities34STATSVehicle Stock Statusnvarchar20