VIVEDA

57 Fields 2 CDS Views

Generated Table for View

VIVEDA is an SAP database table in S/4HANA. Generated Table for View. It contains 57 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
SHSM_DPSPP_VBAK_VBELN view from CDS view for searh help DPSPP_VBAK_VBELN
SHSM_VIVEDA view from CDS view for search help WTY_F4_VBAP

Fields (57)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vbeln VBELN_VA Sales Document
KEY posnr POSNR_VA Item
auart AUART Sales Doc. Type
vbtyp VBTYPL Document Cat.
augru AUGRU Order Reason
ernam ERNAM Created By
submi SUBMI_SD Collective No.
faksk FAKSK Billing Block
netwr NETWR_AK Net Value
waerk WAERK Doc. Currency
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
vkgrp VKGRP Sales Group
vkbur VKBUR Sales Office
bstzd BSTZD Supplement
bname BNAME_V Name
telf1 TELF1_VP Telephone
kunnr KUNAG Sold-to Party
kvgr1 KVGR1 Customer Grp 1
kvgr2 KVGR2 Customer Grp 2
kvgr3 KVGR3 Customer Grp 3
kvgr4 KVGR4 Customer Grp 4
kvgr5 KVGR5 Customer Grp 5
matnrx MATNR Material
matwa MATWA MaterialEntered
charg CHARG_D Batch
matkl MATKL Material Group
arktx ARKTX Item Descr.
pstyv PSTYV Item Category
uepos UEPOS Higher-Lev.Item
abgru ABGRU_VA RejectionReason
prodh PRODH_D Prod. Hierarchy
zmeng DZMENG Target Quantity
zieme DZIEME Target Qty UoM
umziz UMZIZ Convers.Factor
umzin UMZIN Convers.Factor
meins MEINS Base Unit
kdmat MATNR_KU Cust. Material
posex POSEX PO Item
faksp FAKSP_AP Billing Block
spart SPART Division
netwrx NETWR_AP Net Value
vgbel VGBEL Reference Doc.
vgpos VGPOS Reference Item
werks WERKS_EXT Plant
netpr NETPR Net Price
ean11 EAN11 EAN/UPC
mvgr1 MVGR1 MaterialGroup 1
mvgr2 MVGR2 MaterialGroup 2
mvgr3 MVGR3 MaterialGroup 3
mvgr4 MVGR4 MaterialGroup 4
mvgr5 MVGR5 MaterialGroup 5
prctr PRCTR Profit Center
cuobj CUOBJ_VA Configuration
waerkx WAERK Doc. Currency
ktext KTEXT_V Description

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VIVEDA (
    MANDT,   -- Client [MANDT]
    VBELN,   -- Sales Document [VBELN_VA]
    POSNR,   -- Item [POSNR_VA]
    AUART,   -- Sales Doc. Type [AUART]
    VBTYP,   -- Document Cat. [VBTYPL]
    AUGRU,   -- Order Reason [AUGRU]
    ERNAM,   -- Created By [ERNAM]
    SUBMI,   -- Collective No. [SUBMI_SD]
    FAKSK,   -- Billing Block [FAKSK]
    NETWR,   -- Net Value [NETWR_AK]
    WAERK,   -- Doc. Currency [WAERK]
    VKORG,   -- Sales Org. [VKORG]
    VTWEG,   -- Distr. Channel [VTWEG]
    VKGRP,   -- Sales Group [VKGRP]
    VKBUR,   -- Sales Office [VKBUR]
    BSTZD,   -- Supplement [BSTZD]
    BNAME,   -- Name [BNAME_V]
    TELF1,   -- Telephone [TELF1_VP]
    KUNNR,   -- Sold-to Party [KUNAG]
    KVGR1,   -- Customer Grp 1 [KVGR1]
    KVGR2,   -- Customer Grp 2 [KVGR2]
    KVGR3,   -- Customer Grp 3 [KVGR3]
    KVGR4,   -- Customer Grp 4 [KVGR4]
    KVGR5,   -- Customer Grp 5 [KVGR5]
    MATNRX,  -- Material [MATNR]
    MATWA,   -- MaterialEntered [MATWA]
    CHARG,   -- Batch [CHARG_D]
    MATKL,   -- Material Group [MATKL]
    ARKTX,   -- Item Descr. [ARKTX]
    PSTYV,   -- Item Category [PSTYV]
    UEPOS,   -- Higher-Lev.Item [UEPOS]
    ABGRU,   -- RejectionReason [ABGRU_VA]
    PRODH,   -- Prod. Hierarchy [PRODH_D]
    ZMENG,   -- Target Quantity [DZMENG]
    ZIEME,   -- Target Qty UoM [DZIEME]
    UMZIZ,   -- Convers.Factor [UMZIZ]
    UMZIN,   -- Convers.Factor [UMZIN]
    MEINS,   -- Base Unit [MEINS]
    KDMAT,   -- Cust. Material [MATNR_KU]
    POSEX,   -- PO Item [POSEX]
    FAKSP,   -- Billing Block [FAKSP_AP]
    SPART,   -- Division [SPART]
    NETWRX,  -- Net Value [NETWR_AP]
    VGBEL,   -- Reference Doc. [VGBEL]
    VGPOS,   -- Reference Item [VGPOS]
    WERKS,   -- Plant [WERKS_EXT]
    NETPR,   -- Net Price [NETPR]
    EAN11,   -- EAN/UPC [EAN11]
    MVGR1,   -- MaterialGroup 1 [MVGR1]
    MVGR2,   -- MaterialGroup 2 [MVGR2]
    MVGR3,   -- MaterialGroup 3 [MVGR3]
    MVGR4,   -- MaterialGroup 4 [MVGR4]
    MVGR5,   -- MaterialGroup 5 [MVGR5]
    PRCTR,   -- Profit Center [PRCTR]
    CUOBJ,   -- Configuration [CUOBJ_VA]
    WAERKX,  -- Doc. Currency [WAERK]
    KTEXT,   -- Description [KTEXT_V]
    PRIMARY KEY (MANDT, VBELN, POSNR)
);

Learn More