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  | J_3RF_TP_LIST1A
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
1ERP EHP76.0J_3RF_TP_LIST1A432Information of Notification. List 1A
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, REP_YEAR, CORR_NUM, TRAN_NUMBER, TP_GROUP, TP_STATUS, REASON_121, REASON_122, REASON_123, REASON_124, REASON_131, REASON_132, REASON_133, REASON_134, REASON_135, HOM_GROUP, TRANS_TYP, TRANSPARTY_CODE, PICTIC, PICTIC_COMMENT, PRICE_SOURCE, PRICE_SOURCE_COMMENT, PRICE_SOURCE_CO, PRICING_METH, PRICING_METH_COMMENT, PRICING_METH_CO, INFO_SOURCE_251, INFO_SOURCE_252, INFO_SOURCE_253, INFO_SOURCE_254, INFO_SOURCE_255, INFO_SOURCE_256, INFO_SOURCE_257, INFO_SOURCE_258, INFO_SOURCE_259, PARTIES_NUM, PARTIES_NUM_COMMENT, PARTIES_NUM_CO, INCOME_AMOUNT, INCOME_AMOUNT_CP, COSTS_AMOUNT, COSTS_AMOUNT_CP FROM J_3RF_TP_LIST1A
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoJ_3RF_TP_MAINMANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoJ_3RF_TP_MAINBUKRS Allow NULL? 
3REP_YEARReport Yearnvarchar40NUMC(N'0000')NoJ_3RF_TP_MAINJ_3RF_TP_GJAHR Allow NULL? 
4CORR_NUMNumber of Correctionnvarchar30NUMC(N'000')NoJ_3RF_TP_MAINJ_3RF_TP_CORR Allow NULL? 
5TRAN_NUMBERSequential Transaction Number (010)nvarchar100NUMC(N'0000000000')NoJ_3RF_TP_TRANNUMBER Allow NULL? 
6TP_GROUPGroup Codenvarchar100CHAR(N' ')YesJ_3RF_TP_GROUP Allow NULL? 
7TP_STATUSInterdependency (100)char10CHAR(N' ')YesJ_3RF_TP_INTERCHANGEABILITY100 Allow NULL? 
8REASON_121Reason for Control of Transaction (121)char10CHAR(N' ')YesJ_3RF_TP_REASON_121 Allow NULL? 
9REASON_122Reason for Control of Transaction (122)char10CHAR(N' ')YesJ_3RF_TP_REASON_122 Allow NULL? 
10REASON_123Reason for Control of Transaction (123)char10CHAR(N' ')YesJ_3RF_TP_REASON_123 Allow NULL? 
11REASON_124Reason for Control of Transaction (124)char10CHAR(N' ')YesJ_3RF_TP_REASON_124 Allow NULL? 
12REASON_131Reason for Control of Transaction (131)char10CHAR(N' ')YesJ_3RF_TP_REASON_131 Allow NULL? 
13REASON_132Reason for Control of Transaction (132)char10CHAR(N' ')YesJ_3RF_TP_REASON_132 Allow NULL? 
14REASON_133Reason for Control of Transaction (133)char10CHAR(N' ')YesJ_3RF_TP_REASON_133 Allow NULL? 
15REASON_134Reason for Control of Transaction (134)char10CHAR(N' ')YesJ_3RF_TP_REASON_134 Allow NULL? 
16REASON_135Reason for Control of Transaction (135)char10CHAR(N' ')YesJ_3RF_TP_REASON_135 Allow NULL? 
17HOM_GROUPSimilar Transactions Group (200)char10CHAR(N' ')YesJ_3RF_TP_HOMOGROUP_200 Allow NULL? 
18TRANS_TYPTransaction Type (210)nvarchar30CHAR(N' ')YesJ_3RF_TP_TRANS_TYPE_210 Allow NULL? 
19TRANSPARTY_CODECode of Taxpayer Transaction Participant (211)nvarchar30CHAR(N' ')YesJ_3RF_TP_TRANSPARTY_CODE_211 Allow NULL? 
20PICTICRegulated Prices (220)char10CHAR(N' ')YesJ_3RF_TP_PICTIC_220 Allow NULL? 
21PICTIC_COMMENTComment to Regulated Prices (220.1)nvarchar2550CHAR(N' ')YesJ_3RF_TP_PICTIC_COMMENT_220_1 Allow NULL? 
22PRICE_SOURCECode of Transaction Price Determination (230)char10CHAR(N' ')YesJ_3RF_TP_PRICE_SOURCE_230 Allow NULL? 
23PRICE_SOURCE_COMMENTComment to Code of Transaction Price Determination (230.1)nvarchar2550CHAR(N' ')YesJ_3RF_TP_PRICESRCCOMMENT_230_1 Allow NULL? 
24PRICE_SOURCE_COComment to Code of Transaction Price Determination (230.1)nvarchar2550CHAR(N' ')YesJ_3RF_TP_PRICESRCCOMMENT_230_1 Allow NULL? 
25PRICING_METHCode of Pricing Method (240)nvarchar20CHAR(N' ')YesJ_3RF_TP_PRICING_METHOD_240 Allow NULL? 
26PRICING_METH_COMMENTComment to Code of Pricing Method (240.1)nvarchar2550CHAR(N' ')YesJ_3RF_TP_PRICMETHCOMMENT_240_1 Allow NULL? 
27PRICING_METH_COComment to Code of Pricing Method (240.1)nvarchar2550CHAR(N' ')YesJ_3RF_TP_PRICMETHCOMMENT_240_1 Allow NULL? 
28INFO_SOURCE_251Information Source Code (251)char10CHAR(N' ')YesJ_3RF_TP_INFOSOURCE_251 Allow NULL? 
29INFO_SOURCE_252Information Source Code (252)char10CHAR(N' ')YesJ_3RF_TP_INFOSOURCE_252 Allow NULL? 
30INFO_SOURCE_253Information Source Code (253)char10CHAR(N' ')YesJ_3RF_TP_INFOSOURCE_253 Allow NULL? 
31INFO_SOURCE_254Information Source Code (254)char10CHAR(N' ')YesJ_3RF_TP_INFOSOURCE_254 Allow NULL? 
32INFO_SOURCE_255Information Source Code (255)char10CHAR(N' ')YesJ_3RF_TP_INFOSOURCE_255 Allow NULL? 
33INFO_SOURCE_256Information Source Code (256)char10CHAR(N' ')YesJ_3RF_TP_INFOSOURCE_256 Allow NULL? 
34INFO_SOURCE_257Information Source Code (257)char10CHAR(N' ')YesJ_3RF_TP_INFOSOURCE_257 Allow NULL? 
35INFO_SOURCE_258Information Source Code (258)char10CHAR(N' ')YesJ_3RF_TP_INFOSOURCE_258 Allow NULL? 
36INFO_SOURCE_259Information Source Code (259)char10CHAR(N' ')YesJ_3RF_TP_INFOSOURCE_259 Allow NULL? 
37PARTIES_NUMNumber of Transaction Participants (260)nvarchar30CHAR(N' ')YesJ_3RF_TP_PARTIES_NUM_260 Allow NULL? 
38PARTIES_NUM_COMMENTComment to Number of Transaction Participants (260.1)nvarchar2550CHAR(N' ')YesJ_3RF_TP_PARTNUMCOMMENT_260_1 Allow NULL? 
39PARTIES_NUM_COComment to Number of Transaction Participants (260.1)nvarchar2550CHAR(N' ')YesJ_3RF_TP_PARTNUMCOMMENT_260_1 Allow NULL? 
40INCOME_AMOUNTRevenue Amount of Controlled Transaction (300)nvarchar150NUMC(N'000000000000000')YesJ_3RF_TP_INCOME_AMOUNT_300 Allow NULL? 
41INCOME_AMOUNT_CPRevenue Amount of Transaction with Controlled Prices (301)nvarchar150NUMC(N'000000000000000')YesJ_3RF_TP_INCOME_AMOUNT_CP_301 Allow NULL? 
42COSTS_AMOUNTExpenses Amount of Controlled Transaction (310)nvarchar150NUMC(N'000000000000000')YesJ_3RF_TP_COSTS_AMOUNT_310 Allow NULL? 
43COSTS_AMOUNT_CPExpenses Amount of Transaction with Controlled Prices (311)nvarchar150NUMC(N'000000000000000')YesJ_3RF_TP_COSTS_AMOUNT_CP_311 Allow NULL? 
NamePrimaryUniqueTypeColumns
J_3RF_TP_LIST1A~0YesYesCLUSTEREDTRAN_NUMBER, CORR_NUM, REP_YEAR, BUKRS, MANDT
J_3RF_TP_LIST1A~GRNoNoNONCLUSTEREDTP_GROUP, CORR_NUM, REP_YEAR, BUKRS, MANDT

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