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