SAP table PVRCPD (PVS Header/Recipe Basic Data)
SAP table PVRCPD has 3 primary key fields being MANDT,PVGUID,PVCDCNT.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| PVGUID | Internal Number of the PVS Variant | RAW | 16 | 0 | POSVID | PVS_PVGUID | |
| PVCDCNT | Internal Counter for iPPE Objects | NUMC | 8 | 0 | PVS_COUNT | ||
| AENNR | Change Number | CHAR | 12 | 0 | AENR | AENNR | |
| DELFLG | Deletion Indicator | CHAR | 1 | 0 | PVS_DELFLG | ||
| STDVAR | Indicator: Standard Variant (Recipe) | CHAR | 1 | 0 | RCP_STDVAR | ||
| ISTATUS | Individual Status of Object | CHAR | 5 | 0 | PVS_J_STATUS | ||
| STATUS_CHG_COUNT | Copy counter | INT1 | 3 | 0 | RSPOPCOPY | ||
| OBJNR | Object Number | CHAR | 22 | 0 | * | PVS_J_OBJNR | |
| ISTATUS_OLD | Object status | CHAR | 5 | 0 | J_STATUS | ||
| RCPDCNT | Change State in Recipe | CHAR | 10 | 0 | RCPCHST | ||
| RCPVERS | Version of the General Recipe | CHAR | 10 | 0 | PVS_RCPVERS | ||
| VALFROM | Valid-From Date | DATS | 8 | 0 | PVS_ADATUM | ||
| VALTO | Valid-To Date | DATS | 8 | 0 | PVS_BDATUM | ||
| LOTMIN | Lower Limit of Lot-Size Range | QUAN | 13 | 3 | PVS_MINLOTSIZE | ||
| LOTMAX | Upper Limit of Lot-Size Range | QUAN | 13 | 3 | PVS_MAXLOTSIZE | ||
| LOTUNIT | Unit of Measure | UNIT | 3 | 0 | PVS_QUNIT | ||
| PV_PLANT | Plant | CHAR | 4 | 0 | WERKS_D | ||
| PV_MAT | Material Number | CHAR | 40 | 0 | MATNR | ||
| PV_NR | Production Version | CHAR | 4 | 0 | * | PVS_VERID | |
| OTYPE_ORGID | Object Type | CHAR | 2 | 0 | ESD_ESTST_T778O | OTYPE | |
| REALO | Responsible | CHAR | 45 | 0 | ESEREALO | ||
| RCP_TIMSTMP | UTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) | DEC | 21 | 7 | PVS_TIMSTMP | ||
| RCP_CREADAT | Date of Application | DATS | 8 | 0 | PVS_ANDAT | ||
| RCP_CREABY | User who created record | CHAR | 12 | 0 | PVS_ANNAM | ||
| RCP_CHNGDAT | Date of Last Change | DATS | 8 | 0 | PVS_AEDAT | ||
| RCP_CHNGBY | Name of Person Who Changed Object | CHAR | 12 | 0 | PVS_AENAM | ||
| REFQUANT | Reference Quantity | QUAN | 13 | 3 | RCPE_REFQUANT | ||
| PROJECT | WBS Element | NUMC | 8 | 0 | PRPS | PS_POSNR | |
| DEV_TIME | Recipe Development Time | NUMC | 6 | 0 | RCPE_DEVTIME | ||
| PROD_TIME | Productive Time of Recipe | NUMC | 6 | 0 | RCPE_PRODTIME | ||
| CONF_FLAG | Confidential | CHAR | 1 | 0 | RCPE_CONFFLAG | ||
| REFLANG | Reference Language | LANG | 1 | 0 | RCPE_OLANG | ||
| PVTXCNT | Counter for Text Tables | NUMC | 5 | 0 | PVS_TXTCOUNT | ||
| RESCREATXCNT | Counter for Text Tables | NUMC | 5 | 0 | PVS_TXTCOUNT | ||
| COPY_FROM | Origin | RAW | 16 | 0 | RCPE_CPYFROM | ||
| COPY_FROM_RCP | Copied from | RAW | 16 | 0 | RCPE_CPYFROM_RCP | ||
| PREF_RCP_FLG | Preferred Recipe | CHAR | 1 | 0 | RCPE_PREF_RCP | ||
| CONS_FLG | Consistent | CHAR | 1 | 0 | RCPE_CONS_FLG |
PVRCPD foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 PVRCPD | AENNR | AENR | Change Master | AENNR |
| 1 PVRCPD | OTYPE_ORGID | ESD_ESTST_T778O | Generated Table for View | OTYPE |
| 0 PVRCPD | PROJECT | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| 0 PVRCPD | PROJECT | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| 1 PVRCPD | PVGUID | POSVID | iPPE Variant: Identification | MANDT |
| 1 PVRCPD | PVGUID | POSVID | iPPE Variant: Identification | PVGUID |