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

64 columns | Print definition?ERP 6.0  | CONTRACT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/AT_APPR_HISApproval History for Level Based Approvals92CONTRACTContract Numbernvarchar130
2/OPT/AT_LBA_LOGApproval History for Level Based Approvals93CONTRACTContract Numbernvarchar130
3/SAPSRM/TT_DATATest Data for SRM Test Tool29CONTRACTContract Numbernvarchar100
4CMM_MTM_CGROUPTMtM Condition Group3CONTRACTAssign to Contractual Value Columnnvarchar10
5DFKKPTSAFTBPEXTDPortugal: SAF-T BP Requesting Receipts Extension7CONTRACTReference Specifications from Contractnvarchar200
6DFKKSAFTINV_SBASAF-T source document extraction rule for Self-Billing Appl.7CONTRACTReference Specifications from Contractnvarchar200
7EPIC_EBR_FEBAdditional Data on Bank Statement Line Item for Bank Receipt43CONTRACTSales Documentnvarchar100
8FIKZD_CONTRACTSSubsoil use contracts2CONTRACTSubsoil use contractnvarchar110
9FIKZD_CONTR_MAPCSubsoil use contracts mapping4CONTRACTSubsoil use contractnvarchar110
10FIKZD_CONTR_MAPPSubsoil use contracts mapping4CONTRACTSubsoil use contractnvarchar110
11ICLCCEVENTCOMultiple Contract Handling - Contract Overview4CONTRACTContract Numbernvarchar170
12ICSCCEVENTCOBearbeitung mehrerer Verträge - Vertragsübersicht4CONTRACTContract Numbernvarchar170
TOPAdvertising Management
13TJHCUSTENVIS-M: Cluster Builder Parameter for Business Partner Envrnmt17CONTRACTDisplay Type for Cluster Builder Object Levelnvarchar10
TOPAgency Business Global Trade
14WBRKAgency business: Header94CONTRACTReferencing Contract Numbernvarchar100
15WBRPAgency business: Item93CONTRACTReferencing Contract Numbernvarchar100
TOPCollectionsDisbursements
16INSCUSTENVINS Information Cluster Builder: Parameters8CONTRACTDisplay Activation for Cluster Builder Object Levelnvarchar10
TOPEmployee Interaction Center
17THREIC_ACTIVITYEIC Activity17CONTRACTService Level Agreement: Contractnvarchar80
18THREIC_ACTSLATGTSLA Contract and Related Target Values for an Activity3CONTRACTService Level Agreement: Contractnvarchar80
19THREIC_SLASLA Contracts2CONTRACTService Level Agreement: Contractnvarchar80
20THREIC_SLA_TSLA Contract Descriptions3CONTRACTService Level Agreement: Contractnvarchar80
21THREIC_SLA_TGTTargets That Are Specified in the SLA Contract2CONTRACTService Level Agreement: Contractnvarchar80
TOPFinancial Accounting
22/OPT/VIM_1HEADDocument Header234CONTRACTPurchasing Document Numbernvarchar100
TOPFront Office
23EWCUSTENVIS-U Information Cluster Builder: Parameter9CONTRACTDisplay Activation for Cluster Builder Object Levelnvarchar10
TOPIntercompany Data Exchange
24TINV_INV_LINE_APayment Advice Line28CONTRACTContractnvarchar100
TOPInvoice Verification
25RBSELCONTRACTInvoice Receipt Contract Selection4CONTRACTContractnvarchar100
26TCULIVCustomizing: Direct Posting in Log. Invoice Verification5CONTRACTPosting to Contract Activenvarchar10
TOPJoint Venture und Production Sharing Accounting
27T8JUJoint Operating Agreement4CONTRACTJV Contract Numbernvarchar240
TOPLocalization
28J_3RFTAXROTax Accounting: Object table19CONTRACTContract Numbernvarchar180
29J_3RFTAXRVOTax Accounting: Object table15CONTRACTContract Numbernvarchar180
30J_3RSEXTRACTDExctract details (obsolete)4CONTRACTContract Numbernvarchar100
TOPMaintenance Notifications
31TQ80OObject info parameters4CONTRACTDisplay if Contract Existsnvarchar10
TOPMedia Product Sales and Distribution
32JKSDLOGORDERSTIS-M: Status Query3CONTRACTSales and Distribution Document Numbernvarchar100
33JKSDPROTOCOLIS-M: Order Generation Log4CONTRACTSales and Distribution Document Numbernvarchar100
TOPPublic Sector Contract Accounts Receivable and Payable
34DFMCA_BRF901BRF: Form Bundle Accounting Data Update9CONTRACTBRF: Expressionnvarchar200
35DFMCA_RETURN_MData Table for Additional Accounting Data in Return6CONTRACTReference Specifications from Contractnvarchar200
36DFMCA_RISK_PROFData Table for Risk Profiles4CONTRACTReference Specifications from Contractnvarchar200
TOPSales and Distribution
37J_1USEXTRACTDEXTRACTD4CONTRACTnvarchar100
TOPService Data Download
38/BDL/BDLDIRFUNCService Definition, Directory functions for add-on collect2CONTRACTTCC contract typenvarchar80
39/BDL/BDLREFSERVService Definition, Contract types2CONTRACTTCC contract typenvarchar80
40/BDL/BDLSERGRPSService Definition, Link between contract type and GROUPID2CONTRACTTCC contract typenvarchar80
41/BDL/BDLSERTRANService Definition, Important information to functions3CONTRACTTCC contract typenvarchar80
42/BDL/BDLSERVICEService Definition, Contract types2CONTRACTTCC contract typenvarchar80
43/BDL/CONTABContent description for following data transmission6CONTRACTTCC contract typenvarchar80
44/BDL/CUSTSE2Management of free sessionnumbers with extensions3CONTRACTCharacter field, 8 characters longnvarchar80
45/BDL/CUSTSESManagement of free sessionnumbers1CONTRACTCharacter field, 8 characters longnvarchar80
46/BDL/MSGLOGMessage log for service data collection or transfer5CONTRACTCharacter field, 8 characters longnvarchar80
47/BDL/SDCCLOGMessage log for service data collection or transfer7CONTRACTCharacter field, 8 characters longnvarchar80
48/BDL/SERVCUSTContract types1CONTRACTTCC contract typenvarchar80
49/BDL/VIEWREPlist of download viewer reports for sdcc1CONTRACTTCC contract typenvarchar80
50/SDF/SERVSTRUCContract types1CONTRACTnvarchar80
51BDLCONTABContent description for following data transmission6CONTRACTContract typenvarchar80
52BDLCUSTSE2Management of free sessionnumbers with extensions3CONTRACTCharacter field, 8 characters longnvarchar80
53BDLCUSTSESManagement of free sessionnumbers1CONTRACTCharacter field, 8 characters longnvarchar80
54BDLDATCOLData container for download data7CONTRACTContract typenvarchar80
55BDLDIRFUNCNames of directory functions for add-on services1CONTRACTContract typenvarchar80
56BDLDTOCRFC download -- Data cluster table of contents6CONTRACTContract typenvarchar80
57BDLMSGLOGMessage log for service data collection or transfer5CONTRACTCharacter field, 8 characters longnvarchar80
58BDLREFSERVContract types1CONTRACTContract typenvarchar80
59BDLSERGRPSLink between contract type and GROUPID1CONTRACTContract typenvarchar80
60BDLSERTRANImportant information to functional modules (download)2CONTRACTContract typenvarchar80
61BDLSERVICEContract types1CONTRACTContract typenvarchar80
62BDLVIEWREPlist of download viewer reports for sdcc1CONTRACTContract typenvarchar80
TOPSpecial Purpose Ledger
63/CCIS/PBU18OPBU18: Object table17CONTRACTContract Numbernvarchar180
TOPWaste Management
64EWACUSTENVIS-U Waste, Information Cluster Builder: Parameters12CONTRACTDisplay Activation for Cluster Builder Object Levelnvarchar10