SAP table VBSK (Collective Processing for a Sales Document Header)
SAP table VBSK has 2 primary key fields being MANDT,SAMMG.
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 | |
| SAMMG | Group | CHAR | 10 | 0 | SAMMG | ||
| SMART | Group Type | CHAR | 1 | 0 | TVSA | SMART | |
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| UZEIT | Time | TIMS | 6 | 0 | UZEIT | ||
| VBNUM | Number of created documents | NUMC | 4 | 0 | VBNUM | ||
| ERNUM | Number of errors that occurred | NUMC | 4 | 0 | ERNUM | ||
| BRGEW | Gross weight of all processed documents | QUAN | 13 | 3 | BRGEW_SG | ||
| GEWEI | Weight Unit | UNIT | 3 | 0 | T006 | GEWEI | |
| VOLUM | Volume of all processed documents | QUAN | 13 | 3 | VOLUM_SG | ||
| VOLEH | Volume unit | UNIT | 3 | 0 | T006 | VOLEH | |
| VSTEL | Shipping Point / Receiving Point | CHAR | 4 | 0 | TVST | VSTEL | |
| VTEXT | Description | CHAR | 30 | 0 | BEZEI30 | ||
| MAXZT | Maximum labor capacity of the shipping point in days | DEC | 5 | 2 | MAXZT | ||
| PROGRAMM | ABAP Program Name | CHAR | 40 | 0 | PROGRAMM | ||
| SELSET | ABAP: Name of variant (without program name) | CHAR | 14 | 0 | VARIANT | ||
| BATCH | Indicator: Processing in background | CHAR | 1 | 0 | BATCH_COLL | ||
| ANZLP | Number of delivery items created in collective processing | INT4 | 10 | 0 | ANZLP | ||
| ANZGP | Number of items read in collective processing | INT4 | 10 | 0 | ANZGP | ||
| ANZGI | Number of indexes read in collective processing | INT4 | 10 | 0 | ANZGI | ||
| KWPRO | Picking wave profile | CHAR | 6 | 0 | T318 | KW_PROFIL | |
| KAPTP | Shift Definition | CHAR | 4 | 0 | KAPTPROG | ||
| LGNUM | Warehouse Number / Warehouse Complex | CHAR | 3 | 0 | T300 | LGNUM | |
| BEDAT | Date of deliveries in picking waves | DATS | 8 | 0 | BELEG_DATUM | ||
| WRAST | Timeslot group | CHAR | 4 | 0 | WRAST | ||
| COLLECTIVERUN_UUID | Globally Unique Identifier | RAW | 16 | 0 | GUID |
VBSK foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 VBSK | GEWEI | T006 | Units of Measurement | MANDT |
| 0 VBSK | GEWEI | T006 | Units of Measurement | MSEHI |
| 1 VBSK | KWPRO | T318 | Picking waves profile | MANDT |
| 1 VBSK | KWPRO | T318 | Picking waves profile | LGNUM |
| 0 VBSK | LGNUM | T300 | WM Warehouse Numbers | MANDT |
| 0 VBSK | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
| 1 VBSK | MANDT | T000 | Clients | MANDT |
| 0 VBSK | SMART | TVSA | SD Documents: Processing Groups | MANDT |
| 0 VBSK | SMART | TVSA | SD Documents: Processing Groups | SMART |
| 1 VBSK | VOLEH | T006 | Units of Measurement | MANDT |
| 1 VBSK | VOLEH | T006 | Units of Measurement | MSEHI |
| 0 VBSK | VSTEL | TVST | Organizational Unit: Shipping Points | MANDT |
| 0 VBSK | VSTEL | TVST | Organizational Unit: Shipping Points | VSTEL |