T7BRCO5

Compensation balance of GSW | #masterdata | Component: Brazil

🔑 Keys (9)
💰 Amounts (2)
∑ Quantities
📅 Dates
☰ Categorical (2)
Other
🔗 Relations (4)

Column Name	Description
MANDT	Client
BUKRS FK	Company Code
FILIA	Branch code
GSWCODE FK	Collection code
BALYEAR	Year of "Balance for: "
BALMONTH	Month of "Balance for: "	Show values
ORIGYEAR	Year of generating event
ORIGMONTH	Month of generating event	Show values
GSWGRP FK	GSW group	Show values

Column Name	Description
💲 Currency Key (WAERS):
MONTHVALUE	Month amount
BALANCE	Balance

Column Name	Description

Column Name	Description

Column Name	Description
BALMONTH	Month of "Balance for: "	Show values
ORIGMONTH	Month of generating event	Show values

Column Name	Description	Domain name

Master Data Relations \| to Other Relations ↓	Join Conditions
Company Code	`T7BRCO5.MANDT == T001.MANDT` `T7BRCO5.BUKRS == T001.BUKRS`
Currency Key	`T7BRCO5.MANDT == TCURC.MANDT` `T7BRCO5.WAERS == TCURC.WAERS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Collection code ? Client Collection code	`T7BRCO5.[column in domain "ENDDA"] == T7BRCO2.ENDDA` `T7BRCO5.MANDT == T7BRCO2.MANDT` `T7BRCO5.GSWCODE == T7BRCO2.GSWCODE`
GSW group GSW group ? Client	`T7BRCO5.GSWGRP == T7BRCO4.GSWGRP` `T7BRCO5.[column in domain "ENDDA"] == T7BRCO4.ENDDA` `T7BRCO5.MANDT == T7BRCO4.MANDT`