SAP table PARCT (Receipt Log Table)
SAP table PARCT has 6 primary key fields being MANDT,BUKRS,BELNR,GJAHR,BUZEI,RYOSHUSHO.
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 | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| BELNR | Document Number of an Accounting Document | CHAR | 10 | 0 | BELNR_D | ||
| GJAHR | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||
| BUZEI | Number of Line Item Within Accounting Document | NUMC | 3 | 0 | BUZEI | ||
| RYOSHUSHO | Number Assigned to a Document | CHAR | 10 | 0 | RYOSHUSHO | ||
| KUNNR | Customer Number | CHAR | 10 | 0 | KNA1 | KUNNR | |
| EVENT | Identification for Correspondence | CHAR | 5 | 0 | T048 | EVENT_KORR | |
| WAERS | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |
| DMBTR | Amount in local currency | CURR | 23 | 2 | DMBTR | ||
| HWBAS | Tax Base Amount in Local Currency | CURR | 23 | 2 | HWBAS | ||
| MWSKZ | Tax on sales/purchases code | CHAR | 2 | 0 | T007A | MWSKZ | |
| MWSTS | Tax Amount in Local Currency | CURR | 23 | 2 | MWSTS | ||
| INSHIZEI | Japanese Stamp Tax | CURR | 23 | 2 | INSHIZEI | ||
| UMSKZ | Special G/L Indicator | CHAR | 1 | 0 | T074U | UMSKZ | |
| GSBER | Business Area | CHAR | 4 | 0 | TGSB | GSBER | |
| DATUM | Date | DATS | 8 | 0 | DATUM | ||
| USNAM | User Name | CHAR | 12 | 0 | USNAM | ||
| STAPEL | Receipt Lot | CHAR | 4 | 0 | T058B | GROUPRCT | |
| STATUS | Status of Official Receipt | CHAR | 2 | 0 | STATUS_OR |
PARCT foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 PARCT | BUKRS | T001 | Company Codes | BUKRS |
| 1 PARCT | EVENT | T048 | Correspondence Types | EVENT |
| 0 PARCT | GSBER | TGSB | Business Areas | MANDT |
| 0 PARCT | GSBER | TGSB | Business Areas | GSBER |
| 1 PARCT | KUNNR | KNA1 | General Data in Customer Master | MANDT |
| 1 PARCT | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| 0 PARCT | MANDT | T000 | Clients | MANDT |
| 1 PARCT | MWSKZ | T007A | Tax Keys | KALSM |
| 1 PARCT | MWSKZ | T007A | Tax Keys | MWSKZ |
| 0 PARCT | STAPEL | T058B | Number Range Assignment for Receipts | BUKRS |
| 1 PARCT | UMSKZ | T074U | Special G/L Indicator Properties | MANDT |
| 0 PARCT | WAERS | TCURC | Currency Codes | MANDT |
| 0 PARCT | WAERS | TCURC | Currency Codes | WAERS |