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

96 columns | Print definition?ERP 6.0  | BRANCH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/RCFUIX/LOC_BRNAssigment of Locantion to Branch2BRANCHBusiness Partner Numbernvarchar100
2/SAPPSSRM/PYMTPayment Details9BRANCHBranch Namenvarchar500
3CIAP_D_RECORDCIAP Record4BRANCHBusiness Placenvarchar40
4IDOM_CC_COMPTTexts of Additional Company Code Parametres (Oman)6BRANCHBranchnvarchar480
5IDSAU_CC_COMPTTexts of Additional Company Code Parametres for KSA9BRANCHBranchnvarchar480
6ITMF_D_FISC_PERIFiscal Period3BRANCHBusiness Placenvarchar40
7ITMF_D_NFACCTNota fiscal writer configurable accounts5BRANCHBusiness Placenvarchar40
8ITMF_D_NFACCTTAXNota fiscal writer configurable accounts for taxes6BRANCHBusiness Placenvarchar40
9ITMF_INVBrazilian Inventory Adjustment3BRANCHBusiness Placenvarchar40
10ITMF_INV_TXCODEBrazil Taxcode determination for Inventory Adjustment4BRANCHBusiness Placenvarchar40
11J_1BTFISC_IDTax Incentive ID (Incentive ID) table2BRANCHBusiness Placenvarchar40
12J_1UF_REEI_XML_AXML table for J_1UF_REEI with User35BRANCHCompany Branchnvarchar40
13J_1UF_REP_XMLXML table for J_1UF_REP40BRANCHCompany Branchnvarchar40
14J_1UF_REP_XML_AXML table for J_1UF_REEI with User41BRANCHCompany Branchnvarchar40
15J_1UF_RES_XMLXML table for J_1UF_RES39BRANCHCompany Branchnvarchar40
16T011_XBRLFinancial Statement Versions11BRANCHIndustry of XBRL Industry Taxonomynvarchar50
17T5UPBS01FAVORITENature of Actions Favorites Tree3BRANCHApplicationnvarchar40
TOPASAP AcceleratedSAP
18IATNODE01TNode Names for Implementation Assistant4BRANCHIndustrynvarchar150
19SQABRANCHIndustry sector values table1BRANCHIndustrynvarchar150
20SQABRANCHTIndustry sector table table2BRANCHIndustrynvarchar150
21TCUSTEMPCustomizing templates entity table3BRANCHIndustrynvarchar150
22TNODEREVTStructure Item Descriptions for Review Structures4BRANCHIndustrynvarchar150
TOPASAP Tools and Contents
23SMAPTNODETSolution Map: Node texts4BRANCHIndustrynvarchar150
TOPAssetLiability Management
24J_1BBRANCH_FSBranch with local calendar information3BRANCHBusiness Placenvarchar40
25J_1BBRANCH_HOLISpecial local holidays for the branch are maintained in this3BRANCHBusiness Placenvarchar40
26J_1BBRANCH_HOLITSpecial local holidays for the branch are maintained here4BRANCHBusiness Placenvarchar40
TOPAuthoring Tools
27QMM_NODETQMM: General Structure Storage Node Names4BRANCHIndustrynvarchar150
TOPBusiness Navigator
28BMTNODE01TStructure Repository for Process Model Objects: Node Names4BRANCHIndustrynvarchar150
29DFTNODE01TStructure Repository for Process Model Objects: Node Names4BRANCHIndustrynvarchar150
TOPContract Accounts Receivable and Payable
30DFKKEXTDOCOfficial Document Number with Attributes7BRANCHBranchnvarchar40
31DFKKEXTTMPTemporary Entries for Official Document Number12BRANCHBranchnvarchar40
32EBRLIVICMSRegistro de Apuração do ICMS: List control additional acct3BRANCHBusiness Placenvarchar40
33J_1IBUPLA_ADDLAdditional business place data for India eFiling3BRANCHBusiness Placenvarchar40
34TEEXTDOCASSIGNBRTime dependend Nota Fiscal configuration3BRANCHBusiness Placenvarchar40
35TEEXTDOCBRIssuing branch (Nota Fiscal)3BRANCHBranchnvarchar40
36TFK_EXTDOC_AR4Default Values for Branches in Argentina4BRANCHBranchnvarchar40
TOPDistributor-Reseller-Management
37/SAPHT/DRMBUDLBill Up Due List13BRANCHDistributor/ reseller's code for reseller unitnvarchar200
38/SAPHT/DRMREPINVDRM Inventory Reconciliation Reported Inventory6BRANCHDistributor/ reseller's code for reseller unitnvarchar200
39/SAPHT/DRMSDDLShip and Debit Due List43BRANCHDistributor/ reseller's code for reseller unitnvarchar200
40/SAPHT/DRMSTAGDRM Staging Area64BRANCHDistributor/ reseller's code for reseller unitnvarchar200
TOPDocument Management Framework
41KDS_NODETGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
TOPDocument Management Services
42SDOKNODETSDOK: Name of Nodes for General Structure Repository4BRANCHIndustrynvarchar150
TOPE-Recruiting
43HRP5107DB Table for Infotype 510718BRANCHDesired Work Location - Branchnvarchar100
44HRP5126DB Table for Infotype 512622BRANCHBranchnvarchar100
45HRP9901eQuest Posting Information46BRANCHBranchnvarchar100
46HRT5124Table Part Infotype 51246BRANCHBranchnvarchar100
47T77RCFBRANCHCOMPAssignment of Branches to Companies3BRANCHBusiness Partner Numbernvarchar100
TOPeCATT Extended Computer Aided Test Tool
48ECBR_NODETSHI3 ECBR/ECBO - Names of Nodes for eCATT Browser4BRANCHIndustrynvarchar150
TOPFinancial Accounting
49J_1UF_REEII_XMLXML table for J_1UF_REEII35BRANCHCompany Branchnvarchar40
50J_1UF_REEI_XMLXML table for J_1UF_REEI34BRANCHCompany Branchnvarchar40
TOPGL Account Posting
51TCJ_POSITIONSCash Journal Document Items94BRANCHAccount Number of the Branchnvarchar100
TOPHierarchy Storage
52TARCH01TGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
53TNODE01TGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
54TTREV_TEXTHierarchy Tool: Node Text Versioning5BRANCHIndustrynvarchar150
TOPImplementation Guide
55TDOKUIMGTGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
56TNODEIMGTGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
57TNODEPRTGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
58TNODERELNTGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
TOPIntegration Engine
59SXMSMSGREFMessage Reference Storage21BRANCHnvarchar10
TOPInvoicing
60DBEOSBIS-U On-Site Billing21BRANCHBranchnvarchar40
TOPKnowledge Warehouse
61CUSTNODETGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
62IWB0NODETGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
63IWB1NODETGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
64IWB2NODETGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
65IWB7NODETGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
66KWN_NODETGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
67TXML_NODETXML: General Structure Storage Node Names4BRANCHIndustrynvarchar150
TOPLocalization
68J_1BB2Nota Fiscal print configuration3BRANCHBusiness Placenvarchar40
69J_1BB2DYNAMICNota Fiscal Print Configuration dependent on dynamic key3BRANCHBusiness Placenvarchar40
70J_1BBRANCHBusiness Place3BRANCHBusiness Placenvarchar40
71J_1BEFD_LOGElectronic fiscal file log4BRANCHBusiness Placenvarchar40
72J_1BLB08Registro de Apuração do IPI: List control additional accts3BRANCHBusiness Placenvarchar40
73J_1BLB09Registro de Apuração do ICMS: List control additional acct3BRANCHBusiness Placenvarchar40
74J_1BLFA1_REC55Information for generating record type 55 referred to GNRE3BRANCHBusiness Placenvarchar40
75J_1BNFDOCNota Fiscal Header29BRANCHBusiness Placenvarchar40
76J_1BNFENUMCHECKNF-e Number Range - Last checked Number3BRANCHBusiness Placenvarchar40
77J_1BNFENUMGAPNF-e Numbering Gaps3BRANCHBusiness Placenvarchar40
78J_1BNFE_ACTIVEElectronic Nota Fiscal: Actual Status23BRANCHBusiness Placenvarchar40
79J_1BNFE_CONTINNF-e: Contingency Control5BRANCHBusiness Placenvarchar40
80J_1BNFE_CUST01NF-e System Configuration 015BRANCHBusiness Placenvarchar40
81J_1BNFE_CUST2NF-e: System Configuration per Business Place3BRANCHBusiness Placenvarchar40
82J_1BNFE_CUST3NF-e: System Configuration per Business Place3BRANCHBusiness Placenvarchar40
83J_1BNF_PLANTSPlants of same Bus. Place for which Nota Fiscal is created3BRANCHBusiness Placenvarchar40
84J_1BSTASTReg. Tax code for Sub.Trib.3BRANCHBusiness Placenvarchar40
85J_1B_CIAP_FACTORCIAP Factor3BRANCHBusiness Placenvarchar40
86J_1B_CIAP_OBJECTCIAP document data12BRANCHBusiness Placenvarchar40
87J_1B_NFTYPEBRCHNota Fiscal Type Redetermination per Branch for SD3BRANCHBusiness Placenvarchar40
TOPPerformance Assessment Workbench
88KWPWNODETGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
TOPProfitability Analysis
89TKENODE01TGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
90TKEPSVCO-PA: Plan Structure Status Management6BRANCHIdentifier for graphical objectsnvarchar100
TOPSAPscript
91TFORM01TSAPscript Form Tree: Node Names4BRANCHIndustrynvarchar150
TOPService
92DVS1NODETGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
TOPSession Manager
93TMENU01TGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
94TMENUBK01TGeneral Structure Storage Node Names4BRANCHIndustrynvarchar150
TOPTest Organizer
95TNODE02TTest Organizer, Texts4BRANCHIndustrynvarchar150
TOPWorkbench Utilities
96RLB_DB_TRTReuse Library: Structure Repository: Descriptions4BRANCHIndustrynvarchar150