SAP table REBR (Batch Record: Overall Profile)
SAP table REBR has 3 primary key fields being MANDT,MATNR,WERKS.
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 | |
| MATNR | Material Number | CHAR | 40 | 0 | MARA | MATNR | |
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| SIGNSTRAT | Signature Strategy | CHAR | 8 | 0 | TC85 | SIGNSTRAT | |
| LAYOUT | Document profile for batch records | NUMC | 8 | 0 | REBR1 | LYTPROF | |
| DEVPROF_APPR | Deviation Profile for Aut. Deviation Analysis Bef. Approval | CHAR | 8 | 0 | REBR3 | DEVPROF_APPR | |
| DEVPROF_ARCH | Deviation Profile for Aut. Deviation Analysis Bef. Archiving | CHAR | 8 | 0 | REBR3 | DEVPROF_ARCH | |
| DEVPROF_MANU | Deviation Profile for Manual Deviation Analysis | CHAR | 8 | 0 | REBR3 | DEVPROF_MANU | |
| EBR_AWST | Status Profile | CHAR | 8 | 0 | TJ20 | J_STSMA | |
| FLG_ARCH_APPR | Automatically Archive Batch Record During Approval | CHAR | 1 | 0 | FLG_ARCH_APPR | ||
| EBR_VALDATE | Availability period of batch record in years | NUMC | 2 | 0 | CHP_DAUER |
REBR foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 REBR | DEVPROF_APPR | REBR3 | Batch Record: Profile for Deviation Analysis | MANDT |
| 1 REBR | DEVPROF_ARCH | REBR3 | Batch Record: Profile for Deviation Analysis | MANDT |
| 0 REBR | DEVPROF_MANU | REBR3 | Batch Record: Profile for Deviation Analysis | MANDT |
| 1 REBR | EBR_AWST | TJ20 | Status profiles | MANDT |
| 1 REBR | EBR_AWST | TJ20 | Status profiles | STSMA |
| 0 REBR | LAYOUT | REBR1 | Batch Record: Layout Profile | MANDT |
| 0 REBR | LAYOUT | REBR1 | Batch Record: Layout Profile | LAYOUT |
| 1 REBR | MATNR | MARA | General Material Data | MANDT |
| 1 REBR | MATNR | MARA | General Material Data | MATNR |
| 0 REBR | SIGNSTRAT | TC85 | Signature Strategy | MANDT |
| 0 REBR | SIGNSTRAT | TC85 | Signature Strategy | APPLICID |
| 1 REBR | WERKS | T001W | Plants/Branches | WERKS |