SAP table TW07 (SCB group)

SAP table TW07 has 2 primary key fields being MANDT,SGLZB.

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
SGLZB SCB Asset Group Indicator CHAR 4 0 SGLZB
SGLZBE SCB ID revenue/expense CHAR 4 0 TW18 VVSGLZBE
SGLZBSE SCB indicator for tax yield CHAR 4 0 TW18 VVSGLZBSE
SGLZBSA SCB indicator for tax expenditure CHAR 4 0 TW18 VVSGLZBSA
SMELDFORM Form of payment report acc. to § 60 AWG CHAR 1 0 VVSMELDF
1 Payments acc.to append. Z1 to Z3 in acc.w.§60 AWG Par.1 + 2
2 Payments acc. to append.Z4 in acc. with §60 Par. 3
JMELD Subject to reporting indicator CHAR 1 0 VVJMELD

TW07 foreign key relationships

Table Field Check Table Check Field
0 TW07 SGLZBE TW18 Customizing table for SCB indicator MANDT
0 TW07 SGLZBE TW18 Customizing table for SCB indicator SGLZBE
1 TW07 SGLZBSA TW18 Customizing table for SCB indicator MANDT
1 TW07 SGLZBSA TW18 Customizing table for SCB indicator SGLZBE
0 TW07 SGLZBSE TW18 Customizing table for SCB indicator MANDT
0 TW07 SGLZBSE TW18 Customizing table for SCB indicator SGLZBE