SE11 ABAP Dictionary SE11 VTTP

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

VTTP

Shipment Item

SAP SAP Transparent Table 10 Fields

Primary Key:

MANDT TKNUM TPNUM

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	TKNUM	KEY	Shipment	CHAR	10	-	-	Shipment Number
3	TPNUM	KEY	Item	NUMC	4	-	-	Shipment item
4	VBELN	-	Delivery	CHAR	10	-	VBAK	Delivery
5	TPRFO	-	Itinerary	NUMC	4	-	-	Itinerary of shipment items
6	ERNAM	-	Created	CHAR	12	-	-	Name of Person who Created the Object
7	ERDAT	-	On	DATS	8	-	-	Date on Which Record Was Created
8	ERZET	-	Time	TIMS	6	-	-	Entry time
9	PKSTA	-	HU f.deliv	CHAR	1	-	-	There are Packed Deliveries Dependent on Shipping
10	KZHULFG	-	HU DIs	CHAR	1	-	-	Indicator: Delivery Items for HUs Generated

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk VTTP.

Interactive ERD Diagrams

SAP SD - Shipping Tables Relation → SAP SD Table Mapping & Document Flow →

Standard T-Codes

SE11 SE16

Related Tables

VBAK LIKP LIPS VTTK VBLK VEPO VEKP VTFA

ANSI SQL Query

SELECT a.TKNUM,
       a.TPNUM,
       a.VBELN,
       a.TPRFO,
       a.ERNAM,
       a.ERDAT,
       a.ERZET
FROM VTTP AS a
WHERE a.TKNUM = '0001'
  AND a.TPNUM = '0001';

ABAP OpenSQL (7.40+)

SELECT a~tknum,
       a~tpnum,
       a~vbeln,
       a~tprfo,
       a~ernam,
       a~erdat,
       a~erzet
  FROM vttp AS a
  WHERE a~tknum = '0001'
  and a~tpnum = '0001'
  INTO TABLE @DATA(lt_vttp)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 VTTP

VTTP

Dictionary Fields Fields

Related References & SQL