P2B2_C1

HCM Declustering B2 - Cost Distribution Table C1 | #transactional | Component: Tools

🔑 Keys (6)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical
Other (23)
🔗 Relations (21)

Column Name	Description
MANDT	Client
DCT_PERNR	Personnel Number
DCT_PABRJ	Payroll Year
DCT_PABRP	Payroll Period
DCT_CLTYP	Type of cluster
DCT_ROWID	Unique Row Number

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description	Domain name
C1ZNR	Pointer to cost accounting	C1NUM
VORNR	Operation/Activity Number	VORNR
KDPOS	Item number in Sales Order	NUM06
PAOBJNR	Profitability Segment Number (CO-PA)	RKEOBJNR
PRZNR	Business Process	CO_PRZNR
FISTL	Funds Center	FISTL
FIPOS	Commitment Item	FIPOS
GEBER	Fund	BP_GEBER
EXBEL	Assignment number	HR_ZUONR
MWSKZ	Tax on sales/purchases code	MWSKZ
POHRS	Number of Hours for Activity Allocation/External Services	PTM_DEC5_2S
SGTXT	Item Text	TEXT50
TXJCD	Tax Jurisdiction	TXJCD
FIPEX	Commitment Item	FM_FIPEX
FKBER	Functional Area	FKBER
GRANT_NBR	Grant	GM_GRANT_NBR
SGEBER	Sender fund	BP_GEBER
SFKBER	Sending Functional Area	FKBER
SGRANT_NBR	Sender Grant	GM_GRANT_NBR
SEGMENT	Segment for Segmental Reporting	FB_SEGMENT
SSEGMENT	Segment for Segmental Reporting	FB_SEGMENT
BUDGET_PD	Budget Period	FM_BUDGET_PERIOD
SBUDGET_PD	FM: Sender Budget Period	FM_BUDGET_PERIOD

Master Data Relations	Join Conditions
Order Number Order Number Client	`P2B2_C1.AUFNR == AUFK.AUFNR` `P2B2_C1.MANDT == AUFK.MANDT`
Company Code	`P2B2_C1.MANDT == T001.MANDT` `P2B2_C1.BUKRS == T001.BUKRS`
Service Type (Public Service Germany) ? Service Type (Public Service Germany) ?	`P2B2_C1.MANDT == T5D7C.MANDT` `P2B2_C1.[column in domain "DAKAT"] == T5D7C.DAKAT` `P2B2_C1.DART == T5D7C.DART` `P2B2_C1.[column in domain "ENDDA"] == T5D7C.ENDDA`
Business Area	`P2B2_C1.MANDT == TGSB.MANDT` `P2B2_C1.GSBER == TGSB.GSBER`
Controlling Area	`P2B2_C1.MANDT == TKA01.MANDT` `P2B2_C1.KOKRS == TKA01.KOKRS`
Cost Center ? Cost Center Controlling Area	`P2B2_C1.MANDT == CSKS.MANDT` `P2B2_C1.[column in domain "DATBI"] == CSKS.DATBI` `P2B2_C1.KOSTL == CSKS.KOSTL` `P2B2_C1.KOKRS == CSKS.KOKRS`
Cost Object Cost Object ? Client	`P2B2_C1.KSTRG == CKPH.KSTRG` `P2B2_C1.[column in domain "DATBI"] == CKPH.DATBI` `P2B2_C1.MANDT == CKPH.MANDT`
Activity Type Controlling Area Activity Type ?	`P2B2_C1.MANDT == CSLA.MANDT` `P2B2_C1.KOKRS == CSLA.KOKRS` `P2B2_C1.LSTAR == CSLA.LSTAR` `P2B2_C1.[column in domain "DATBI"] == CSLA.DATBI`
Activity Number	`P2B2_C1.MANDT == ASMD.MANDT` `P2B2_C1.LSTNR == ASMD.ASNUM`
Activity Type Controlling Area Activity Type ?	`P2B2_C1.MANDT == CSLA.MANDT` `P2B2_C1.KOKRS == CSLA.KOKRS` `P2B2_C1.LTLST == CSLA.LSTAR` `P2B2_C1.[column in domain "DATBI"] == CSLA.DATBI`
Network Number for Account Assignment Network Number for Account Assignment Client	`P2B2_C1.NPLNR == AUFK.AUFNR` `P2B2_C1.MANDT == AUFK.MANDT`
Object Type	`P2B2_C1.MANDT == T778O.MANDT` `P2B2_C1.OTYPE == T778O.OTYPE`
Company Code	`P2B2_C1.MANDT == T001.MANDT` `P2B2_C1.SBUKR == T001.BUKRS`
Business Area	`P2B2_C1.MANDT == TGSB.MANDT` `P2B2_C1.SGSBR == TGSB.GSBER`
Cost Center ? Cost Center Controlling Area	`P2B2_C1.MANDT == CSKS.MANDT` `P2B2_C1.[column in domain "DATBI"] == CSKS.DATBI` `P2B2_C1.SKOST == CSKS.KOSTL` `P2B2_C1.KOKRS == CSKS.KOKRS`
Service Category (Public Service Germany) ? ? Service Type (Public Service Germany) Service Category (Public Service Germany)	`P2B2_C1.MANDT == T5D7E.MANDT` `P2B2_C1.[column in domain "ENDDA"] == T5D7E.ENDDA` `P2B2_C1.[column in domain "DAKAT"] == T5D7E.DAKAT` `P2B2_C1.DART == T5D7E.DART` `P2B2_C1.UDART == T5D7E.UDART`

Other Relations \| to Master Data Relations ↑	Join Conditions
Job Job Client ?	`P2B2_C1.STELL == T513.STELL` `P2B2_C1.MANDT == T513.MANDT` `P2B2_C1.[column in domain "ENDDA"] == T513.ENDDA`