SAP table V_OIO_HD_AREA (Generated Table for View)

SAP table V_OIO_HD_AREA has 2 primary key fields being MANDT,TKNUM.

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
TKNUM Shipment Number CHAR 10 0 * TKNUM
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
§ Revenue Recognition/New View (Temporary)
SHTYP Shipment type CHAR 4 0 TVTK SHTYP
TPLST Transportation planning point CHAR 4 0 TTDS TPLST
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
ERZET Entry time TIMS 6 0 ERZET
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
AEZET Time last change was made TIMS 6 0 AEZET
VSBED Shipping Conditions CHAR 2 0 TVSB VSBED
ROUTE Shipment route CHAR 6 0 TVRO ROUTR
SIGNI Container ID CHAR 20 0 SIGNI
EXTI1 External identification 1 CHAR 20 0 EXTI1
EXTI2 External identification 2 CHAR 20 0 EXTI2
TPBEZ Description of Shipment CHAR 20 0 TPBEZ
STDIS Status of transportation planning CHAR 1 0 STDIS
PKSTK Shipment Contains Handling Units CHAR 1 0 PKSTK_VTTK
DTMEG Unit of Weight for Transportation Planning UNIT 3 0 * DTMEG
DTMEV Volume Unit for Transportation Planning UNIT 3 0 * DTMEV
HANDLE Globally unique identifier (linked to time segment, etc) CHAR 22 0 TSEGGUID
ADD01 Suppl. 1 CHAR 10 0 VTADD01 VTTK_ADD01
ADD02 Suppl. 2 CHAR 10 0 VTADD02 VTTK_ADD02
ADD03 Suppl. 3 CHAR 10 0 VTADD03 VTTK_ADD03
ADD04 Suppl. 4 CHAR 10 0 VTADD04 VTTK_ADD04
TEXT1 Addit.text 1 CHAR 40 0 VTTK_TEXT1
TEXT2 Addit.text 2 CHAR 40 0 VTTK_TEXT2
TEXT3 Addit.text 3 CHAR 40 0 VTTK_TEXT3
TEXT4 Addit.text 4 CHAR 40 0 VTTK_TEXT4

V_OIO_HD_AREA foreign key relationships

Table Field Check Table Check Field
0 V_OIO_HD_AREA ADD01 VTADD01 Checking Table Supplement 1 MANDT
0 V_OIO_HD_AREA ADD01 VTADD01 Checking Table Supplement 1 ADD_INFO
1 V_OIO_HD_AREA ADD02 VTADD02 Checking Table Supplement 2 MANDT
1 V_OIO_HD_AREA ADD02 VTADD02 Checking Table Supplement 2 ADD_INFO
0 V_OIO_HD_AREA ADD03 VTADD03 Checking Table Supplement 3 MANDT
0 V_OIO_HD_AREA ADD03 VTADD03 Checking Table Supplement 3 ADD_INFO
1 V_OIO_HD_AREA ADD04 VTADD04 Checking Table Supplement 4 MANDT
1 V_OIO_HD_AREA ADD04 VTADD04 Checking Table Supplement 4 ADD_INFO
0 V_OIO_HD_AREA MANDT T000 Clients MANDT
1 V_OIO_HD_AREA ROUTE TVRO Routes MANDT
1 V_OIO_HD_AREA ROUTE TVRO Routes ROUTE
0 V_OIO_HD_AREA SHTYP TVTK Shipment Types MANDT
1 V_OIO_HD_AREA TPLST TTDS Organizational Unit: Transportation Scheduling Point TPLST
0 V_OIO_HD_AREA VSBED TVSB Shipping Conditions MANDT
0 V_OIO_HD_AREA VSBED TVSB Shipping Conditions VSBED