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  | T5G_P46ARV
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
Personnel Management :: Personnel Administration :: Great Britain
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T5G_P46ARV341HR-GB: Archive for P46(Car)-FormsGreat Britain
SQL:  selectupdate insert create

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

SELECT MANDT, SERNR, PERNR, REGNO, FACTO, MODEL, TTYPE, DPLAN, RGNDA, AVADA, WITDA, EGTYP, FUELR, CO2EM, INCFL, LISTP, ACCSS, ADDAC, ONEPD, REGPD, PAYMO, LIMCA, EARPR, RREGNO, RRGNDA, RFACTO, RMODEL, FREAS, ERR_COD, MES_CLS, TAXYR, ISSDATE, UNAME, CRDAT FROM T5G_P46ARV
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2SERNRHR-GB: Serial number of P46(Car)-Forms for employeenvarchar40NUMC(N'0000')NoP08_SERNR Allow NULL? 
3PERNRPersonnel numbernvarchar80NUMC(N'00000000')NoPA0003PERSNO Allow NULL? 
4REGNOLicense plate numbernvarchar100CHAR(N' ')YesP_KFZKZ Allow NULL? 
5FACTOCar manufacturernvarchar20CHAR(N' ')YesT51C1P_FACTO Allow NULL? 
6MODELCar Modelnvarchar60CHAR(N' ')YesT51C3P_MODEL Allow NULL? 
7TTYPECar transmission types (for UK only)char10CHAR(N' ')YesP_TTYPE Allow NULL? 
8DPLANCar Door plan (for UK only)nvarchar40CHAR(N' ')YesP_DPLAN Allow NULL? 
9RGNDARegistration Datenvarchar80DATS(N'00000000')YesP_RGNDA Allow NULL? 
10AVADAHR-GB: P46 Date the car was first available fromnvarchar80DATS(N'00000000')YesP08_AVADA Allow NULL? 
11WITDAHR-GB: P46 Car withdrawal datenvarchar80DATS(N'00000000')YesP08_WITDA Allow NULL? 
12EGTYPFuel typechar10CHAR(N' ')YesP_EGTYP Allow NULL? 
13FUELRFuel rulenvarchar30CHAR(N' ')YesP_FUELR Allow NULL? 
14CO2EMCar C02 Emissionsnvarchar30NUMC(N'000')YesP_CO2EM Allow NULL? 
15INCFLIncluding fuelchar10CHAR(N' ')YesP_INCFL Allow NULL? 
16LISTPCar List Pricedecimal152CURR((0))YesP_LISTP
17ACCSSPaid for Accessoriesdecimal152CURR((0))YesP_ACCSS
18ADDACFurther Accessoriesdecimal152CURR((0))YesP_ADDAC
19ONEPDOne time with hold paymentdecimal152CURR((0))YesP_ONEPD
20REGPDRegular with hold paymentdecimal152CURR((0))YesP_REGPD
21PAYMOPayment Modelnvarchar40CHAR(N' ')Yes*MODE1 Allow NULL? 
22LIMCAEe Earnings exceed P11D limit (or Ee is director)char10CHAR(N' ')YesP08_LIMCA Allow NULL? 
23EARPRHR-GB: Employee's calculated year ratedecimal152CURR((0))YesP08_EARPR
24RREGNOHR-GB: License plate number of the replaced carnvarchar100CHAR(N' ')YesP08_RKFZKZ Allow NULL? 
25RRGNDAHR-GB: Registration date of the replaced carnvarchar80DATS(N'00000000')YesP08_RRGNDA Allow NULL? 
26RFACTOHR-GB: Replaced Car Manufacturernvarchar20CHAR(N' ')YesT51C1P08_RFACTO Allow NULL? 
27RMODELHR-GB: Replaced Car Modelnvarchar60CHAR(N' ')YesT51C3P08_RMODEL Allow NULL? 
28FREASHR-GB: Form reasonnvarchar20CHAR(N' ')YesP08_FREAS Allow NULL? 
29ERR_CODMessage numbernvarchar30CHAR(N' ')YesT100MSGNR Allow NULL? 
30MES_CLSApplication Areanvarchar200CHAR(N' ')YesT100AARBGB Allow NULL? 
31TAXYRHR-GB: Tax year (for reports)nvarchar40NUMC(N'0000')YesP08_TAXYR Allow NULL? 
32ISSDATEHR-GB: P46-Form Date of Issuenvarchar80DATS(N'00000000')YesP08_AUSDT Allow NULL? 
33UNAMEHR-GB: User Namenvarchar400CHAR(N' ')YesP08_UNAME Allow NULL? 
34CRDATHR-GB: P46-Form Date of Creationnvarchar80DATS(N'00000000')YesP08_CRDAT Allow NULL? 
NamePrimaryUniqueTypeColumns
T5G_P46ARV~0YesYesCLUSTEREDPERNR, SERNR, 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