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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Financial Services :: Claims Management :: Financial Services Localization
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/GSINS/TA_REPORT801Traffic Accident Report TableFinancial Services Localization
SQL:  selectupdate insert create

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

SELECT MANDT, CLAIM, ACC_LOCAT, DV_QUAN, IP_QUAN, DP_QUAN, MED_EXPERT_FLAG, LOSS_VEHICLE_FLA, LOSS_PROPERTY_FL, POLICEMAN, REG_CERTIFICATEA, REG_CERTIFICATEB, VEHIC_OWNER_A, VEHIC_OWNER_B, VEHIC_DRIVER_A, VEHIC_DRIVER_B, DRIVER_CLS_A, DRIVER_CLS_B, ISSUE_DATE_A, ISSUE_DATE_B, DOCUMENT_A, DOCUMENT_B, INSURER_A, INSURER_B, POLICY_A, POLICY_B, VALID_TO_A, VALID_TO_B, INSURED_FLAG_A, INSURED_FLAG_B, PARK_FLAG_A, PARK_FLAG_B, PARKOUT_FLAG_A, PARKOUT_FLAG_B, PARKING_FLAG_A, PARKING_FLAG_B, ONROAD_FLAG_A, ONROAD_FLAG_B, FROMROAD_FLG_A, FROMROAD_FLG_B, INCROSS_FLAG_A, INCROSS_FLAG_B, OUTCROSS_FLAG_A, OUTCROSS_FLAG_B, SAMELINE_FLAG_A, SAMELINE_FLAG_B, OTHERLINE_FLG_A, OTHERLINE_FLG_B, CHNGLINE_FLG_A, CHNGLINE_FLG_B, OVERTAKE_FLAG_A, OVERTAKE_FLAG_B, RIGHT_FLAG_A, RIGHT_FLAG_B, LEFT_FLAG_A, LEFT_FLAG_B, TURN_FLAG_A, TURN_FLAG_B, BACK_FLAG_A, BACK_FLAG_B, OPPOSITE_FLAG_A, OPPOSITE_FLAG_B, RIGHTVEH_FLAG_A, RIGHTVEH_FLAG_B, SIGNPRIOR_FLG_A, SIGNPRIOR_FLG_B, PEDESTR_FLAG_A, PEDESTR_FLAG_B, STOP_FLAG_A, STOP_FLAG_B, WHO_IS_DRIVERA, WHO_IS_DRIVERB, WHO_IS_OWNERA, WHO_IS_OWNERB, RUNING_ORDRA, RUNING_ORDRB, REPORTDATEA, REPORTDATEB, COMPILERNAME_A, COMPILERNAME_B FROM /GSINS/TA_REPORT
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2CLAIMNumber of Claimnvarchar170 Allow NULL? 
3ACC_LOCATAccident Locationnvarchar500 Allow NULL? 
4DV_QUANNumber of Damaged Vehiclesnvarchar20 Allow NULL? 
5IP_QUANNumber of Injured Personsnvarchar30 Allow NULL? 
6DP_QUANNumber of Fatalitiesnvarchar20 Allow NULL? 
7MED_EXPERT_FLAGMedical Examination for Intoxicationchar10 Allow NULL? 
8LOSS_VEHICLE_FLALoss to Other Vehicleschar10 Allow NULL? 
9LOSS_PROPERTY_FLLoss to Other Propertychar10 Allow NULL? 
10POLICEMANPolice Officer (ID Number)nvarchar100 Allow NULL? 
11REG_CERTIFICATEARegistration Certificate (A)nvarchar100 Allow NULL? 
12REG_CERTIFICATEBRegistration Certificate (B)nvarchar100 Allow NULL? 
13VEHIC_OWNER_AOwner of Vehicle (A)nvarchar200 Allow NULL? 
14VEHIC_OWNER_BOwner of Vehicle (B)nvarchar200 Allow NULL? 
15VEHIC_DRIVER_ADriver of Vehicle (A)nvarchar200 Allow NULL? 
16VEHIC_DRIVER_BDriver of Vehicle (B)nvarchar200 Allow NULL? 
17DRIVER_CLS_ADriver Class (A)char10 Allow NULL? 
18DRIVER_CLS_BDriver Class (B)char10 Allow NULL? 
19ISSUE_DATE_AIssue Date (A)nvarchar80 Allow NULL? 
20ISSUE_DATE_BIssue Date (B)nvarchar80 Allow NULL? 
21DOCUMENT_ADocument to Prove Ownership and Right To Use Vehicle (A)nvarchar150 Allow NULL? 
22DOCUMENT_BDocument to Prove Ownership and Right To Use Vehicle (B)nvarchar150 Allow NULL? 
23INSURER_AInsurer (A)nvarchar200 Allow NULL? 
24INSURER_BInsurer (B)nvarchar200 Allow NULL? 
25POLICY_APolicy Number (A)nvarchar130 Allow NULL? 
26POLICY_BPolicy Number (B)nvarchar130 Allow NULL? 
27VALID_TO_AValid to Date (A)nvarchar80 Allow NULL? 
28VALID_TO_BValid to Date (B)nvarchar80 Allow NULL? 
29INSURED_FLAG_AVehicle Insured Against Losschar10 Allow NULL? 
30INSURED_FLAG_BVehicle Insured Against Losschar10 Allow NULL? 
31PARK_FLAG_AOn Parking Lotchar10 Allow NULL? 
32PARK_FLAG_BOn Parking Lotchar10 Allow NULL? 
33PARKOUT_FLAG_ALeaving Parking Lotchar10 Allow NULL? 
34PARKOUT_FLAG_BLeaving Parking Lotchar10 Allow NULL? 
35PARKING_FLAG_ADriving into Parking Lotchar10 Allow NULL? 
36PARKING_FLAG_BDriving into Parking Lotchar10 Allow NULL? 
37ONROAD_FLAG_ADriving out of Yard, Dirt Trackchar10 Allow NULL? 
38ONROAD_FLAG_BDriving out of Yard, Dirt Trackchar10 Allow NULL? 
39FROMROAD_FLG_ADriving into Yard, Dirt Trackchar10 Allow NULL? 
40FROMROAD_FLG_BDriving into Yard, Dirt Trackchar10 Allow NULL? 
41INCROSS_FLAG_AApproaching Traffic Circlechar10 Allow NULL? 
42INCROSS_FLAG_BApproaching Traffic Circlechar10 Allow NULL? 
43OUTCROSS_FLAG_ALeaving Traffic Circlechar10 Allow NULL? 
44OUTCROSS_FLAG_BLeaving Traffic Circlechar10 Allow NULL? 
45SAMELINE_FLAG_ACollision with Vehicle in Same Direction and Lanechar10 Allow NULL? 
46SAMELINE_FLAG_BCollision with Vehicle in Same Direction and Lanechar10 Allow NULL? 
47OTHERLINE_FLG_ACollision with Vehicle in Same Direction, Different Lanechar10 Allow NULL? 
48OTHERLINE_FLG_BCollision with Vehicle in Same Direction, Different Lanechar10 Allow NULL? 
49CHNGLINE_FLG_AChanging Laneschar10 Allow NULL? 
50CHNGLINE_FLG_BChanging Laneschar10 Allow NULL? 
51OVERTAKE_FLAG_AOvertakingchar10 Allow NULL? 
52OVERTAKE_FLAG_BOvertakingchar10 Allow NULL? 
53RIGHT_FLAG_ATurning Rightchar10 Allow NULL? 
54RIGHT_FLAG_BTurning Rightchar10 Allow NULL? 
55LEFT_FLAG_ATurning Leftchar10 Allow NULL? 
56LEFT_FLAG_BTurning Leftchar10 Allow NULL? 
57TURN_FLAG_ATurningchar10 Allow NULL? 
58TURN_FLAG_BTurningchar10 Allow NULL? 
59BACK_FLAG_ADriving Backwardschar10 Allow NULL? 
60BACK_FLAG_BDriving Backwardschar10 Allow NULL? 
61OPPOSITE_FLAG_ADriving on the Wrong Side of the Roadchar10 Allow NULL? 
62OPPOSITE_FLAG_BDriving on the Wrong Side of the Roadchar10 Allow NULL? 
63RIGHTVEH_FLAG_AWas on the Right of Second Vehiclechar10 Allow NULL? 
64RIGHTVEH_FLAG_BWas on the Right of Second Vehiclechar10 Allow NULL? 
65SIGNPRIOR_FLG_ADisobeyed Give Way Signchar10 Allow NULL? 
66SIGNPRIOR_FLG_BDisobeyed Give Way Signchar10 Allow NULL? 
67PEDESTR_FLAG_ACollision with Pedestrian (A)char10 Allow NULL? 
68PEDESTR_FLAG_BCollision with Pedestrian (B)char10 Allow NULL? 
69STOP_FLAG_AStopped at Red Traffic Light (A)char10 Allow NULL? 
70STOP_FLAG_BStopped at Red Traffic Light (B)char10 Allow NULL? 
71WHO_IS_DRIVERADriver of Vehiclechar10 Allow NULL? 
72WHO_IS_DRIVERBDriver of Vehiclechar10 Allow NULL? 
73WHO_IS_OWNERAOwner of Vehiclenvarchar200 Allow NULL? 
74WHO_IS_OWNERBOwner of Vehiclenvarchar200 Allow NULL? 
75RUNING_ORDRAVehicle Is Roadworthychar10 Allow NULL? 
76RUNING_ORDRBVehicle Is Roadworthychar10 Allow NULL? 
77REPORTDATEADate of Traffic Accident Reportnvarchar80 Allow NULL? 
78REPORTDATEBDate of Traffic Accident Reportnvarchar80 Allow NULL? 
79COMPILERNAME_AName of Processornvarchar200 Allow NULL? 
80COMPILERNAME_BName of Processornvarchar200 Allow NULL? 
NamePrimaryUniqueTypeColumns
/GSINS/TA_REPORT~0YesYesCLUSTEREDCLAIM, MANDT