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

Home | ERP 6.0  | TMZR
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
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2WRARTAgency business: Payment typenvarchar40CHAR(N' ')NoWRART Allow NULL? 
3WBTYPSettlement request: Payment typechar10CHAR(N' ')YesWBTYPE Allow NULL? 
4WRTYPEntry category: paymentchar10CHAR(N' ')YesWRTYP Allow NULL? 
5KAPPLApplicationnvarchar20CHAR(N' ')YesT681AKAPPL Allow NULL? 
6LFARTAgency business: Billing document typenvarchar40CHAR(N' ')YesTMFKWFART Allow NULL? 
7LFART_RGAgency Business: Billing Doc. Type - Settlement Req. Listnvarchar40CHAR(N' ')YesTMFKWFART_RG Allow NULL? 
8LFART_BLSettlement request: Billing doc. category - posting listnvarchar40CHAR(N' ')YesTMFKWFART_BL Allow NULL? 
9LFART_BDAgency Business: Billing Type for Customer Settlementnvarchar40CHAR(N' ')YesTMFKWFART_BD Allow NULL? 
10LFART_VSAgency Business: Billing Doc. Type - Vendor Settlementnvarchar40CHAR(N' ')YesTMFKWFART_VS Allow NULL? 
11IDENT1Settlement calendarnvarchar20CHAR(N' ')YesTFACDWRKAL Allow NULL? 
12WZKRLAgency Business: Customer Credit Limit Checkchar10CHAR(N' ')YesWZKRL Allow NULL? 
13WZAHLAgency Business: Customer Terms of Paymentchar10CHAR(N' ')YesWZAHL Allow NULL? 
14WSTBUAgency Business: Post Tax Amountschar10CHAR(N' ')YesWSTBU Allow NULL? 
15WZAHLKSettlement request: vendor payment termschar10CHAR(N' ')YesWZAHLK Allow NULL? 
16WRLPARAgency Business: Remuneration List Recipientchar10CHAR(N' ')YesWRLPAR Allow NULL? 
17WKOPARAgency Business: Condition Determin. Level, Payment Docschar10CHAR(N' ')YesWKOPAR Allow NULL? 
18WDOPZCheck document for duplicate entry (payment processing)char10CHAR(N' ')YesWDOPZ Allow NULL? 
19WVOLPSet sales volume values in accounting documentchar10CHAR(N' ')YesWVOLP Allow NULL? 
20WBUVEAgency Business: Basis for Remuneration List Datechar10CHAR(N' ')YesWBUVE Allow NULL? 
21WBARTOnly include condition data (provisions)char10CHAR(N' ')YesWBART Allow NULL? 
22WTAXCALPayment document: Calculate tax for tax codechar10CHAR(N' ')YesWSTRE Allow NULL? 
23WUNVOPayment document: Incompleteness permittedchar10CHAR(N' ')YesWUNVO Allow NULL? 
24WTAXDSettlement request: Different tax allowedchar10CHAR(N' ')YesWTAXD Allow NULL? 
25WPAYDMethod for determining term of payment for settlm. req. listchar10CHAR(N' ')YesWPAYD Allow NULL? 
26SZBMETHMethod of calculating interest for additional cash discountchar10CHAR(N' ')YesSZBMETHSKT Allow NULL? 
27WPRANAgency business: Profit analysis typenvarchar40CHAR(N' ')YesTMPAWPRAN Allow NULL? 
28STGRPAgency business: Status groupnvarchar40CHAR(N' ')YesTMPA4WSTATG Allow NULL? 
29DEFAULTSTAgency business: Application statusnvarchar40CHAR(N' ')YesTMPA5WSTATE Allow NULL? 
30WKALSAgency Business: Schema determination vendor/custmrchar10CHAR(N' ')YesWKALS Allow NULL? 
31PROFOKAgency business: Application statusnvarchar40CHAR(N' ')YesTMPA5WSTATE Allow NULL? 
32PROFFAILAgency business: Application statusnvarchar40CHAR(N' ')YesTMPA5WSTATE Allow NULL? 
33SETBRTWRAgency Business: Set Gross Value Automaticallychar10CHAR(N' ')YesSETBRTWR Allow NULL? 
34SPLITTSplit FI Documents from Single Settlement Requestschar10CHAR(N' ')YesWLF_SPLITT Allow NULL? 
35TAX_CODE_DETERMTax Code Determinationchar10CHAR(N' ')YesWLF_TAX_CODE_DETERMINATION Allow NULL? 
36REMU_COND_CHECKCheck Remuneration List Conditions for Existence in Documentchar10CHAR(N' ')YesWLF_REMU_COND_CHECK Allow NULL? 
37CROSS_COMPANYAB: Cross-Company Code Payment Documentschar10CHAR(N' ')YesWLF_CROSS_COMPANY Allow NULL? 
38SETTL_PARTYAB: Settlement Partnerchar10CHAR(N' ')YesWLF_SETTLEMENT_PARTY Allow NULL? 
39SETTL_METHODAB: Settlement Procedurechar10CHAR(N' ')YesWLF_SETTLEMENT_METHOD Allow NULL? 
40DEF_SBLOCK_VAB: Settlement Block - Vendornvarchar20CHAR(N' ')YesTMSBWLF_SETTLEMENT_BLOCK_V Allow NULL? 
41DEF_SBLOCK_CAB: Settlement Block - Customernvarchar20CHAR(N' ')YesTMSBWLF_SETTLEMENT_BLOCK_C Allow NULL? 
42DEF_SBLOCK_I_VAB: Settlement Block - Item - Vendornvarchar20CHAR(N' ')YesTMSBWLF_SETTLEMENT_BLOCK_ITEM_V Allow NULL? 
43DEF_SBLOCK_I_CAB: Settlement Block - Item - Customernvarchar20CHAR(N' ')YesTMSBWLF_SETTLEMENT_BLOCK_ITEM_C Allow NULL? 
44SETTL_VIA_SR_VAB: Settlement Vendor Using Settlement Requestchar10CHAR(N' ')YesWLF_SETTLEMENT_VIA_SR_V Allow NULL? 
45SETTL_VIA_SR_CAB: Settlement Customer Using Settlement Requestchar10CHAR(N' ')YesWLF_SETTLEMENT_VIA_SR_C Allow NULL? 
46VS_DOC_CREATIONAB: Generation of Vendor Settlementchar10CHAR(N' ')YesWLF_VENDOR_SETTLEMENT_CREATION Allow NULL? 
47CS_DOC_CREATIONAB: Customer-Settlement Generationchar10CHAR(N' ')YesWLF_CUST_SETTLEMENT_CREATION Allow NULL? 
48SCENARIO_SUBTYPFSL: Scenario Subtype for Contract Determinationnvarchar30CHAR(N' ')YesFSL_SCENARIO_SUBTYP Allow NULL? 
49XIF_KIDNO_CHECKGeneral Flagchar10CHAR(N' ')YesFLAG Allow NULL? 
50XIF_ACTIVEGeneral Flagchar10CHAR(N' ')YesFLAG Allow NULL? 
51XIF_FN_MAPSENDFunction namenvarchar300CHAR(N' ')YesTFDIRFUNCNAME Allow NULL? 
52XIF_FN_MAPSAVEFunction namenvarchar300CHAR(N' ')YesTFDIRFUNCNAME Allow NULL? 
53STATUS_OUTAgency business: Application statusnvarchar40CHAR(N' ')YesTMPA5WSTATE Allow NULL? 
54STATUS_IN_ERRAgency business: Application statusnvarchar40CHAR(N' ')YesTMPA5WSTATE Allow NULL? 
55STATUS_IN_RELAgency business: Application statusnvarchar40CHAR(N' ')YesTMPA5WSTATE Allow NULL? 
56KUNRE_DUMBill-to partynvarchar100CHAR(N' ')YesKNA1KUNRE Allow NULL? 
57LIFRE_DUMDifferent Invoicing Partynvarchar100CHAR(N' ')YesLFA1LIFRE Allow NULL? 
58STATUS_ERRAgency business: Application statusnvarchar40CHAR(N' ')YesTMPA5WSTATE Allow NULL? 
59USE_CRMBILLINGGeneral Flagchar10CHAR(N' ')YesFLAG Allow NULL? 
60IV_RELCheck-Relevantchar10CHAR(N' ')YesWLF_IV_REL Allow NULL? 
61FIELDSTATUSGROUPField Status Groupnvarchar40CHAR(N' ')YesTMFSGWLF_FIELDSTATUSGROUP Allow NULL? 
62COLSORTGROUPColumn Sorting Groupnvarchar40CHAR(N' ')YesTMCSGRWLF_COLSORTGROUP Allow NULL? 
63CHECK_LFARTCheck Allowed Combinations Payment Type / Billing Typechar10CHAR(N' ')YesWLF_CHECK_WRART_LFART Allow NULL? 
64SHOW_ORG_DATARecording of Organizational Datachar10CHAR(N' ')YesWLF_SHOW_ORG_DATA_SCREEN Allow NULL? 
65FULL_ORG_DATAComplete Organizational Data - Settlement Partnerchar10CHAR(N' ')YesWLF_FULL_ORG_DATA Allow NULL? 
66CAT_PROFCost allocation profilenvarchar40CHAR(N' ')YesWCAT_PROFILEWCAT_PROF Allow NULL? 
67CO_DATA_CUSTOwn CO Account Assingment Field for Customerchar10CHAR(N' ')YesWLF_CO_DATA_CUSTOMER Allow NULL? 
68TAX_CODE_MISSINGAB: Handling of Missing Tax Codechar10CHAR(N' ')YesWLF_HANDLE_TAX_CODE_MISSING Allow NULL? 
69PROCESS_TYPEProcess Categorynvarchar40CHAR(N' ')YesWLF_C_PROCTYPEWLF_PROCESS_TYPE Allow NULL? 
70WRART_COLLAD: Payment Type for Collection of Settlement Requestsnvarchar40CHAR(N' ')YesTMZRWLF_WRART_COLLECTION Allow NULL? 
71LFART_COLLAD: Billing Type for Collection of Settlement Requestsnvarchar40CHAR(N' ')YesTMFKWLF_LFART_COLLECTION Allow NULL? 
72COLL_TYPEAD: Collection of Settlement Requestschar10CHAR(N' ')YesWLF_COLLECTION_TYPE Allow NULL? 
73DEF_COLL_BLOCKAB: Block for Collection of Settlement Requestsnvarchar20CHAR(N' ')YesTMSBWLF_COLLECTION_BLOCK Allow NULL? 
74DEF_COLL_BLOCK_IAB: Block Item for Collection of Settlement Requestsnvarchar20CHAR(N' ')YesTMSBWLF_COLLECTION_BLOCK_ITEM Allow NULL? 
75CHECK_AGREL_VENDCheck Relevant for Vendor of Agency Businesschar10CHAR(N' ')YesWLF_CHECK_AGREL_VENDOR Allow NULL? 
76CHECK_AGREL_CUSTCheck Relevant for Customer of Agency Businesschar10CHAR(N' ')YesWLF_CHECK_AGREL_CUSTOMER Allow NULL? 
NamePrimaryUniqueTypeColumns
TMZR~0YesYesCLUSTEREDMANDT, WRART

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy