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  | P05T_CVZ_UITW
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
Payroll :: The Netherlands :: Reporting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0P05T_CVZ_UITW641CVZ: Tabel voor uitwisselingsbestandReporting
SQL:  selectupdate insert create

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

SELECT MANDT, JUPER, PABRJ, PABRP, PERNR, PERSID, SEQNO, GDATE, GTIME, CVZ_ORGNR, CVZ_ORGCDE, CVZ_ID, CVZ_MAAND, CVZ_JAAR, CVZ_ACTUEEL, CVZ_INH_NOMINAAL, CVZ_INH_ZVW, CVZ_INH_AWBZ, CVZ_HM, CVZ_ID_HV, CVZ_GESLACHT, CVZ_OVERL, CVZ_VOORLETTERS, CVZ_VOORVOEGSEL, CVZ_ACHTERNAAM, CVZ_PARTNERNAAM, CVZ_ADRES, CVZ_POSTCODE, CVZ_WOONPLAATS, CVZ_LAND, CVZ_SOFINUMMER, CVZ_GBDAT, CVZ_DT_START, CVZ_DT_EIND, CVZ_REGNR, FOUTMELDING, REGNR, INH_NOMINAAL, INH_PERC_ZVW, INH_ZVW, INH_PERC_AWBZ, INH_AWBZ, DT_START, DT_EIND, ORGCDE, CVZ_FACTOR, CVZ_INH_NOM_F, CVZ_INH_ZVW_F, CVZ_INH_AWBZ_F, CVZ_DT_OVERL, DT_OVERL, PREMIELOON_ZVW, PREMIELOON_AWBZ, WOONLAND, FACTOR, CVZ_AANTAL_VERZ, AANTAL_VER, ALL_OUDEREN_KORT, CVZ_INH_ZVW_2008, CVZ_IH_AWBZ_2008, INH_PER_ZVW_2008, INH_PR_AWBZ_2008, CVZ_IH_ZVW_F_08, CVZ_IH_AWBZ_F_08 FROM P05T_CVZ_UITW
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2JUPERRepresenting Legal Personnvarchar40CHAR(N' ')NoT5N9PP05_REPER Allow NULL? 
3PABRJHCIB for year periodnvarchar40NUMC(N'0000')NoP05T_CVZ_ANPRJ Allow NULL? 
4PABRPHCIB for periodnvarchar20NUMC(N'00')NoP05T_CVZ_ANPRP Allow NULL? 
5PERNRPersonnel numbernvarchar80NUMC(N'00000000')NoPA0003PERSNO Allow NULL? 
6PERSIDHCIB: Sequence number instead of personnel numbernvarchar30NUMC(N'000')NoP05T_CVZ_PERSID Allow NULL? 
7SEQNOAlphanumeric symbol for HCIB filesnvarchar40CHAR(N' ')NoP05T_CVZ_SEQNO Allow NULL? 
8GDATECreation/Change Datenvarchar80DATS(N'00000000')NoP05T_GDATE Allow NULL? 
9GTIMECreation/Change Hournvarchar60TIMS(N'000000')NoP05T_GTIME Allow NULL? 
10CVZ_ORGNROrganization number for HCIBnvarchar100CHAR(N' ')YesP05T_CVZ_ORGNR Allow NULL? 
11CVZ_ORGCDEOrganizational key for HCIBnvarchar120CHAR(N' ')YesP05T_CVZ_ORGCDE Allow NULL? 
12CVZ_IDInsured person's identifier with HCIBnvarchar80NUMC(N'00000000')YesP05T_CVZ_ID Allow NULL? 
13CVZ_MAANDMonth for HCIBnvarchar20NUMC(N'00')YesP05T_CVZ_MAAND Allow NULL? 
14CVZ_JAARYear for HCIBnvarchar40NUMC(N'0000')YesP05T_CVZ_JAAR Allow NULL? 
15CVZ_ACTUEELCurrent status of insured person for HCIBchar10NUMC(N'0')YesP05T_CVZ_ACTUEEL Allow NULL? 
16CVZ_INH_NOMINAALDeduction for nominal ZVW contributiondecimal62DEC((0))YesP05T_CVZ_INH_NOMINAAL
17CVZ_INH_ZVWTranslation factor for deduction of ZVW contributiondecimal43DEC((0))YesP05T_CVZ_INH_ZVW
18CVZ_INH_AWBZConversion factor for deduction of AWBZ contributiondecimal43DEC((0))YesP05T_CVZ_INH_AWBZ
19CVZ_HMRegistration number of main person insured/co-insuredchar10CHAR(N' ')YesP05T_CVZ_HM Allow NULL? 
20CVZ_ID_HVMain person insured's identifier for co-insured personnvarchar80NUMC(N'00000000')YesP05T_CVZ_ID_HV Allow NULL? 
21CVZ_GESLACHTGender of insured personchar10CHAR(N' ')YesP05T_CVZ_GESLACHT Allow NULL? 
22CVZ_OVERLReference number deceasedchar10NUMC(N'0')YesP05T_CVZ_OVERL Allow NULL? 
23CVZ_VOORLETTERSInitialsnvarchar60CHAR(N' ')YesP05T_CVZ_VOORLETTERS Allow NULL? 
24CVZ_VOORVOEGSELName Prefixnvarchar100CHAR(N' ')YesP05T_CVZ_VOORVOEGSEL Allow NULL? 
25CVZ_ACHTERNAAMLast Namenvarchar700CHAR(N' ')YesP05T_CVZ_ACHTERNAAM Allow NULL? 
26CVZ_PARTNERNAAMPartner Namenvarchar350CHAR(N' ')YesP05T_CVZ_PARTNERNAAM Allow NULL? 
27CVZ_ADRESAddress for Health Care Insurance Boardnvarchar550CHAR(N' ')YesP05T_CVZ_ADRES Allow NULL? 
28CVZ_POSTCODEPostal Code for HCIBnvarchar80CHAR(N' ')YesP05T_CVZ_POSTCODE Allow NULL? 
29CVZ_WOONPLAATSCity for HCIBnvarchar240CHAR(N' ')YesP05T_CVZ_WOONPLAATS Allow NULL? 
30CVZ_LANDCountry indicator for HCIBnvarchar20CHAR(N' ')YesP05T_CVZ_LAND Allow NULL? 
31CVZ_SOFINUMMERSocial Security Number for HCIBnvarchar90NUMC(N'000000000')YesP05T_CVZ_SOFINUMMER Allow NULL? 
32CVZ_GBDATDate of Birth for HCIBnvarchar100CHAR(N' ')YesP05T_CVZ_GEBOORTEDATUM Allow NULL? 
33CVZ_DT_STARTStart Date Deductionnvarchar100CHAR(N' ')YesP05T_CVZ_DT_START Allow NULL? 
34CVZ_DT_EINDEnd Date deductionnvarchar100CHAR(N' ')YesP05T_CVZ_DT_EIND Allow NULL? 
35CVZ_REGNRExternal registration numbernvarchar200CHAR(N' ')YesP05T_CVZ_REGISTRATIENR Allow NULL? 
36FOUTMELDINGError message codenvarchar20NUMC(N'00')NoP05T_CVZ_FOUTMELDING Allow NULL? 
37REGNRExternal registration numbernvarchar200CHAR(N' ')YesP05T_CVZ_REGISTRATIENR Allow NULL? 
38INH_NOMINAALDeduction for nominal ZVW contributiondecimal62DEC((0))YesP05T_CVZ_INH_NOMINAAL
39INH_PERC_ZVWTranslation factor for deduction of ZVW contributiondecimal43DEC((0))YesP05T_CVZ_INH_ZVW
40INH_ZVWAmount of deduction by pension fund for ZVW contributiondecimal62DEC((0))YesP05T_CVZ_INH_BDRG_ZVW
41INH_PERC_AWBZConversion factor for deduction of AWBZ contributiondecimal43DEC((0))YesP05T_CVZ_INH_AWBZ
42INH_AWBZAmount of deduction by pension fund for AWBZ contributiondecimal62DEC((0))YesP05T_CVZ_INH_BDRG_AWBZ
43DT_STARTStart Date Deductionnvarchar100CHAR(N' ')YesP05T_CVZ_DT_START Allow NULL? 
44DT_EINDEnd Date deductionnvarchar100CHAR(N' ')YesP05T_CVZ_DT_EIND Allow NULL? 
45ORGCDEOrganizational key for HCIBnvarchar120CHAR(N' ')YesP05T_CVZ_ORGCDE Allow NULL? 
46CVZ_FACTORCountry of residence factordecimal87DEC((0))YesP05T_CVZ_FACTOR
47CVZ_INH_NOM_FNominal contribution amount, adjusted for COR HCIBdecimal62DEC((0))YesP05T_CVZ_INH_NOM_F
48CVZ_INH_ZVW_FAmount ZVW, adjusted for country of residence factor HCIBdecimal62DEC((0))YesP05T_CVZ_INH_ZVW_F
49CVZ_INH_AWBZ_FAWBZ amount, adjusted for country of residence factor HCIBdecimal62DEC((0))YesP05T_CVZ_INH_AWBZ_F
50CVZ_DT_OVERLDate of deathnvarchar100CHAR(N' ')YesP05T_CVZ_DT_OVERL Allow NULL? 
51DT_OVERLDate of deathnvarchar100CHAR(N' ')YesP05T_CVZ_DT_OVERL Allow NULL? 
52PREMIELOON_ZVWCumulative Zvw premium rate (as of 1 Jan. of current year)decimal82DEC((0))YesP05T_CVZ_PREMIELOON_ZVW
53PREMIELOON_AWBZCumulative premium rate AWBZ (beginning 1 Jan of current yr)decimal82DEC((0))YesP05T_CVZ_PREMIELOON_AWBZ
54WOONLANDCountry indicator for HCIBnvarchar20CHAR(N' ')YesP05T_CVZ_LAND Allow NULL? 
55FACTORCountry of residence factordecimal87DEC((0))YesP05T_CVZ_FACTOR
56CVZ_AANTAL_VERZNumber of insured persons for whom contribution is deducteddecimal20DEC((0))YesP05T_CVZ_AANT_VERZ
57AANTAL_VERNumber of insured persons for whom contribution is deducteddecimal20DEC((0))YesP05T_CVZ_AANT_VERZ
58ALL_OUDEREN_KORTCare Insurance Board: All Elderly Persons' Tax Creditchar10CHAR(N' ')YesP05T_CVZ_ALL_OUDEREN_KORTING Allow NULL? 
59CVZ_INH_ZVW_2008Translation Ratio for Deduction of Contribution ZVW (2008)decimal65DEC((0))YesP05T_CVZ_INH_ZVW_2008
60CVZ_IH_AWBZ_2008Translation Ratio for Deduction of Contribution AWBZ (2008)decimal65DEC((0))YesP05T_CVZ_INH_AWBZ_2008
61INH_PER_ZVW_2008Translation Ratio for Deduction of Contribution ZVW (2008)decimal65DEC((0))YesP05T_CVZ_INH_ZVW_2008
62INH_PR_AWBZ_2008Translation Ratio for Deduction of Contribution AWBZ (2008)decimal65DEC((0))YesP05T_CVZ_INH_AWBZ_2008
63CVZ_IH_ZVW_F_08Amount Zvw, adjusted for country of residence factor CVZdecimal54DEC((0))YesP05T_CVZ_INH_ZVW_F_2008
64CVZ_IH_AWBZ_F_08AWBZ amount, adjusted for country of residence factor CVZdecimal54DEC((0))YesP05T_CVZ_INH_AWBZ_F_2008
NamePrimaryUniqueTypeColumns
P05T_CVZ_UITW~0YesYesCLUSTEREDSEQNO, PERSID, PERNR, PABRP, PABRJ, JUPER, 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