TVTY
Packaging Material Types
TVTY is an SAP database table in S/4HANA. Packaging Material Types. It contains 17 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /SCMB/P_TPMTYP | view | from | Replacement Packaging Material Type | |
| I_MeansOfTransportType | view | from | BASIC | Packaging Material Type |
| I_PackagingMaterialType | view | from | BASIC | Packaging Material Types |
Fields (17)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | traty | vhiart | Packag.Mat.Type | |||
| kappl | na_kappl | Application | ||||
| kalsm | kalsmb | OutputDet.Proc. | ||||
| kschl | na_kschl | Output Type | ||||
| sortf | sort_vhart | Sort | ||||
| werfd | werfd | Plant Determin. | ||||
| veltp | veltp | Pack. Mat. Cat. | ||||
| gruvs | gruvs_tvty | Data transfer | ||||
| nrverg | vv_nrvrg | Number Assignment | ||||
| sscc18 | ean128_hu_art | HU ty. | ||||
| int_nkr | vv_int_nkr | Int. Interval | ||||
| ext_nkr | vv_ext_nkr | Ext. Interval | ||||
| taravar | hum_taravar | Tare variable | ||||
| stsma | hum_stsma | Status Profile | ||||
| kzpgn | hum_kzpgn | Gen. Delivery Items | ||||
| delete_hu_if_empty | lohum_delete_hu_if_empty | Delete Empty HUs |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Packaging Material Types
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVTY (
MANDT, -- Client [mandt]
TRATY, -- Packag.Mat.Type [vhiart]
KAPPL, -- Application [na_kappl]
KALSM, -- OutputDet.Proc. [kalsmb]
KSCHL, -- Output Type [na_kschl]
SORTF, -- Sort [sort_vhart]
WERFD, -- Plant Determin. [werfd]
VELTP, -- Pack. Mat. Cat. [veltp]
GRUVS, -- Data transfer [gruvs_tvty]
NRVERG, -- Number Assignment [vv_nrvrg]
SSCC18, -- HU ty. [ean128_hu_art]
INT_NKR, -- Int. Interval [vv_int_nkr]
EXT_NKR, -- Ext. Interval [vv_ext_nkr]
TARAVAR, -- Tare variable [hum_taravar]
STSMA, -- Status Profile [hum_stsma]
KZPGN, -- Gen. Delivery Items [hum_kzpgn]
DELETE_HU_IF_EMPTY, -- Delete Empty HUs [lohum_delete_hu_if_empty]
PRIMARY KEY (MANDT, TRATY)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA