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  | /GSINS/TA_REPORT
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
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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2CLAIMNumber of Claimnvarchar170CHAR(N' ')No*ICL_CLAIM Allow NULL? 
3ACC_LOCATAccident Locationnvarchar500CHAR(N' ')Yes/GSINS/LOCAT Allow NULL? 
4DV_QUANNumber of Damaged Vehiclesnvarchar20NUMC(N'00')Yes/GSINS/DV_QUAN Allow NULL? 
5IP_QUANNumber of Injured Personsnvarchar30NUMC(N'000')Yes/GSINS/IP_QUAN Allow NULL? 
6DP_QUANNumber of Fatalitiesnvarchar20NUMC(N'00')Yes/GSINS/DP_QUAN Allow NULL? 
7MED_EXPERT_FLAGMedical Examination for Intoxicationchar10CHAR(N' ')Yes/GSINS/MED_EXPERT_FLAG Allow NULL? 
8LOSS_VEHICLE_FLALoss to Other Vehicleschar10CHAR(N' ')Yes/GSINS/LOSSOTHRVHCLFLG Allow NULL? 
9LOSS_PROPERTY_FLLoss to Other Propertychar10CHAR(N' ')Yes/GSINS/LOSSOTHRPROPFLG Allow NULL? 
10POLICEMANPolice Officer (ID Number)nvarchar100CHAR(N' ')Yes/GSINS/PLCMAN_BDG Allow NULL? 
11REG_CERTIFICATEARegistration Certificate (A)nvarchar100CHAR(N' ')Yes/GSINS/REGSERTA Allow NULL? 
12REG_CERTIFICATEBRegistration Certificate (B)nvarchar100CHAR(N' ')Yes/GSINS/REGSERTB Allow NULL? 
13VEHIC_OWNER_AOwner of Vehicle (A)nvarchar200CHAR(N' ')Yes/GSINS/VEHIC_OWNER_A Allow NULL? 
14VEHIC_OWNER_BOwner of Vehicle (B)nvarchar200CHAR(N' ')Yes/GSINS/VEHIC_OWNER_B Allow NULL? 
15VEHIC_DRIVER_ADriver of Vehicle (A)nvarchar200CHAR(N' ')Yes/GSINS/VEHDRIVER Allow NULL? 
16VEHIC_DRIVER_BDriver of Vehicle (B)nvarchar200CHAR(N' ')Yes/GSINS/VEHDRIVERB Allow NULL? 
17DRIVER_CLS_ADriver Class (A)char10CHAR(N' ')Yes/GSINS/DRVR_CLS_A Allow NULL? 
18DRIVER_CLS_BDriver Class (B)char10CHAR(N' ')Yes/GSINS/DRVR_CLS_B Allow NULL? 
19ISSUE_DATE_AIssue Date (A)nvarchar80DATS(N'00000000')Yes/GSINS/ISSUEA Allow NULL? 
20ISSUE_DATE_BIssue Date (B)nvarchar80DATS(N'00000000')Yes/GSINS/ISSUEB Allow NULL? 
21DOCUMENT_ADocument to Prove Ownership and Right To Use Vehicle (A)nvarchar150CHAR(N' ')Yes/GSINS/DOCUMENT_A Allow NULL? 
22DOCUMENT_BDocument to Prove Ownership and Right To Use Vehicle (B)nvarchar150CHAR(N' ')Yes/GSINS/DOCUMENT_B Allow NULL? 
23INSURER_AInsurer (A)nvarchar200CHAR(N' ')Yes/GSINS/INSURER_A Allow NULL? 
24INSURER_BInsurer (B)nvarchar200CHAR(N' ')Yes/GSINS/INSURER_B Allow NULL? 
25POLICY_APolicy Number (A)nvarchar130CHAR(N' ')Yes/GSINS/POLICY_A Allow NULL? 
26POLICY_BPolicy Number (B)nvarchar130CHAR(N' ')Yes/GSINS/POLICY_B Allow NULL? 
27VALID_TO_AValid to Date (A)nvarchar80DATS(N'00000000')Yes/GSINS/VALIDTOA Allow NULL? 
28VALID_TO_BValid to Date (B)nvarchar80DATS(N'00000000')Yes/GSINS/VALIDTOB Allow NULL? 
29INSURED_FLAG_AVehicle Insured Against Losschar10CHAR(N' ')Yes/GSINS/INSUREDA Allow NULL? 
30INSURED_FLAG_BVehicle Insured Against Losschar10CHAR(N' ')Yes/GSINS/INSUREDB Allow NULL? 
31PARK_FLAG_AOn Parking Lotchar10CHAR(N' ')Yes/GSINS/PARKA Allow NULL? 
32PARK_FLAG_BOn Parking Lotchar10CHAR(N' ')Yes/GSINS/PARKB Allow NULL? 
33PARKOUT_FLAG_ALeaving Parking Lotchar10CHAR(N' ')Yes/GSINS/PARKOUTA Allow NULL? 
34PARKOUT_FLAG_BLeaving Parking Lotchar10CHAR(N' ')Yes/GSINS/PARKOUTB Allow NULL? 
35PARKING_FLAG_ADriving into Parking Lotchar10CHAR(N' ')Yes/GSINS/PARKINGA Allow NULL? 
36PARKING_FLAG_BDriving into Parking Lotchar10CHAR(N' ')Yes/GSINS/PARKINGB Allow NULL? 
37ONROAD_FLAG_ADriving out of Yard, Dirt Trackchar10CHAR(N' ')Yes/GSINS/ONROADA Allow NULL? 
38ONROAD_FLAG_BDriving out of Yard, Dirt Trackchar10CHAR(N' ')Yes/GSINS/ONROADB Allow NULL? 
39FROMROAD_FLG_ADriving into Yard, Dirt Trackchar10CHAR(N' ')Yes/GSINS/FROMROADA Allow NULL? 
40FROMROAD_FLG_BDriving into Yard, Dirt Trackchar10CHAR(N' ')Yes/GSINS/FROMROADB Allow NULL? 
41INCROSS_FLAG_AApproaching Traffic Circlechar10CHAR(N' ')Yes/GSINS/INCROSSA Allow NULL? 
42INCROSS_FLAG_BApproaching Traffic Circlechar10CHAR(N' ')Yes/GSINS/INCROSSB Allow NULL? 
43OUTCROSS_FLAG_ALeaving Traffic Circlechar10CHAR(N' ')Yes/GSINS/OUTCROSS Allow NULL? 
44OUTCROSS_FLAG_BLeaving Traffic Circlechar10CHAR(N' ')Yes/GSINS/OUTCROSS Allow NULL? 
45SAMELINE_FLAG_ACollision with Vehicle in Same Direction and Lanechar10CHAR(N' ')Yes/GSINS/SAMELINE Allow NULL? 
46SAMELINE_FLAG_BCollision with Vehicle in Same Direction and Lanechar10CHAR(N' ')Yes/GSINS/SAMELINE Allow NULL? 
47OTHERLINE_FLG_ACollision with Vehicle in Same Direction, Different Lanechar10CHAR(N' ')Yes/GSINS/OTHERLINE Allow NULL? 
48OTHERLINE_FLG_BCollision with Vehicle in Same Direction, Different Lanechar10CHAR(N' ')Yes/GSINS/OTHERLINE Allow NULL? 
49CHNGLINE_FLG_AChanging Laneschar10CHAR(N' ')Yes/GSINS/CHNGLINE Allow NULL? 
50CHNGLINE_FLG_BChanging Laneschar10CHAR(N' ')Yes/GSINS/CHNGLINE Allow NULL? 
51OVERTAKE_FLAG_AOvertakingchar10CHAR(N' ')Yes/GSINS/OVERTAKE Allow NULL? 
52OVERTAKE_FLAG_BOvertakingchar10CHAR(N' ')Yes/GSINS/OVERTAKE Allow NULL? 
53RIGHT_FLAG_ATurning Rightchar10CHAR(N' ')Yes/GSINS/RIGHT_FLAG Allow NULL? 
54RIGHT_FLAG_BTurning Rightchar10CHAR(N' ')Yes/GSINS/RIGHT_FLAG Allow NULL? 
55LEFT_FLAG_ATurning Leftchar10CHAR(N' ')Yes/GSINS/LEFT_FLAG Allow NULL? 
56LEFT_FLAG_BTurning Leftchar10CHAR(N' ')Yes/GSINS/LEFT_FLAG Allow NULL? 
57TURN_FLAG_ATurningchar10CHAR(N' ')Yes/GSINS/TURN_FLAG Allow NULL? 
58TURN_FLAG_BTurningchar10CHAR(N' ')Yes/GSINS/TURN_FLAG Allow NULL? 
59BACK_FLAG_ADriving Backwardschar10CHAR(N' ')Yes/GSINS/BACK_FLAG_A Allow NULL? 
60BACK_FLAG_BDriving Backwardschar10CHAR(N' ')Yes/GSINS/BACK_FLAG_B Allow NULL? 
61OPPOSITE_FLAG_ADriving on the Wrong Side of the Roadchar10CHAR(N' ')Yes/GSINS/OPPOSITEA Allow NULL? 
62OPPOSITE_FLAG_BDriving on the Wrong Side of the Roadchar10CHAR(N' ')Yes/GSINS/OPPOSITEB Allow NULL? 
63RIGHTVEH_FLAG_AWas on the Right of Second Vehiclechar10CHAR(N' ')Yes/GSINS/RIGHTVEHA Allow NULL? 
64RIGHTVEH_FLAG_BWas on the Right of Second Vehiclechar10CHAR(N' ')Yes/GSINS/RIGHTVEHB Allow NULL? 
65SIGNPRIOR_FLG_ADisobeyed Give Way Signchar10CHAR(N' ')Yes/GSINS/SIGNPRIORA Allow NULL? 
66SIGNPRIOR_FLG_BDisobeyed Give Way Signchar10CHAR(N' ')Yes/GSINS/SIGNPRIORB Allow NULL? 
67PEDESTR_FLAG_ACollision with Pedestrian (A)char10CHAR(N' ')Yes/GSINS/PEDESTRA Allow NULL? 
68PEDESTR_FLAG_BCollision with Pedestrian (B)char10CHAR(N' ')Yes/GSINS/PEDESTRB Allow NULL? 
69STOP_FLAG_AStopped at Red Traffic Light (A)char10CHAR(N' ')Yes/GSINS/STOPA Allow NULL? 
70STOP_FLAG_BStopped at Red Traffic Light (B)char10CHAR(N' ')Yes/GSINS/STOPB Allow NULL? 
71WHO_IS_DRIVERADriver of Vehiclechar10CHAR(N' ')Yes/GSINS/OWNERDRIVE Allow NULL? 
72WHO_IS_DRIVERBDriver of Vehiclechar10CHAR(N' ')Yes/GSINS/OWNERDRIVE Allow NULL? 
73WHO_IS_OWNERAOwner of Vehiclenvarchar200CHAR(N' ')Yes/GSINS/VEH_OWNER Allow NULL? 
74WHO_IS_OWNERBOwner of Vehiclenvarchar200CHAR(N' ')Yes/GSINS/VEH_OWNER Allow NULL? 
75RUNING_ORDRAVehicle Is Roadworthychar10CHAR(N' ')Yes/GSINS/RNNGORDR Allow NULL? 
76RUNING_ORDRBVehicle Is Roadworthychar10CHAR(N' ')Yes/GSINS/RNNGORDR Allow NULL? 
77REPORTDATEADate of Traffic Accident Reportnvarchar80DATS(N'00000000')Yes/GSINS/REPDATE Allow NULL? 
78REPORTDATEBDate of Traffic Accident Reportnvarchar80DATS(N'00000000')Yes/GSINS/REPDATE Allow NULL? 
79COMPILERNAME_AName of Processornvarchar200CHAR(N' ')Yes/GSINS/COMPNAME Allow NULL? 
80COMPILERNAME_BName of Processornvarchar200CHAR(N' ')Yes/GSINS/COMPNAME Allow NULL? 
NamePrimaryUniqueTypeColumns
/GSINS/TA_REPORT~0YesYesCLUSTEREDCLAIM, 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