SAP table VBAG (Sales Document: Release Data by Schedule Line in Sch.Agrmt.)
SAP table VBAG has 5 primary key fields being MANDT,VBELN,POSNR,ABART,ABRUF.
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 | |||||||||||||||||
| VBELN | Sales Document | CHAR | 10 | 0 | VBELN_VA | ||||||||||||||||||
| POSNR | Sales Document Item | NUMC | 6 | 0 | POSNR_VA | ||||||||||||||||||
| ABART | Release type | CHAR | 1 | 0 | ABART |
|
|||||||||||||||||
| ABRUF | Forecast Delivery schedule number | NUMC | 10 | 0 | ABRUF | ||||||||||||||||||
| ABRDT | Delivery Schedule Date | DATS | 8 | 0 | ABRDT | ||||||||||||||||||
| ABSTA | Release status (current release, old release) | CHAR | 1 | 0 | ABSTA | ||||||||||||||||||
| ABEFZ | Cumulative figure for customer in sales unit | QUAN | 13 | 3 | ABEFZ | ||||||||||||||||||
| ABMFR | Number of days for which material is available | NUMC | 3 | 0 | ABMFR | ||||||||||||||||||
| ABFFR | Number of days assigned for production | NUMC | 3 | 0 | ABFFR | ||||||||||||||||||
| ABHOR | JIT horizon | DATS | 8 | 0 | ABHOR |
VBAG foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 VBAG | MANDT | T000 | Clients | MANDT |