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
Logistics - General :: Agency Business Global Trade
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TMZR761Agency Business: Payment TypesAgency Business Global Trade
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, WRART, WBTYP, WRTYP, KAPPL, LFART, LFART_RG, LFART_BL, LFART_BD, LFART_VS, IDENT1, WZKRL, WZAHL, WSTBU, WZAHLK, WRLPAR, WKOPAR, WDOPZ, WVOLP, WBUVE, WBART, WTAXCAL, WUNVO, WTAXD, WPAYD, SZBMETH, WPRAN, STGRP, DEFAULTST, WKALS, PROFOK, PROFFAIL, SETBRTWR, SPLITT, TAX_CODE_DETERM, REMU_COND_CHECK, CROSS_COMPANY, SETTL_PARTY, SETTL_METHOD, DEF_SBLOCK_V, DEF_SBLOCK_C, DEF_SBLOCK_I_V, DEF_SBLOCK_I_C, SETTL_VIA_SR_V, SETTL_VIA_SR_C, VS_DOC_CREATION, CS_DOC_CREATION, SCENARIO_SUBTYP, XIF_KIDNO_CHECK, XIF_ACTIVE, XIF_FN_MAPSEND, XIF_FN_MAPSAVE, STATUS_OUT, STATUS_IN_ERR, STATUS_IN_REL, KUNRE_DUM, LIFRE_DUM, STATUS_ERR, USE_CRMBILLING, IV_REL, FIELDSTATUSGROUP, COLSORTGROUP, CHECK_LFART, SHOW_ORG_DATA, FULL_ORG_DATA, CAT_PROF, CO_DATA_CUST, TAX_CODE_MISSING, PROCESS_TYPE, WRART_COLL, LFART_COLL, COLL_TYPE, DEF_COLL_BLOCK, DEF_COLL_BLOCK_I, CHECK_AGREL_VEND, CHECK_AGREL_CUST FROM TMZR
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2WRARTAgency business: Payment typenvarchar40 Allow NULL? 
3WBTYPSettlement request: Payment typechar10 Allow NULL? 
4WRTYPEntry category: paymentchar10 Allow NULL? 
5KAPPLApplicationnvarchar20 Allow NULL? 
6LFARTAgency business: Billing document typenvarchar40 Allow NULL? 
7LFART_RGAgency Business: Billing Doc. Type - Settlement Req. Listnvarchar40 Allow NULL? 
8LFART_BLSettlement request: Billing doc. category - posting listnvarchar40 Allow NULL? 
9LFART_BDAgency Business: Billing Type for Customer Settlementnvarchar40 Allow NULL? 
10LFART_VSAgency Business: Billing Doc. Type - Vendor Settlementnvarchar40 Allow NULL? 
11IDENT1Settlement calendarnvarchar20 Allow NULL? 
12WZKRLAgency Business: Customer Credit Limit Checkchar10 Allow NULL? 
13WZAHLAgency Business: Customer Terms of Paymentchar10 Allow NULL? 
14WSTBUAgency Business: Post Tax Amountschar10 Allow NULL? 
15WZAHLKSettlement request: vendor payment termschar10 Allow NULL? 
16WRLPARAgency Business: Remuneration List Recipientchar10 Allow NULL? 
17WKOPARAgency Business: Condition Determin. Level, Payment Docschar10 Allow NULL? 
18WDOPZCheck document for duplicate entry (payment processing)char10 Allow NULL? 
19WVOLPSet sales volume values in accounting documentchar10 Allow NULL? 
20WBUVEAgency Business: Basis for Remuneration List Datechar10 Allow NULL? 
21WBARTOnly include condition data (provisions)char10 Allow NULL? 
22WTAXCALPayment document: Calculate tax for tax codechar10 Allow NULL? 
23WUNVOPayment document: Incompleteness permittedchar10 Allow NULL? 
24WTAXDSettlement request: Different tax allowedchar10 Allow NULL? 
25WPAYDMethod for determining term of payment for settlm. req. listchar10 Allow NULL? 
26SZBMETHMethod of calculating interest for additional cash discountchar10 Allow NULL? 
27WPRANAgency business: Profit analysis typenvarchar40 Allow NULL? 
28STGRPAgency business: Status groupnvarchar40 Allow NULL? 
29DEFAULTSTAgency business: Application statusnvarchar40 Allow NULL? 
30WKALSAgency Business: Schema determination vendor/custmrchar10 Allow NULL? 
31PROFOKAgency business: Application statusnvarchar40 Allow NULL? 
32PROFFAILAgency business: Application statusnvarchar40 Allow NULL? 
33SETBRTWRAgency Business: Set Gross Value Automaticallychar10 Allow NULL? 
34SPLITTSplit FI Documents from Single Settlement Requestschar10 Allow NULL? 
35TAX_CODE_DETERMTax Code Determinationchar10 Allow NULL? 
36REMU_COND_CHECKCheck Remuneration List Conditions for Existence in Documentchar10 Allow NULL? 
37CROSS_COMPANYAB: Cross-Company Code Payment Documentschar10 Allow NULL? 
38SETTL_PARTYAB: Settlement Partnerchar10 Allow NULL? 
39SETTL_METHODAB: Settlement Procedurechar10 Allow NULL? 
40DEF_SBLOCK_VAB: Settlement Block - Vendornvarchar20 Allow NULL? 
41DEF_SBLOCK_CAB: Settlement Block - Customernvarchar20 Allow NULL? 
42DEF_SBLOCK_I_VAB: Settlement Block - Item - Vendornvarchar20 Allow NULL? 
43DEF_SBLOCK_I_CAB: Settlement Block - Item - Customernvarchar20 Allow NULL? 
44SETTL_VIA_SR_VAB: Settlement Vendor Using Settlement Requestchar10 Allow NULL? 
45SETTL_VIA_SR_CAB: Settlement Customer Using Settlement Requestchar10 Allow NULL? 
46VS_DOC_CREATIONAB: Generation of Vendor Settlementchar10 Allow NULL? 
47CS_DOC_CREATIONAB: Customer-Settlement Generationchar10 Allow NULL? 
48SCENARIO_SUBTYPFSL: Scenario Subtype for Contract Determinationnvarchar30 Allow NULL? 
49XIF_KIDNO_CHECKGeneral Flagchar10 Allow NULL? 
50XIF_ACTIVEGeneral Flagchar10 Allow NULL? 
51XIF_FN_MAPSENDFunction namenvarchar300 Allow NULL? 
52XIF_FN_MAPSAVEFunction namenvarchar300 Allow NULL? 
53STATUS_OUTAgency business: Application statusnvarchar40 Allow NULL? 
54STATUS_IN_ERRAgency business: Application statusnvarchar40 Allow NULL? 
55STATUS_IN_RELAgency business: Application statusnvarchar40 Allow NULL? 
56KUNRE_DUMBill-to partynvarchar100 Allow NULL? 
57LIFRE_DUMDifferent Invoicing Partynvarchar100 Allow NULL? 
58STATUS_ERRAgency business: Application statusnvarchar40 Allow NULL? 
59USE_CRMBILLINGGeneral Flagchar10 Allow NULL? 
60IV_RELCheck-Relevantchar10 Allow NULL? 
61FIELDSTATUSGROUPField Status Groupnvarchar40 Allow NULL? 
62COLSORTGROUPColumn Sorting Groupnvarchar40 Allow NULL? 
63CHECK_LFARTCheck Allowed Combinations Payment Type / Billing Typechar10 Allow NULL? 
64SHOW_ORG_DATARecording of Organizational Datachar10 Allow NULL? 
65FULL_ORG_DATAComplete Organizational Data - Settlement Partnerchar10 Allow NULL? 
66CAT_PROFCost allocation profilenvarchar40 Allow NULL? 
67CO_DATA_CUSTOwn CO Account Assingment Field for Customerchar10 Allow NULL? 
68TAX_CODE_MISSINGAB: Handling of Missing Tax Codechar10 Allow NULL? 
69PROCESS_TYPEProcess Categorynvarchar40 Allow NULL? 
70WRART_COLLAD: Payment Type for Collection of Settlement Requestsnvarchar40 Allow NULL? 
71LFART_COLLAD: Billing Type for Collection of Settlement Requestsnvarchar40 Allow NULL? 
72COLL_TYPEAD: Collection of Settlement Requestschar10 Allow NULL? 
73DEF_COLL_BLOCKAB: Block for Collection of Settlement Requestsnvarchar20 Allow NULL? 
74DEF_COLL_BLOCK_IAB: Block Item for Collection of Settlement Requestsnvarchar20 Allow NULL? 
75CHECK_AGREL_VENDCheck Relevant for Vendor of Agency Businesschar10 Allow NULL? 
76CHECK_AGREL_CUSTCheck Relevant for Customer of Agency Businesschar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
TMZR~0YesYesCLUSTEREDMANDT, WRART