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  | PTRV_SADD
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
6BSEG345Accounting Document Segment
7/ISDFPS/CHVW_E34External Batch Where-Used List
8FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
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
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Financial Accounting :: Travel Management :: Travel Expenses
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PTRV_SADD441Trip Statistics - Add. Receipt DataTravel Expenses
SQL:  selectupdate insert create

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

SELECT MANDT, PERNR, REINR, PERIO, RECEIPTNO, NO_BRFT, COUNTRY, REGION, TT_COMSP, FROM_DATE, TO_DATE, MULTIPLI, DESCRIPT, LOCATION, BUS_PURPO, BUS_REASON, CCOMP, C_DOC, C_TXT, P_CTG, P_PRV, P_DOC, N_STF, N_PTN, N_GST, ANZLU_DEC, ANZDI_DEC, BOOKED_PRICE, DIFF_AMOUNT, DIFF_CURR, REASON, AIR_DEPARTURE, AIR_ARRIVAL, AIRLINE, AIR_CABIN_CLASS, AIR_TIC_NUM, CAR_ODO_READ, SE_NAME, SE_STREET, SE_CITY, SE_STA_PROV, SE_COUNTRY, SE_POSTAL_CODE, SE_CUST_SER_PH FROM PTRV_SADD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PERNRPersonnel Numbernvarchar80NUMC(N'00000000')NoPERNR_D Allow NULL? 
3REINRTrip Numbernvarchar100NUMC(N'0000000000')NoREINR Allow NULL? 
4PERIOTrip Period Numbernvarchar30NUMC(N'000')NoPTRV_PEROD Allow NULL? 
5RECEIPTNODocument Numbernvarchar30CHAR(N' ')NoNRBEL Allow NULL? 
6NO_BRFTNumber of Breakfastsdecimal20DEC((0))YesFRANZ
7COUNTRYTrip Country / Trip Country Groupnvarchar30CHAR(N' ')Yes*LNDGR Allow NULL? 
8REGIONTrip Country/Trip Country Group/Trip Regionnvarchar50CHAR(N' ')Yes*RGION Allow NULL? 
9TT_COMSPTrip Type: Enterprise-Specificchar10CHAR(N' ')Yes*BEREI Allow NULL? 
10FROM_DATEFrom Datenvarchar80DATS(N'00000000')YesFRDAT Allow NULL? 
11TO_DATETo Datenvarchar80DATS(N'00000000')YesTODAT Allow NULL? 
12MULTIPLINumberdecimal30DEC((0))YesERANZ
13DESCRIPTDescriptionnvarchar500CHAR(N' ')YesERDES Allow NULL? 
14LOCATIONLocationnvarchar500CHAR(N' ')YesERPLC Allow NULL? 
15BUS_PURPOBusiness Purposenvarchar500CHAR(N' ')YesBUSPU Allow NULL? 
16BUS_REASONBusiness Partnersnvarchar500CHAR(N' ')YesBUSRE Allow NULL? 
17CCOMPCode of Payment Card Companynvarchar20CHAR(N' ')Yes*CCOMP Allow NULL? 
18C_DOCDocument Number of Credit Card Receiptnvarchar200CHAR(N' ')YesC_DOC Allow NULL? 
19C_TXTDelivered Description of a Credit Card Transactionnvarchar500CHAR(N' ')YesC_TXT Allow NULL? 
20P_CTGProvider Categorychar10CHAR(N' ')YesPROVIDER_CATEGORY Allow NULL? 
21P_PRVProvider Codenvarchar30CHAR(N' ')Yes*PROVIDER_CODE Allow NULL? 
22P_DOCDocument Number of a (Paper) Documentnvarchar200CHAR(N' ')YesP_DOC Allow NULL? 
23N_STFNumber of Employeesnvarchar30CHAR(N' ')YesCH_NO_STAFF Allow NULL? 
24N_PTNNumber of Employees of Business Partnersnvarchar30CHAR(N' ')YesCH_NO_PARTNERS Allow NULL? 
25N_GSTNumber of Additional Guestsnvarchar30CHAR(N' ')YesCH_NO_GUESTS Allow NULL? 
26ANZLU_DECNumber of Lunches on Hotel Receiptdecimal30DEC((0))YesPTRV_ANZLU_DEC
27ANZDI_DECNumber of Dinners on Hotel Receiptdecimal30DEC((0))YesPTRV_ANZDI_DEC
28BOOKED_PRICEBooked Price from Travel Planningdecimal102CURR((0))YesBOOKED_PRICE
29DIFF_AMOUNTDifference Amountdecimal102CURR((0))YesDIFF_AMOUNT
30DIFF_CURRCurrency of Difference Amountnvarchar50CUKY(N' ')Yes*DIFF_CURR Allow NULL? 
31REASONReason for Differencenvarchar500CHAR(N' ')YesPTRV_REASON Allow NULL? 
32AIR_DEPARTUREIATA - Airport Locationnvarchar30CHAR(N' ')Yes*AIR_LOCATION Allow NULL? 
33AIR_ARRIVALIATA - Airport Locationnvarchar30CHAR(N' ')Yes*AIR_LOCATION Allow NULL? 
34AIRLINEAirlinenvarchar30CHAR(N' ')Yes*AIRLINE Allow NULL? 
35AIR_CABIN_CLASSCabin Classchar10CHAR(N' ')YesAIR_CABIN_CLASS Allow NULL? 
36AIR_TIC_NUMTicket Numbernvarchar150CHAR(N' ')YesPTRV_TICKET_NUMBER Allow NULL? 
37CAR_ODO_READOdometer Mileagenvarchar80NUMC(N'00000000')YesCAR_ODOMETER_READING Allow NULL? 
38SE_NAMEName 1nvarchar400CHAR(N' ')YesAD_NAME1 Allow NULL? 
39SE_STREETStreetnvarchar600CHAR(N' ')YesAD_STREET Allow NULL? 
40SE_CITYCitynvarchar400CHAR(N' ')YesAD_CITY1 Allow NULL? 
41SE_STA_PROVDistrict (US: County)nvarchar400CHAR(N' ')YesSE_STATE_PROVINCE Allow NULL? 
42SE_COUNTRYCountry of Vendornvarchar30CHAR(N' ')Yes*SE_COUNTRY Allow NULL? 
43SE_POSTAL_CODECity postal codenvarchar100CHAR(N' ')YesAD_PSTCD1 Allow NULL? 
44SE_CUST_SER_PHCustomer Service Telephone No. of Vendornvarchar300CHAR(N' ')YesSE_CUSTOMER_SERVICE_PHONE Allow NULL? 
NamePrimaryUniqueTypeColumns
PTRV_SADD~0YesYesCLUSTEREDRECEIPTNO, PERIO, REINR, PERNR, 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