TVAK

Transparent Table Customizing (protected)
135 Fields 16 CDS Views

Sales Document Types

TVAK is an SAP database table in S/4HANA. Sales Document Types. It contains 135 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
/dmbe/i_ContractTypeSell view from Descriptions for sales document types
arun_i_so_reqmt view inner Sales Order selection in Normal mode
ARUN_I_SO_REQMT_PREV view inner Sales Order selection from Preview table
ARUN_SD_DB view inner Sales document data
Arun_So_Reqmt view left_outer Sales Order Requirement
CIC_CustomerOrderTypeCode view_entity from Customer Order Type Code
I_ExcessRqmtQtySlsDocMainItm view inner BASIC Sales Document Main(Non Value Added Service) Items
I_ExssRqmtMultiShipToOrdItm view inner BASIC Sales Document Main MSO Items
I_RFM_MaSaDoSlsDocumentHdr view inner BASIC Sales Document Basic
I_RFM_MaSaDoSlsDocumentItm view inner BASIC Sales Document Item
I_RFM_PrvsnlSlsContrDocHdr view inner BASIC Provisional Sales Contract Document Header
I_RFMSalesDocumentType view from BASIC Sales Document Type Details
I_SalesDocumentType view from BASIC Sales Document Type
I_WhereUsdPrftCtrSlsOrdCat view from BASIC Where-Used Profit Center: SO Category
P_WhereUsdPrftCtrSlsDocItem view_entity inner BASIC
RFM_SalesDocumentCopyControl view inner

