SAP table B070 (Transaction/print vers./print ind./label type/label form)

SAP table B070 has 8 primary key fields being MANDT,KAPPL,KSCHL,VGART,WEVER,KZDRU,ETIAR,ETIFO.

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
KAPPL Application CHAR 2 0 T681A KAPPL
KSCHL Output Type CHAR 4 0 T685 NA_KSCHL
VGART Transaction/Event Type CHAR 2 0 T158V VGART
WEVER Version for Printing GR/GI Slip CHAR 1 0 WEVER
1 Individual Slip
2 Individual Slip with Inspection Text
3 Collective Slip
KZDRU Printing of document item CHAR 1 0 T159Q KZDRU
ETIAR Label type CHAR 2 0 T6WP3 ETIAR
ETIFO Label form CHAR 2 0 T6WP4 ETIFO
KNUMH Number of output condition record CHAR 10 0 NNUMH

B070 foreign key relationships

Table Field Check Table Check Field
0 B070 ETIAR T6WP3 Check Table for Labelling Type ETIAR
1 B070 ETIFO T6WP4 Check Table for Label Shape MANDT
1 B070 ETIFO T6WP4 Check Table for Label Shape ETIFO
0 B070 KAPPL T681A Conditions: Applications KAPPL
1 B070 KSCHL T685 Conditions: Types KAPPL
1 B070 KSCHL T685 Conditions: Types KSCHL
0 B070 KZDRU T159Q Inventory Management Print Function: Value Table for KZDRU MANDT
0 B070 KZDRU T159Q Inventory Management Print Function: Value Table for KZDRU KZDRU
1 B070 MANDT T000 Clients MANDT
0 B070 VGART T158V Inv. Mngmt - General: Transaction/Event Types Allowed VGART