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_ARCH_PERIO
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 Accounting :: Travel Management :: Travel Expenses
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PTRV_ARCH_PERIO681Prearchiving FI-TV: Entries from PTRV_PERIO (Temporary)Travel Expenses
SQL:  selectupdate insert create

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

SELECT MANDT, PERNR, REINR, PERIO, PDVRS, HDVRS, PDATV, PUHRV, PDATB, PUHRB, DRUCK, ANTRG, ABREC, UEBLG, UEBRF, UEBDT, TLOCK, WAERS, ABRJ1, ABRP1, PERM1, ABKR1, BEGP1, ENDP1, ABRJ2, ABRP2, PERM2, ABKR2, BEGP2, ENDP2, ACCDT, ACCTM, RUNID, VERPA, UEBKZ, ANUEP, NO_MILES, LSTAY, TR_DOPP_ANZAHL, TR_EINF_ANZAHL, TR_ENTFERNUNG, VU_EA_DOPP_ANZ, VU_EA_EINF_ANZ, VU_EA_ENTFERN, VU_EA_KM_SATZ, NU_EA_DOPP_ANZ, NU_EA_EINF_ANZ, NU_EA_ENTFERN, NU_EA_KM_SATZ, V_UNENTGELTLICH, U_UNENTGELTLICH, REDUC_ERGRU, NOT_PAID, WEG_ERH_MAX, ERH_DIENST_INT, ENTF_WO_DO, DRITTMITTEL, ANTRAG_GWE, POLICY_VIOLATION, EXCEPTION_FLAG, NR_RECEIPTS, PERM_TRIP_APPR, TR_NR_FROM_HOME, VAT_STATUS, EST_COST_PLAN, EST_COST_REQ, REASON, TAX_TRIP FROM PTRV_ARCH_PERIO
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? 
5PDVRSSequential Number of Periodnvarchar20NUMC(N'00')NoPTRV_PDVRS Allow NULL? 
6HDVRSSequential Number of Travel Expenses Table THEADERnvarchar20NUMC(N'00')YesPTRV_HDVRS Allow NULL? 
7PDATVBeginning Date of Trip Segmentnvarchar80DATS(N'00000000')YesREBED Allow NULL? 
8PUHRVBeginning Time of Trip Segmentnvarchar60TIMS(N'000000')YesREBEU Allow NULL? 
9PDATBEnd Date of Trip Segmentnvarchar80DATS(N'00000000')YesREEND Allow NULL? 
10PUHRBEnd Time of Trip Segmentnvarchar60TIMS(N'000000')YesREENU Allow NULL? 
11DRUCKTrip Print Statuschar10CHAR(N' ')YesP_PRINT Allow NULL? 
12ANTRGTravel Request or Trip Approved (Indicator)char10CHAR(N' ')YesANTRG Allow NULL? 
13ABRECOpen / To be Settled / Settled (Indicator)char10CHAR(N' ')YesABREC Allow NULL? 
14UEBLGHR Payroll Transfer (Indicator)char10CHAR(N' ')YesUEBLG Allow NULL? 
15UEBRFFI Transfer (Indicator)char10CHAR(N' ')YesUEBRF Allow NULL? 
16UEBDTData Medium Exchange Transfer (Indicator)char10CHAR(N' ')YesUEBDT Allow NULL? 
17TLOCKIndicator: Trip lockedchar10CHAR(N' ')YesPTRV_TLOCK Allow NULL? 
18WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
19ABRJ1Payroll Yearnvarchar40NUMC(N'0000')YesPABRJ Allow NULL? 
20ABRP1Payroll Periodnvarchar20NUMC(N'00')YesPABRP Allow NULL? 
21PERM1Period modifiernvarchar20CHAR(N' ')YesIPERM Allow NULL? 
22ABKR1Payroll Areanvarchar20CHAR(N' ')Yes*ABKRS Allow NULL? 
23BEGP1Start of Settlement Periodnvarchar80DATS(N'00000000')YesPTRV_BEGP1 Allow NULL? 
24ENDP1End of Settlement Periodnvarchar80DATS(N'00000000')YesPTRV_ENDP1 Allow NULL? 
25ABRJ2Payroll Yearnvarchar40NUMC(N'0000')YesPABRJ Allow NULL? 
26ABRP2Payroll Periodnvarchar20NUMC(N'00')YesPABRP Allow NULL? 
27PERM2Period modifiernvarchar20CHAR(N' ')YesIPERM Allow NULL? 
28ABKR2Payroll Areanvarchar20CHAR(N' ')Yes*ABKRS Allow NULL? 
29BEGP2Start of Settlement Periodnvarchar80DATS(N'00000000')YesPTRV_BEGP2 Allow NULL? 
30ENDP2End of Settlement Periodnvarchar80DATS(N'00000000')YesPTRV_ENDP2 Allow NULL? 
31ACCDTTrip Settlement Datenvarchar80DATS(N'00000000')YesPTRV_ACCDT Allow NULL? 
32ACCTMTrip Settlement Timenvarchar60TIMS(N'000000')YesPTRV_ACCTM Allow NULL? 
33RUNIDSequential number of posting runnvarchar100NUMC(N'0000000000')YesTR_EVNUM Allow NULL? 
34VERPAPer-Diem Accounting for Mealschar10CHAR(N' ')YesVERPA Allow NULL? 
35UEBKZPer-Diem Accounting for Accommodationschar10CHAR(N' ')YesUEPKZ Allow NULL? 
36ANUEPNumber of Overnight Stays for Per-Diem Settlementdecimal20DEC((0))YesANUEP
37NO_MILESIndicator: No repeat of travel costs accountingchar10CHAR(N' ')YesPTRV_NO_MILES_ACCOUNTING Allow NULL? 
38LSTAYMeals per diem reduct. for longer stay at same place of workchar10CHAR(N' ')YesPTRV_LSTAY Allow NULL? 
39TR_DOPP_ANZAHLDaily Return: No. of Days with Outb. and Return Tripnvarchar30NUMC(N'000')YesPTRVPS_TR_DOPP_ANZAHL Allow NULL? 
40TR_EINF_ANZAHLDaily Return: No. of Days only with Outb./ or Return Tripnvarchar30NUMC(N'000')YesPTRVPS_TR_EINF_ANZAHL Allow NULL? 
41TR_ENTFERNUNGDaily Return: Distance fr. Residence to New Place of Workdecimal50DEC((0))YesPTRVPS_TR_ENTFERNUNG
42VU_EA_DOPP_ANZOwn Contribution: No. of Days with Outb./Return Trip b. Movenvarchar30NUMC(N'000')YesPTRVPS_VU_EA_DOPP_ANZAHL Allow NULL? 
43VU_EA_EINF_ANZOwn Contribution: No. of Days wth Outb./Return Trip b. Movenvarchar30NUMC(N'000')YesPTRVPS_VU_EA_EINF_ANZAHL Allow NULL? 
44VU_EA_ENTFERNOwn Contribution: Distance to Place of Work before Movedecimal50DEC((0))YesPTRVPS_VU_EA_ENTFERNUNG
45VU_EA_KM_SATZOwn Contribution: KM Rate to Place of Work Before Movedecimal102CURR((0))YesPTRVPS_VU_EA_KM_SATZ
46NU_EA_DOPP_ANZOwn Contrib.: No. of Days wth Outb. and Ret. Trip after Movenvarchar30NUMC(N'000')YesPTRVPS_NU_EA_DOPP_ANZAHL Allow NULL? 
47NU_EA_EINF_ANZOwn Contrib.: No. of Days with Outb. or Ret. Trip after Movenvarchar30NUMC(N'000')YesPTRVPS_NU_EA_EINF_ANZAHL Allow NULL? 
48NU_EA_ENTFERNOwn Contribution: Distance to Place of Work after Movedecimal50DEC((0))YesPTRVPS_NU_EA_ENTFERNUNG
49NU_EA_KM_SATZOwn Contribution: KM Rate to Place of Work after Movedecimal102CURR((0))YesPTRVPS_NU_EA_KM_SATZ
50V_UNENTGELTLICHGratuitous Meals for the Entire Monthchar10CHAR(N' ')YesPTRV_V_UNENTGELTLICH Allow NULL? 
51U_UNENTGELTLICHGratuitous Accommodations for the Entire Monthchar10CHAR(N' ')YesPTRV_U_UNENTGELTLICH Allow NULL? 
52REDUC_ERGRUNew Reimbursement Group for Reduction in Meals per Diemnvarchar20CHAR(N' ')YesPTRV_REDUC_ERGRU Allow NULL? 
53NOT_PAIDNo Reimbursement of Tripchar10CHAR(N' ')YesPTRV_NOT_PAID Allow NULL? 
54WEG_ERH_MAXIncreased Maximum Trip Segment Reimbursementchar10CHAR(N' ')YesPTRV_WEG_ERH_MAX Allow NULL? 
55ERH_DIENST_INTSignificant Official Interestchar10CHAR(N' ')YesPTRV_ERH_DIENST_INT Allow NULL? 
56ENTF_WO_DOShort Distance to Residence/Workplacechar10CHAR(N' ')YesPTRV_ENTF_WO_DO Allow NULL? 
57DRITTMITTELPayments and Contributions from Third Partieschar10CHAR(N' ')YesPTRV_DRITTMITTEL Allow NULL? 
58ANTRAG_GWERequest for Full Trip Segment Reimbursementchar10CHAR(N' ')YesPTRV_ANTRAG_GWE Allow NULL? 
59POLICY_VIOLATIONViolation of Travel Policychar10CHAR(N' ')YesPTRV_POLICY_VIOLATION Allow NULL? 
60EXCEPTION_FLAGException Indicatorchar10CHAR(N' ')YesPTRV_EXCEPTION Allow NULL? 
61NR_RECEIPTSNumber of Receiptsnvarchar30NUMC(N'000')YesPTRV_NR_RECEIPTS Allow NULL? 
62PERM_TRIP_APPRStanding Approval of Business Tripschar10CHAR(N' ')YesPTRV_PERM_TRIP_APPROVAL Allow NULL? 
63TR_NR_FROM_HOMENumber of Days with Round Trip from Homenvarchar30NUMC(N'000')YesPTRVPS_NR_COMMUTES_FROM_HOME Allow NULL? 
64VAT_STATUSStatus of Data for VAT Refundchar10CHAR(N' ')YesPTRV_VAT_STATUS Allow NULL? 
65EST_COST_PLANEstimated Costs from Plandecimal132CURR((0))YesPTRV_EST_COST_PLAN
66EST_COST_REQEstimated Costs from Requestdecimal132CURR((0))YesPTRV_EST_COST_REQ
67REASONReason for Differencenvarchar500CHAR(N' ')YesPTRV_REASON Allow NULL? 
68TAX_TRIPTaxation of Whole Tripchar10CHAR(N' ')YesPTRVPS_TAX_TRIP Allow NULL? 
NamePrimaryUniqueTypeColumns
PTRV_ARCH_PERIO~0YesYesCLUSTEREDPDVRS, 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