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  | PA0073
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 :: Denmark
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA0073771HR Master Record: Infotype 0073 (Private Pensions - DK)Denmark
SQL:  selectupdate insert create

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

SELECT MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR, AEDTM, UNAME, HISTO, ITXEX, REFEX, ORDEX, ITBLD, PREAS, FLAG1, FLAG2, FLAG3, FLAG4, RESE1, RESE2, GRPVL, BMODT, REGNR, KONTO, POLNR, OPLKD, ALDKD, PENSA, PTYPE, GRLIV, GRDAT, PCTKD, BIDAG, SBIAG, BIDMA, SBIMA, AFDNR, AFTNR, TCOD1, TEXT1, TCOD2, TEXT2, TCOD3, TEXT3, TCOD4, TEXT4, PEGRL, PCTK1, AMPCR, AMP_INST, PWTYP, KAPKZAG, KAPKZMA, BTRAG, BTRAGW, BTRMA, BTRMAW, PRZAG, PRZMA, PENSRZ_ABN, PENSRZ_ABG, ABGPENSALL, ARBPENSALL, EMFTX, BKPLZ, BKORT, BANKA, BANKL, BKKTO, TRANS, PBSNR, INST, AFTLN, CREAS, PADWT FROM PA0073
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PERNRPersonnel numbernvarchar80NUMC(N'00000000')NoPA0003PERSNO Allow NULL? 
3SUBTYSubtypenvarchar40CHAR(N' ')NoSUBTY Allow NULL? 
4OBJPSObject Identificationnvarchar20CHAR(N' ')NoOBJPS Allow NULL? 
5SPRPSLock Indicator for HR Master Data Recordchar10CHAR(N' ')NoSPRPS Allow NULL? 
6ENDDAEnd Datenvarchar80DATS(N'00000000')NoENDDA Allow NULL? 
7BEGDAStart Datenvarchar80DATS(N'00000000')NoBEGDA Allow NULL? 
8SEQNRNumber of Infotype Record with Same Keynvarchar30NUMC(N'000')NoSEQNR Allow NULL? 
9AEDTMChanged Onnvarchar80DATS(N'00000000')NoAEDAT Allow NULL? 
10UNAMEName of Person Who Changed Objectnvarchar120CHAR(N' ')NoAENAM Allow NULL? 
11HISTOHistorical Record Flagchar10CHAR(N' ')NoHISTO Allow NULL? 
12ITXEXText Exists for Infotypechar10CHAR(N' ')NoITXEX Allow NULL? 
13REFEXReference Fields Exist (Primary/Secondary Costs)char10CHAR(N' ')NoPRFEX Allow NULL? 
14ORDEXConfirmation Fields Existchar10CHAR(N' ')NoORDEX Allow NULL? 
15ITBLDInfotype Screen Controlnvarchar20CHAR(N' ')NoITBLD Allow NULL? 
16PREASReason for Changing Master Datanvarchar20CHAR(N' ')NoT530EPREAS Allow NULL? 
17FLAG1Reserved Field/Unused Fieldchar10CHAR(N' ')NoNUSED Allow NULL? 
18FLAG2Reserved Field/Unused Fieldchar10CHAR(N' ')NoNUSED Allow NULL? 
19FLAG3Reserved Field/Unused Fieldchar10CHAR(N' ')NoNUSED Allow NULL? 
20FLAG4Reserved Field/Unused Fieldchar10CHAR(N' ')NoNUSED Allow NULL? 
21RESE1Reserved Field/Unused Field of Length 2nvarchar20CHAR(N' ')NoNUSED2 Allow NULL? 
22RESE2Reserved Field/Unused Field of Length 2nvarchar20CHAR(N' ')NoNUSED2 Allow NULL? 
23GRPVLGrouping Value for Personnel Assignmentsnvarchar40CHAR(N' ')YesPCCE_GPVAL Allow NULL? 
24BMODTPayee key for bank transfersnvarchar80CHAR(N' ')NoEMFSL Allow NULL? 
25REGNRBank number (Denmark)nvarchar150CHAR(N' ')NoREGNR Allow NULL? 
26KONTOAccount numbernvarchar100CHAR(N' ')NoKTONP Allow NULL? 
27POLNRInsurance Policy Numbernvarchar150CHAR(N' ')NoPOLNR Allow NULL? 
28OPLKDDuty to informchar10NUMC(N'0')NoOPLKD Allow NULL? 
29ALDKDAge codenvarchar20NUMC(N'00')NoALDKD Allow NULL? 
30PENSARetirement agenvarchar20NUMC(N'00')NoPENSA Allow NULL? 
31PTYPEPension Categoriesnvarchar20NUMC(N'00')NoT5M7NP09_PTYPE Allow NULL? 
32GRLIVInsurance contributiondecimal112DEC((0))NoGRLIV
33GRDATGroup insurance start date (YYYYMMDD)nvarchar80DATS(N'00000000')NoDATGR Allow NULL? 
34PCTKDPercent indicatorchar10CHAR(N' ')NoPCTKD Allow NULL? 
35BIDAGEE contributiondecimal92CURR((0))NoBIDMA
36SBIAGER contribution (tax class 3)decimal92CURR((0))NoSBIAG
37BIDMAEE contributiondecimal92CURR((0))NoBIDMA
38SBIMAEE contribution (tax class 3)decimal92CURR((0))NoSBIMA
39AFDNRDepartment numbernvarchar50CHAR(N' ')NoAFDNR Allow NULL? 
40AFTNRContract Numbernvarchar80CHAR(N' ')NoAFTNR Allow NULL? 
41TCOD1Text code 1nvarchar30CHAR(N' ')NoTCOD1 Allow NULL? 
42TEXT1Supplementary pension text 1nvarchar80CHAR(N' ')NoPTXT1_D Allow NULL? 
43TCOD2Text code 2nvarchar30CHAR(N' ')NoTCOD2 Allow NULL? 
44TEXT2Supplementary pension text 2nvarchar100CHAR(N' ')NoPTXT2 Allow NULL? 
45TCOD3Text code 3nvarchar30CHAR(N' ')NoTCOD3 Allow NULL? 
46TEXT3Supplementary pension text 3nvarchar200CHAR(N' ')NoPTXT3 Allow NULL? 
47TCOD4Text code 4nvarchar30CHAR(N' ')NoTCOD4 Allow NULL? 
48TEXT4Supplementary pension text 4nvarchar610CHAR(N' ')NoPTXT4 Allow NULL? 
49PEGRLPension basis DKnvarchar40CHAR(N' ')NoT512WPEGRL Allow NULL? 
50PCTK1Employee contributionchar10CHAR(N' ')NoPCTK1 Allow NULL? 
51AMPCRIndicator for AMP adjustmentchar10CHAR(N' ')NoP09_AMPCR Allow NULL? 
52AMP_INSTUnion Agreement Key nvarchar50CHAR(N' ')YesT5M7OP09_AMPINS Allow NULL? 
53PWTYPWage Type Pension Denmark; contains EE+ER contributionnvarchar40CHAR(N' ')NoT512WP09_PWTYP Allow NULL? 
54KAPKZAGHR-DK Capital indicatorchar10CHAR(N' ')YesP09_KAPKZ Allow NULL? 
55KAPKZMAHR-DK Capital indicatorchar10CHAR(N' ')YesP09_KAPKZ Allow NULL? 
56BTRAGAmountdecimal92CURR((0))YesBETRG
57BTRAGWCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
58BTRMAAmountdecimal92CURR((0))YesBETRG
59BTRMAWCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
60PRZAGPayroll percentage ratedecimal52DEC((0))YesP09_BRGPROZS
61PRZMAPayroll percentage ratedecimal52DEC((0))YesP09_BRGPROZS
62PENSRZ_ABNInsurance return payment (X) or not ( )char10CHAR(N' ')YesP09_ABZUG Allow NULL? 
63PENSRZ_ABGInsurance return payment (X) or not ( )char10CHAR(N' ')YesP09_ABZUG Allow NULL? 
64ABGPENSALLIs employer contribution permitted?char10CHAR(N' ')YesP09_ALLOWP Allow NULL? 
65ARBPENSALLDisplay if permitted to enter employee contributionchar10CHAR(N' ')YesP09_ALLOWA Allow NULL? 
66EMFTXPayee Textnvarchar400CHAR(N' ')YesEMFTX Allow NULL? 
67BKPLZPostal code (layout: PLSTLZ/ORT)nvarchar100CHAR(N' ')YesP09_PSTLZ Allow NULL? 
68BKORTCitynvarchar250CHAR(N' ')YesORT01 Allow NULL? 
69BANKAName of banknvarchar600CHAR(N' ')YesBANKA Allow NULL? 
70BANKLBank Keysnvarchar150CHAR(N' ')YesBANKK Allow NULL? 
71BKKTOBank account numbernvarchar180CHAR(N' ')YesBANKN Allow NULL? 
72TRANSOSI transfer (Denmark)char10CHAR(N' ')YesOSIUB Allow NULL? 
73PBSNRTransfer customer numbernvarchar80CHAR(N' ')YesPBSNR Allow NULL? 
74INSTPension institutionsnvarchar20CHAR(N' ')YesT5M8OP09_INST Allow NULL? 
75AFTLNAgreement Number nvarchar80CHAR(N' ')YesP09_AFTNR Allow NULL? 
76CREASReason for Changing Master Datanvarchar20CHAR(N' ')YesT530EPREAS Allow NULL? 
77PADWTAdditional Wage Type With Information Relevant to Pensionsnvarchar40CHAR(N' ')YesT512WP09_PADWT Allow NULL? 
NamePrimaryUniqueTypeColumns
PA0073~0YesYesCLUSTEREDSEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, 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