SAP table RKPF (Document Header: Reservation)
SAP table RKPF has 2 primary key fields being MANDT,RSNUM.
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 | MANDT | ||
| RSNUM | Number of reservation/dependent requirements | NUMC | 10 | 0 | RSNUM | ||
| KZVER | Origin | CHAR | 1 | 0 | KZVER | ||
| XCALE | Check date against factory calendar | CHAR | 1 | 0 | XCALE | ||
| RSDAT | Base date for reservation | DATS | 8 | 0 | BSTER | ||
| USNAM | User Name | CHAR | 12 | 0 | USNAM | ||
| BWART | Movement type (inventory management) | CHAR | 3 | 0 | T156 | BWART | |
| WEMPF | Goods Recipient | CHAR | 12 | 0 | WEMPF | ||
| KOSTL | Cost Center | CHAR | 10 | 0 | CSKS | KOSTL | |
| PROJN | Old: Project number : No longer used --> PS_POSNR | CHAR | 16 | 0 | PROJN | ||
| ANLN1 | Main Asset Number | CHAR | 12 | 0 | ANLH | ANLN1 | |
| ANLN2 | Asset Subnumber | CHAR | 4 | 0 | ANLA | ANLN2 | |
| KUNNR | Account number of customer | CHAR | 10 | 0 | KNA1 | EKUNN | |
| EBELN | Purchase order number | CHAR | 10 | 0 | EKKO | BSTNR | |
| EBELP | Item Number of Purchasing Document | NUMC | 5 | 0 | EKPO | EBELP | |
| AUFNR | Order Number | CHAR | 12 | 0 | AUFK | AUFNR | |
| KDAUF | Sales Order Number | CHAR | 10 | 0 | KDAUF | ||
| KDPOS | Item number in Sales Order | NUMC | 6 | 0 | KDPOS | ||
| KDEIN | Delivery schedule for sales order | NUMC | 4 | 0 | KDEIN | ||
| UMWRK | Receiving plant/issuing plant | CHAR | 4 | 0 | T001W | UMWRK | |
| UMLGO | Receiving/issuing storage location | CHAR | 4 | 0 | T001L | UMLGO | |
| SERIE | BOM explosion number | CHAR | 8 | 0 | SERNR | ||
| KOKRS | Controlling Area | CHAR | 4 | 0 | TKA01 | KOKRS | |
| PARBU | Clearing company code | CHAR | 4 | 0 | T001 | PARBU | |
| PARGB | Trading partner's business area | CHAR | 4 | 0 | TGSB | PARGB | |
| IMKEY | Internal Key for Real Estate Object | CHAR | 8 | 0 | IMKEY | ||
| KSTRG | Cost Object | CHAR | 12 | 0 | KSTRG | ||
| PAOBJNR | Profitability Segment Number (CO-PA) | NUMC | 10 | 0 | RKEOBJNR | ||
| PRCTR | Profit Center | CHAR | 10 | 0 | PRCTR | ||
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | NUMC | 8 | 0 | PS_PSP_PNR | ||
| NPLNR | Network Number for Account Assignment | CHAR | 12 | 0 | AUFK | NPLNR | |
| AUFPL | Routing number of operations in the order | NUMC | 10 | 0 | CO_AUFPL | ||
| APLZL | Internal counter | NUMC | 8 | 0 | CIM_COUNT | ||
| VPTNR | Partner account number | CHAR | 10 | 0 | KNA1 | JV_PART | |
| FIPOS | Commitment Item | CHAR | 14 | 0 | FMFPO | FIPOS | |
| DUMMY_INCL_EEW_COBL | Custom Fields: Dummy for Use in Extension Includes | CHAR | 1 | 0 | CFD_DUMMY | ||
| RECID | Internal Recovery Indicator | CHAR | 2 | 0 | JV_RECINDI | ||
| FKBER | Functional Area | CHAR | 16 | 0 | FKBER | ||
| DABRZ | Reference date for settlement | DATS | 8 | 0 | DABRBEZ | ||
| FISTL | Funds Center | CHAR | 16 | 0 | FISTL | ||
| GEBER | Fund | CHAR | 10 | 0 | BP_GEBER | ||
| PRZNR | Business Process | CHAR | 12 | 0 | CO_PRZNR | ||
| LSTAR | Activity Type | CHAR | 6 | 0 | LSTAR | ||
| GRANT_NBR | Grant | CHAR | 20 | 0 | GM_GRANT_NBR | ||
| BUDGET_PD | Budget Period | CHAR | 10 | 0 | FM_BUDGET_PERIOD | ||
| DUMMY_RKPF_INCL_EEW_PS | Custom Fields: Dummy for Use in Extension Includes | CHAR | 1 | 0 | CFD_DUMMY | ||
| CREATIONDATETIME | Creation Date | DEC | 21 | 7 | VDM_CREATIONDATETIME | ||
| LASTCHANGEDBYUSER | Last Changed By User | CHAR | 12 | 0 | VDM_LASTCHANGEDBYUSERID | ||
| LASTCHANGEDATETIME | Last Changed On | DEC | 21 | 7 | VDM_LASTCHANGEDON |
RKPF foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 RKPF | ANLN1 | ANLH | Main asset number | BUKRS |
| 0 RKPF | ANLN1 | ANLH | Main asset number | ANLN1 |
| 1 RKPF | ANLN2 | ANLA | Asset Master Record Segment | BUKRS |
| 1 RKPF | ANLN2 | ANLA | Asset Master Record Segment | ANLN1 |
| 1 RKPF | ANLN2 | ANLA | Asset Master Record Segment | ANLN2 |
| 0 RKPF | AUFNR | AUFK | Order master data | AUFNR |
| 1 RKPF | BWART | T156 | Movement Type | MANDT |
| 1 RKPF | BWART | T156 | Movement Type | BWART |
| 0 RKPF | EBELN | EKKO | Purchasing Document Header | EBELN |
| 1 RKPF | EBELP | EKPO | Purchasing Document Item | MANDT |
| 1 RKPF | EBELP | EKPO | Purchasing Document Item | EBELN |
| 0 RKPF | FIPOS | FMFPO | FIFM: Commitment Item | MANDT |
| 0 RKPF | FIPOS | FMFPO | FIFM: Commitment Item | FIKRS |
| 0 RKPF | FIPOS | FMFPO | FIFM: Commitment Item | DATBIS |
| 1 RKPF | KOKRS | TKA01 | Controlling Areas | MANDT |
| 0 RKPF | KOSTL | CSKS | Cost Center Master Record | MANDT |
| 0 RKPF | KOSTL | CSKS | Cost Center Master Record | KOKRS |
| 0 RKPF | KOSTL | CSKS | Cost Center Master Record | KOSTL |
| 0 RKPF | KOSTL | CSKS | Cost Center Master Record | DATBI |
| 1 RKPF | KUNNR | KNA1 | General Data in Customer Master | MANDT |
| 1 RKPF | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| 0 RKPF | NPLNR | AUFK | Order master data | AUFNR |
| 1 RKPF | PARBU | T001 | Company Codes | BUKRS |
| 0 RKPF | PARGB | TGSB | Business Areas | MANDT |
| 0 RKPF | PARGB | TGSB | Business Areas | GSBER |
| 1 RKPF | UMLGO | T001L | Storage Locations | MANDT |
| 1 RKPF | UMLGO | T001L | Storage Locations | WERKS |
| 0 RKPF | UMWRK | T001W | Plants/Branches | WERKS |
| 1 RKPF | VPTNR | KNA1 | General Data in Customer Master | MANDT |
| 1 RKPF | VPTNR | KNA1 | General Data in Customer Master | KUNNR |