Fields (135)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY auart auart Sales Doc. Type
kopgr bifgr Screen seq.grp
lfarv lfarv Delivery type
fkarv fkarv DlvBillingType
fkara fkara Ord-Rel.Bill.Ty
numki numki NR of Int. Asst
numke numke NR of Ext. Asst
incpo incpo ItemNoIncrement
uevor uevor_va FCode OvervScrn
augrp char2 Component of the Version Number
umfng umfng Display Range
dabar dabar Release type
pargr pargr PartnDet.Proc.
faksk faksp Billing Block
lifsk lifsk Delivery Block
trvog trvog_va Transact.group
spapo spapo Item division
spapr spapr Check Division
vstrm vstrm Dlv. Scheduling
trtrm trtrm Transport. Schd
txn08 txn08 Standard Text
diafe diauv Incomplet.messg
feldk feldk Field sel.grpHd
datvo datvo_vak Prop.Deliv.Date
awahr awahr_ak Probability
vbtyp vbtypl Document Cat.
vsbed vsbed_vak Shipping cond.
bezob bezob Reference Mand.
txtgr txtgr TextDetermProc.
kalvg kalvg DocPricingProc.
ernam ernam Created By
fehgr fehgr Incompl.Proced.
infls infls Read Cust. Matl
kunn0 kunn0 CuNo 0 allowed
klimp klimp Credit limit
kalsm kalsmb OutputDet.Proc.
kappl na_kappl Application
kschl na_kschl Output Type
sperr spevb Document Block
stgak stgak Doc.stats.group
kalsu kalsu Mat.determin.
kalli kalli Listing
kalau kalau Exclusion
fkaiv fkaiv IntercoBillType
cmgra cmgra Credit group order
objart_hin sdobjarth DocType-Create
objart_ver sdobjartv DocType-Change
abrvw abrvw Usage
abdis abdis MRP for DS type
kprgbz prgrs Date type
prdatv prdatv Prp.Pricing Dte
vlauf vlauf Lead Time
guebgv guebgv PropValFromDate
vterl vterl Contrct allowed
hnwag hnwag Quot.Messages
hnwkm hnwkm OutlineAgrMess.
stsma j_stsma Status Profile
lisof lisof Immediate dlv
auara auara Subseq.ord.type
korli korli Corr.dlv.type
vprof vprof Contract prof.
aufak aufak Billing request
diapa diapa ProdAttrMessage
fpart fpart BillingPlanType
kschl_ko kschl_ko CndTypLineItems
excok excok Legal Control
exmod exmod Time interval
kskpf kskpf PricProcCondHd
kspos kspos PricProcCondIt
lifsm lifsm Delivery block
fktkt fktkt F.activity type
exdia exdia Dialog Leg.Cntl
abgru_in abgru_in RejectionReason
prbst prbst Chck CustRef
scheme_grp scheme_grp Ref.procedure
hnwgk hnwgk MastContMessage
push_grp push_grp Update l.l.cont
abruf_part abruf_part Check partner
rpart rpart PaytCardPlnType
aktfi aktfi Promo deter.
vbklt vbklt_va Indicator
j_1bnftype j_1bnftype NF type
incup incup Subitem Increm.
babss babssch_cm Paym.guar.proc.
empfi empfi Receiving pt determ.
delcf delcf Commitment date
ccpgr ccpga Checking group
excbc excbc Boycott list
excem excem Embargo check
exclg exclg Legal ctrl log
hnwk2 hnwk2 Ref.to AP Cont.
extnr_rma rma_extnr PO number
tdid tdid Text ID
aauart1 aauart Alt. doc. type
aauart2 aauart Alt. doc. type
rfpa_sw rfpa_sw RtSchedAct
variant tcvariant Variant
atpgm atpgm ATP group calls
verli verli Procedures
tenur tenur Backwards Only
j_1afctype j_1afctyp CM bill. cat.
faupr faupr ShInfoProfile
pvbsm pvbsm PP doc. proced.
bproc bproc Processing
ermat ermat Matl entry type
bstvo bstvo Propose CustRef Date
msr_active msr_active Adv. Returns
msr_next_number msr_get_next_number Number Determ.
msr_auara msr_auara Default CMR
msr_billing_blk msr_billing_block Billing Block
msr_cm_immediate msr_cm_immediately Automatic CM
msr_lfart msr_lfart Delivery Type
fcs_active fcs_active FTS Active
msr_delivery_blk msr_delivery_block Delivery Block
msr_sdf_auart msr_replacement_auart DocType SDF
rdp_profile logtrm_rdp_profile RDP Profile
fkart_mev_post fkart_mev_post Per.-End Posting
fkart_mev_post_ib fkart_mev_post_ib Period-End Post. ICB
fsh_vass_act fsh_vass_act VAS Active
fsh_vass_kalsm fsh_vass_kalsm Determination Proc.
fsh_vass_del fsh_vass_del VAS Del. Criteria
fsh_vass_detdt fsh_vass_detdt VAS Deter. Date
fsh_cq_check fsh_cq_check Rqmt Relevant
bewaz bewaz Cons. Goods Rec.Hrs.
itmac /sapsll/itmac Trade Compliance
pre_doc_disp pre_doc_disp DisplayPreDocum
msr_dialog_if_blocked msr_dialog_if_blocked Dialog Box DeBl
msr_grqc_lfart msr_grqc_lfart GRQC Del. Type
vbvwe vbvwe Ship.Con.Ship-to-p.
reqd_date_routine_no tdd_req_date_routine_nmbr Routine Number
flexnum_routine_no sdsls_flexnum_routine_no Flex.Doc.No. Routine
prcg_date_routine_no tdd_prcg_date_routine_nmbr Routine Number
vald_to_dte_routine_no tdd_vald_to_date_routine_nmbr Routine Number
msr_suspension_valuation msr_suspension_valuation Suspend Valuation

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.

