SAP Table T5DBV
Construction Pay: Cost Assignment: Hostels
T5DBV (Construction Pay: Cost Assignment: Hostels) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T5DBV to other SAP tables.
T5DBV table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| MOLGA | Country Grouping | MOLGA | T500L | CHAR | 2 | 0 | ||
| WOHNR | Hostel Number | P01B_WOHNR | CHAR | 4 | 0 | |||
| WHBEZ | Construction Pay: Hostel Name | P01B_WHBEZ | CHAR | 25 | 0 | |||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||
| KOSTL | Cost Center | KOSTL | CSKS | CHAR | 10 | 0 | ||
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 | 0 | ||
| KSTRG | Cost Object | KSTRG | CKPH | CHAR | 12 | 0 | ||
| POSNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 | 0 | ||
| NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | 0 | |||
| VORNR | Operation/Activity Number | VORNR | CHAR | 4 | 0 | |||
| KDAUF | Sales Order Number | KDAUF | CHAR | 10 | 0 | |||
| KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | 0 | |||
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | 0 | |||
| PRZNR | Business Process | CO_PRZNR | CHAR | 12 | 0 | |||
| FISTL | Funds Center | FISTL | CHAR | 16 | 0 | |||
| FIPOS | Commitment Item | FIPOS | CHAR | 14 | 0 | |||
| GEBER | Fund | BP_GEBER | CHAR | 10 | 0 | |||
| EBELN | Purchasing Document Number | EBELN | CHAR | 10 | 0 | |||
| EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | 0 | |||
| LSTNR | Activity Number | ASNUM | ASMD | CHAR | 18 | 0 | ||
| LTLST | Activity Type | LSTAR | CSLA | CHAR | 6 | 0 | ||
| SBUKR | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||
| SGSBR | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||
| SKOST | Cost Center | KOSTL | CSKS | CHAR | 10 | 0 | ||
| LSTAR | Activity Type | LSTAR | CSLA | CHAR | 6 | 0 | ||
| EXBEL | Assignment number | HR_ZUONR | CHAR | 18 | 0 | |||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | 0 | |||
| OTYPE | Object Type | OTYPE | T778O | CHAR | 2 | 0 | ||
| STELL | Job | STELL | NUMC | 8 | 0 | |||
| POHRS | Number of Hours for Activity Allocation/External Services | POHRS | DEC | 7 | 2 | |||
| DART | Service Type (Public Service Germany) | DART | T5D7C | CHAR | 2 | 0 | ||
| UDART | Service Category (Public Service Germany) | UDART | T5D7E | CHAR | 2 | 0 | ||
| SGTXT | Item Text | SGTXT | CHAR | 50 | 0 | |||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | 0 | |||
| FIPEX | Commitment Item | FM_FIPEX | CHAR | 24 | 0 | |||
| FKBER | Functional Area | FKBER | CHAR | 16 | 0 | |||
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | 0 | |||
| SGEBER | Sender fund | FM_SFONDS | CHAR | 10 | 0 | |||
| SFKBER | Sending Functional Area | SFKTBER | CHAR | 16 | 0 | |||
| SGRANT_NBR | Sender Grant | GM_GRANT_SENDER | CHAR | 20 | 0 | |||
| SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | 0 | |||
| SSEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | 0 | |||
| BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | 0 | |||
| SBUDGET_PD | FM: Sender Budget Period | FM_SBUDGET_PERIOD | CHAR | 10 | 0 | |||
T5DBV foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| T5DBV | AUFNR | T5DBV | MANDT | AUFK | Order master data | MANDT |
| T5DBV | AUFNR | T5DBV | AUFNR | AUFK | Order master data | AUFNR |
| T5DBV | BUKRS | T5DBV | MANDT | T001 | Company Codes | MANDT |
| T5DBV | BUKRS | T5DBV | BUKRS | T001 | Company Codes | BUKRS |
| T5DBV | DART | SYST | MANDT | T5D7C | Service Types | MANDT |
| T5DBV | DART | * | T5D7C | Service Types | DAKAT | |
| T5DBV | DART | T5DBV | DART | T5D7C | Service Types | DART |
| T5DBV | DART | * | T5D7C | Service Types | ENDDA | |
| T5DBV | GSBER | T5DBV | MANDT | TGSB | Business Areas | MANDT |
| T5DBV | GSBER | T5DBV | GSBER | TGSB | Business Areas | GSBER |
| T5DBV | KOKRS | T5DBV | MANDT | TKA01 | Controlling Areas | MANDT |
| T5DBV | KOKRS | T5DBV | KOKRS | TKA01 | Controlling Areas | KOKRS |
| T5DBV | KOSTL | T5DBV | KOSTL | CSKS | Cost Center Master Data | KOSTL |
| T5DBV | KOSTL | * | CSKS | Cost Center Master Data | DATBI | |
| T5DBV | KOSTL | T5DBV | MANDT | CSKS | Cost Center Master Data | MANDT |
| T5DBV | KOSTL | T5DBV | KOKRS | CSKS | Cost Center Master Data | KOKRS |
| T5DBV | KSTRG | T5DBV | MANDT | CKPH | Master Record: Cost Object ID Number | MANDT |
| T5DBV | KSTRG | T5DBV | KSTRG | CKPH | Master Record: Cost Object ID Number | KSTRG |
| T5DBV | KSTRG | * | CKPH | Master Record: Cost Object ID Number | DATBI | |
| T5DBV | LSTAR | SYST | MANDT | CSLA | Activity master | MANDT |
| T5DBV | LSTAR | T5DBV | KOKRS | CSLA | Activity master | KOKRS |
| T5DBV | LSTAR | T5DBV | LSTAR | CSLA | Activity master | LSTAR |
| T5DBV | LSTAR | * | CSLA | Activity master | DATBI | |
| T5DBV | LSTNR | SYST | MANDT | ASMD | Service Master: Basic Data | MANDT |
| T5DBV | LSTNR | T5DBV | LSTNR | ASMD | Service Master: Basic Data | ASNUM |
| T5DBV | LTLST | T5DBV | KOKRS | CSLA | Activity master | KOKRS |
| T5DBV | LTLST | T5DBV | LTLST | CSLA | Activity master | LSTAR |
| T5DBV | LTLST | * | CSLA | Activity master | DATBI | |
| T5DBV | LTLST | SYST | MANDT | CSLA | Activity master | MANDT |
| T5DBV | MANDT | T5DBV | MANDT | T000 | Clients | MANDT |
| T5DBV | MOLGA | T5DBV | MOLGA | T500L | Personnel Country Grouping | MOLGA |
| T5DBV | OTYPE | T5DBV | OTYPE | T778O | Object Types | OTYPE |
| T5DBV | OTYPE | SYST | MANDT | T778O | Object Types | MANDT |
| T5DBV | POSNR | T5DBV | MANDT | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| T5DBV | POSNR | T5DBV | POSNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| T5DBV | SBUKR | SYST | MANDT | T001 | Company Codes | MANDT |
| T5DBV | SBUKR | T5DBV | SBUKR | T001 | Company Codes | BUKRS |
| T5DBV | SGSBR | SYST | MANDT | TGSB | Business Areas | MANDT |
| T5DBV | SGSBR | T5DBV | SGSBR | TGSB | Business Areas | GSBER |
| T5DBV | SKOST | * | CSKS | Cost Center Master Data | DATBI | |
| T5DBV | SKOST | SYST | MANDT | CSKS | Cost Center Master Data | MANDT |
| T5DBV | SKOST | T5DBV | KOKRS | CSKS | Cost Center Master Data | KOKRS |
| T5DBV | SKOST | T5DBV | SKOST | CSKS | Cost Center Master Data | KOSTL |
| T5DBV | UDART | * | T5D7E | Service Categories | DAKAT | |
| T5DBV | UDART | T5DBV | DART | T5D7E | Service Categories | DART |
| T5DBV | UDART | T5DBV | UDART | T5D7E | Service Categories | UDART |
| T5DBV | UDART | * | T5D7E | Service Categories | ENDDA | |
| T5DBV | UDART | SYST | MANDT | T5D7E | Service Categories | MANDT |
