SAP table ASSOB (Assignment Objects)
SAP table ASSOB has 2 primary key fields being MANDT,PDSNR.
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 | |
| PDSNR | Sequential number for PDC messages | NUMC | 12 | 0 | PDSNR | PDSNR_D | |
| PERNR | Personnel Number | NUMC | 8 | 0 | PERNR_D | ||
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| GSBER | Business Area | CHAR | 4 | 0 | TGSB | GSBER | |
| KOKRS | Controlling Area | CHAR | 4 | 0 | TKA01 | KOKRS | |
| KOSTL | Cost Center | CHAR | 10 | 0 | CSKS | KOSTL | |
| AUFNR | Order Number | CHAR | 12 | 0 | AUFK | AUFNR | |
| KSTRG | Cost Object | CHAR | 12 | 0 | CKPH | KSTRG | |
| POSNR | Work Breakdown Structure Element (WBS Element) | NUMC | 8 | 0 | PRPS | PS_PSP_PNR | |
| NPLNR | Network Number for Account Assignment | CHAR | 12 | 0 | AUFK | NPLNR | |
| VORNR | Operation/Activity Number | CHAR | 4 | 0 | VORNR | ||
| KDAUF | Sales Order Number | CHAR | 10 | 0 | VBUK | KDAUF | |
| KDPOS | Item number in Sales Order | NUMC | 6 | 0 | KDPOS | ||
| PAOBJNR | Profitability Segment Number (CO-PA) | NUMC | 10 | 0 | RKEOBJNR | ||
| PRZNR | Business Process | CHAR | 12 | 0 | * | CO_PRZNR | |
| FISTL | Funds Center | CHAR | 16 | 0 | * | FISTL | |
| FIPOS | Commitment Item | CHAR | 14 | 0 | * | FIPOS | |
| GEBER | Fund | CHAR | 10 | 0 | * | BP_GEBER | |
| EBELN | Purchasing Document Number | CHAR | 10 | 0 | EKKO | EBELN | |
| EBELP | Item Number of Purchasing Document | NUMC | 5 | 0 | EKPO | EBELP | |
| LSTNR | Activity Number | CHAR | 18 | 0 | ASMD | ASNUM | |
| LTLST | Activity Type | CHAR | 6 | 0 | CSLA | LSTAR | |
| SBUKR | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| SGSBR | Business Area | CHAR | 4 | 0 | TGSB | GSBER | |
| SKOST | Cost Center | CHAR | 10 | 0 | CSKS | KOSTL | |
| LSTAR | Activity Type | CHAR | 6 | 0 | CSLA | LSTAR | |
| EXBEL | Assignment number | CHAR | 18 | 0 | HR_ZUONR | ||
| MWSKZ | Tax on sales/purchases code | CHAR | 2 | 0 | * | MWSKZ | |
| OTYPE | Object Type | CHAR | 2 | 0 | T778O | OTYPE | |
| STELL | Job | NUMC | 8 | 0 | T513 | STELL | |
| POHRS | Number of Hours for Activity Allocation/External Services | DEC | 7 | 2 | POHRS | ||
| DART | Service Type (Public Service Germany) | CHAR | 2 | 0 | T5D7C | DART | |
| UDART | Service Category (Public Service Germany) | CHAR | 2 | 0 | T5D7E | UDART | |
| SGTXT | Item Text | CHAR | 50 | 0 | SGTXT | ||
| TXJCD | Tax Jurisdiction | CHAR | 15 | 0 | * | TXJCD | |
| FIPEX | Commitment Item | CHAR | 24 | 0 | * | FM_FIPEX | |
| FKBER | Functional Area | CHAR | 16 | 0 | * | FKBER | |
| GRANT_NBR | Grant | CHAR | 20 | 0 | GM_GRANT_NBR | ||
| SGEBER | Sender fund | CHAR | 10 | 0 | * | FM_SFONDS | |
| SFKBER | Sending Functional Area | CHAR | 16 | 0 | * | SFKTBER | |
| SGRANT_NBR | Sender Grant | CHAR | 20 | 0 | * | GM_GRANT_SENDER | |
| SEGMENT | Segment for Segmental Reporting | CHAR | 10 | 0 | * | FB_SEGMENT | |
| SSEGMENT | Segment for Segmental Reporting | CHAR | 10 | 0 | * | FB_SEGMENT | |
| BUDGET_PD | Budget Period | CHAR | 10 | 0 | * | FM_BUDGET_PERIOD | |
| SBUDGET_PD | FM: Sender Budget Period | CHAR | 10 | 0 | * | FM_SBUDGET_PERIOD |
ASSOB foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 ASSOB | AUFNR | AUFK | Order master data | AUFNR |
| 1 ASSOB | BUKRS | T001 | Company Codes | BUKRS |
| 0 ASSOB | DART | T5D7C | Service Types | MANDT |
| 0 ASSOB | DART | T5D7C | Service Types | ENDDA |
| 1 ASSOB | EBELN | EKKO | Purchasing Document Header | MANDT |
| 1 ASSOB | EBELN | EKKO | Purchasing Document Header | EBELN |
| 0 ASSOB | EBELP | EKPO | Purchasing Document Item | MANDT |
| 0 ASSOB | EBELP | EKPO | Purchasing Document Item | EBELN |
| 1 ASSOB | GSBER | TGSB | Business Areas | MANDT |
| 1 ASSOB | GSBER | TGSB | Business Areas | GSBER |
| 0 ASSOB | KDAUF | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| 0 ASSOB | KDAUF | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| 1 ASSOB | KOKRS | TKA01 | Controlling Areas | MANDT |
| 0 ASSOB | KOSTL | CSKS | Cost Center Master Record | MANDT |
| 0 ASSOB | KOSTL | CSKS | Cost Center Master Record | KOKRS |
| 0 ASSOB | KOSTL | CSKS | Cost Center Master Record | KOSTL |
| 0 ASSOB | KOSTL | CSKS | Cost Center Master Record | DATBI |
| 1 ASSOB | KSTRG | CKPH | Master Record: Cost Object ID Number | MANDT |
| 1 ASSOB | KSTRG | CKPH | Master Record: Cost Object ID Number | KSTRG |
| 1 ASSOB | KSTRG | CKPH | Master Record: Cost Object ID Number | DATBI |
| 0 ASSOB | LSTAR | CSLA | Activity master | MANDT |
| 0 ASSOB | LSTAR | CSLA | Activity master | KOKRS |
| 0 ASSOB | LSTAR | CSLA | Activity master | DATBI |
| 1 ASSOB | LTLST | CSLA | Activity master | MANDT |
| 1 ASSOB | LTLST | CSLA | Activity master | KOKRS |
| 1 ASSOB | LTLST | CSLA | Activity master | DATBI |
| 0 ASSOB | MANDT | T000 | Clients | MANDT |
| 1 ASSOB | NPLNR | AUFK | Order master data | AUFNR |
| 0 ASSOB | OTYPE | T778O | Object Types | MANDT |
| 0 ASSOB | OTYPE | T778O | Object Types | OTYPE |
| 1 ASSOB | PDSNR | PDSNR | Sequential Number for PDC Messages | MANDT |
| 1 ASSOB | PDSNR | PDSNR | Sequential Number for PDC Messages | PDSNR |
| 0 ASSOB | POSNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| 0 ASSOB | POSNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| 1 ASSOB | SBUKR | T001 | Company Codes | BUKRS |
| 0 ASSOB | SGSBR | TGSB | Business Areas | MANDT |
| 0 ASSOB | SGSBR | TGSB | Business Areas | GSBER |
| 1 ASSOB | SKOST | CSKS | Cost Center Master Record | MANDT |
| 1 ASSOB | SKOST | CSKS | Cost Center Master Record | KOKRS |
| 1 ASSOB | SKOST | CSKS | Cost Center Master Record | DATBI |
| 0 ASSOB | STELL | T513 | Jobs | MANDT |
| 0 ASSOB | STELL | T513 | Jobs | STELL |
| 0 ASSOB | STELL | T513 | Jobs | ENDDA |
| 1 ASSOB | UDART | T5D7E | Service Categories | MANDT |
| 1 ASSOB | UDART | T5D7E | Service Categories | DART |
| 1 ASSOB | UDART | T5D7E | Service Categories | ENDDA |