-- Sales Document Types
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVAK (
    MANDT,                     -- Client [mandt]
    AUART,                     -- Sales Doc. Type [auart]
    KOPGR,                     -- Screen seq.grp [bifgr]
    LFARV,                     -- Delivery type [lfarv]
    FKARV,                     -- DlvBillingType [fkarv]
    FKARA,                     -- Ord-Rel.Bill.Ty [fkara]
    NUMKI,                     -- NR of Int. Asst [numki]
    NUMKE,                     -- NR of Ext. Asst [numke]
    INCPO,                     -- ItemNoIncrement [incpo]
    UEVOR,                     -- FCode OvervScrn [uevor_va]
    AUGRP,                     -- Component of the Version Number [char2]
    UMFNG,                     -- Display Range [umfng]
    DABAR,                     -- Release type [dabar]
    PARGR,                     -- PartnDet.Proc. [pargr]
    FAKSK,                     -- Billing Block [faksp]
    LIFSK,                     -- Delivery Block [lifsk]
    TRVOG,                     -- Transact.group [trvog_va]
    SPAPO,                     -- Item division [spapo]
    SPAPR,                     -- Check Division [spapr]
    VSTRM,                     -- Dlv. Scheduling [vstrm]
    TRTRM,                     -- Transport. Schd [trtrm]
    TXN08,                     -- Standard Text [txn08]
    DIAFE,                     -- Incomplet.messg [diauv]
    FELDK,                     -- Field sel.grpHd [feldk]
    DATVO,                     -- Prop.Deliv.Date [datvo_vak]
    AWAHR,                     -- Probability [awahr_ak]
    VBTYP,                     -- Document Cat. [vbtypl]
    VSBED,                     -- Shipping cond. [vsbed_vak]
    BEZOB,                     -- Reference Mand. [bezob]
    TXTGR,                     -- TextDetermProc. [txtgr]
    KALVG,                     -- DocPricingProc. [kalvg]
    ERNAM,                     -- Created By [ernam]
    FEHGR,                     -- Incompl.Proced. [fehgr]
    INFLS,                     -- Read Cust. Matl [infls]
    KUNN0,                     -- CuNo 0 allowed [kunn0]
    KLIMP,                     -- Credit limit [klimp]
    KALSM,                     -- OutputDet.Proc. [kalsmb]
    KAPPL,                     -- Application [na_kappl]
    KSCHL,                     -- Output Type [na_kschl]
    SPERR,                     -- Document Block [spevb]
    STGAK,                     -- Doc.stats.group [stgak]
    KALSU,                     -- Mat.determin. [kalsu]
    KALLI,                     -- Listing [kalli]
    KALAU,                     -- Exclusion [kalau]
    FKAIV,                     -- IntercoBillType [fkaiv]
    CMGRA,                     -- Credit group order [cmgra]
    OBJART_HIN,                -- DocType-Create [sdobjarth]
    OBJART_VER,                -- DocType-Change [sdobjartv]
    ABRVW,                     -- Usage [abrvw]
    ABDIS,                     -- MRP for DS type [abdis]
    KPRGBZ,                    -- Date type [prgrs]
    PRDATV,                    -- Prp.Pricing Dte [prdatv]
    VLAUF,                     -- Lead Time [vlauf]
    GUEBGV,                    -- PropValFromDate [guebgv]
    VTERL,                     -- Contrct allowed [vterl]
    HNWAG,                     -- Quot.Messages [hnwag]
    HNWKM,                     -- OutlineAgrMess. [hnwkm]
    STSMA,                     -- Status Profile [j_stsma]
    LISOF,                     -- Immediate dlv [lisof]
    AUARA,                     -- Subseq.ord.type [auara]
    KORLI,                     -- Corr.dlv.type [korli]
    VPROF,                     -- Contract prof. [vprof]
    AUFAK,                     -- Billing request [aufak]
    DIAPA,                     -- ProdAttrMessage [diapa]
    FPART,                     -- BillingPlanType [fpart]
    KSCHL_KO,                  -- CndTypLineItems [kschl_ko]
    EXCOK,                     -- Legal Control [excok]
    EXMOD,                     -- Time interval [exmod]
    KSKPF,                     -- PricProcCondHd [kskpf]
    KSPOS,                     -- PricProcCondIt [kspos]
    LIFSM,                     -- Delivery block [lifsm]
    FKTKT,                     -- F.activity type [fktkt]
    EXDIA,                     -- Dialog Leg.Cntl [exdia]
    ABGRU_IN,                  -- RejectionReason [abgru_in]
    PRBST,                     -- Chck CustRef [prbst]
    SCHEME_GRP,                -- Ref.procedure [scheme_grp]
    HNWGK,                     -- MastContMessage [hnwgk]
    PUSH_GRP,                  -- Update l.l.cont [push_grp]
    ABRUF_PART,                -- Check partner [abruf_part]
    RPART,                     -- PaytCardPlnType [rpart]
    AKTFI,                     -- Promo deter. [aktfi]
    VBKLT,                     -- Indicator [vbklt_va]
    J_1BNFTYPE,                -- NF type [j_1bnftype]
    INCUP,                     -- Subitem Increm. [incup]
    BABSS,                     -- Paym.guar.proc. [babssch_cm]
    EMPFI,                     -- Receiving pt determ. [empfi]
    DELCF,                     -- Commitment date [delcf]
    CCPGR,                     -- Checking group [ccpga]
    EXCBC,                     -- Boycott list [excbc]
    EXCEM,                     -- Embargo check [excem]
    EXCLG,                     -- Legal ctrl log [exclg]
    HNWK2,                     -- Ref.to AP Cont. [hnwk2]
    EXTNR_RMA,                 -- PO number [rma_extnr]
    TDID,                      -- Text ID [tdid]
    AAUART1,                   -- Alt. doc. type [aauart]
    AAUART2,                   -- Alt. doc. type [aauart]
    RFPA_SW,                   -- RtSchedAct [rfpa_sw]
    VARIANT,                   -- Variant [tcvariant]
    ATPGM,                     -- ATP group calls [atpgm]
    VERLI,                     -- Procedures [verli]
    TENUR,                     -- Backwards Only [tenur]
    J_1AFCTYPE,                -- CM bill. cat. [j_1afctyp]
    FAUPR,                     -- ShInfoProfile [faupr]
    PVBSM,                     -- PP doc. proced. [pvbsm]
    BPROC,                     -- Processing [bproc]
    ERMAT,                     -- Matl entry type [ermat]
    BSTVO,                     -- Propose CustRef Date [bstvo]
    MSR_ACTIVE,                -- Adv. Returns [msr_active]
    MSR_NEXT_NUMBER,           -- Number Determ. [msr_get_next_number]
    MSR_AUARA,                 -- Default CMR [msr_auara]
    MSR_BILLING_BLK,           -- Billing Block [msr_billing_block]
    MSR_CM_IMMEDIATE,          -- Automatic CM [msr_cm_immediately]
    MSR_LFART,                 -- Delivery Type [msr_lfart]
    FCS_ACTIVE,                -- FTS Active [fcs_active]
    MSR_DELIVERY_BLK,          -- Delivery Block [msr_delivery_block]
    MSR_SDF_AUART,             -- DocType SDF [msr_replacement_auart]
    RDP_PROFILE,               -- RDP Profile [logtrm_rdp_profile]
    FKART_MEV_POST,            -- Per.-End Posting [fkart_mev_post]
    FKART_MEV_POST_IB,         -- Period-End Post. ICB [fkart_mev_post_ib]
    FSH_VASS_ACT,              -- VAS Active [fsh_vass_act]
    FSH_VASS_KALSM,            -- Determination Proc. [fsh_vass_kalsm]
    FSH_VASS_DEL,              -- VAS Del. Criteria [fsh_vass_del]
    FSH_VASS_DETDT,            -- VAS Deter. Date [fsh_vass_detdt]
    FSH_CQ_CHECK,              -- Rqmt Relevant [fsh_cq_check]
    BEWAZ,                     -- Cons. Goods Rec.Hrs. [bewaz]
    ITMAC,                     -- Trade Compliance [/sapsll/itmac]
    PRE_DOC_DISP,              -- DisplayPreDocum [pre_doc_disp]
    MSR_DIALOG_IF_BLOCKED,     -- Dialog Box DeBl [msr_dialog_if_blocked]
    MSR_GRQC_LFART,            -- GRQC Del. Type [msr_grqc_lfart]
    VBVWE,                     -- Ship.Con.Ship-to-p. [vbvwe]
    REQD_DATE_ROUTINE_NO,      -- Routine Number [tdd_req_date_routine_nmbr]
    FLEXNUM_ROUTINE_NO,        -- Flex.Doc.No. Routine [sdsls_flexnum_routine_no]
    PRCG_DATE_ROUTINE_NO,      -- Routine Number [tdd_prcg_date_routine_nmbr]
    VALD_TO_DTE_ROUTINE_NO,    -- Routine Number [tdd_vald_to_date_routine_nmbr]
    MSR_SUSPENSION_VALUATION,  -- Suspend Valuation [msr_suspension_valuation]
    PRIMARY KEY (MANDT, AUART)
);

Learn More