TVAP

Transparent Table Customizing (protected)
86 Fields 2 CDS Views

Sales Document: Item Categories

TVAP is an SAP database table in S/4HANA. Sales Document: Item Categories. It contains 86 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
CIC_CustomerOrderItemTypeCode view_entity from Customer Order Item Type Code
I_SalesDocumentItemCategory view from BASIC Sales Document Item Category

Fields (86)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pstyv PSTYV Item Category
fkrel FKREL Relev.for Bill.
prsfd PRSFD Pricing Relev.
posgr BIFGR Screen seq.grp
pargr PARGR PartnDet.Proc.
psgrp CAPID BOM Application
stuli STULI Material struct
aswpa ASWPA Alternat. manually
strum STRUM Struct. scope
propagate_paobjnr_bom SD_SLS_PROPAGATE_PAOBJNR_BOM Propagate Prof. Sgmt
evrwr EVRWR Determine cost
kowrr KOWRR Stat. Value
feldp FELDP Field sel.item
faksp FAKSP Billing Block
shell SHELL BOM display
erlre ERLRE Completion Rule
txn08 TXN08 Standard Text
diafm DIAFM Dialog shrt qty
kderl KDERL Bus.data - item
txtgr TXTGR TextDetermProc.
posar POSAR Item Type
lfrel LFREL_AP Item Del.f.Dlv.
ernam ERNAM Created By
eterl ETERL SchedLinesAllwd
gwrel GWREL Relev.wgt/vol.
kompp KOMPP Check component
fehgr FEHGR Incompl.Proced.
shkzg SHKZG_VA Returns
eqmat EQMAT Mat.block
stgap STGAP ItmCatStatGroup
kalsm KALSMBP OutputDetrmProc
sobkz SOBKZ Special Stock
cmpnt CMPNT Credit Active
strat STRATCON Proc.strategy
stsma J_STSMA Status Profile
meng1 MENG1 Order qty = 1
alekz ALEKZ PurchOrder
fpart FPART BillingPlanType
chaut CHAUT AutoBatchDeterm
excop EXCOP Legal Control
svgng SVGNG ActivCat TObj
typfd TYPFD Variant matching
ltypa LTYPA Matl variant action
ltypv LTYPV ATP material variant
wkmat WKMAT Value contract matl
rktio RKTIO Response
segal SEGAL Excl./Incl.
stdte STDTE BOM config.date
rderl RDERL Roundng permitd
effec EFFEC Param. effect.
ffprf AD01PROFNR DIP Profile
scheme_rma RMA_SCHEMA Procedure
scheme_vf VF_SCHEMA Procedure
faktf FAKTF Billing form
rrrel RR_RELTYP Rev. Recognition
acdatv RR_ACDATV Acc. Period Start
uveib UVEIB DocPricingProc.
oibom OIB_BOM Oil BOM
oibcst OIB_CST Cost summation
oiuserexit GRPNO Routine Number
revsp RR_REVSP Revenue Dist.
revevtyp RR_REVEVTYP_CUST Revenue Event
mill_batch_ref MILL_BATCH_REF Ret.w.BatchRef
mill_batch_sel_d MILL_BATCH_SEL_DEF Def.Batch SelInd.
rbacontrol RBACONTROL RBA Control
fsh_seadet FSH_SEADET Season Det.
fsh_vass_detc FSH_VASS_DETC VAS Determin. Mode
fsh_autodeloc FSH_AUTODELOC Auto Deallocation
enh_rej_logic ENHANCED_REJECTION_LOGIC Enh. Rejection Logic
auto_rejection AUTO_SO_ITEM_REJECTION_FROM_PO Auto Reject SO Item
reason_for_rej ABGRU_VA RejectionReason
update_so_on_conf_po UPDATE_SO_ON_CONF_PO Upd Only ConfPO
spdipo SPDIPO Ttl Qty in Del.Stat.
spdtp SPDTP Ttl Qty Billing St.
auto_dealloc ARUN_AUTO_DEALLOC Unassign Auto.
lvart LVART BOS type
mill_se_kknmt MILL_SE_KKNMT Ind: Charac. trnsfr
rfm_copy_so_po RFM_COPY_SO_PO Copy item details
rfm_div_canc RFM_DIV_CANC Cancellation
rfm_del_seas_canc RFM_DEL_SEAS_CANC Delete Season
rfm_div_qty_reduce RFM_DIV_QTY_REDUCE Quantity reduction
rfm_create_poitm_canc RFM_CREATE_POITM_CANC Create PO Item
rfm_psst_rule_deact RFM_PSST_DEACT_PSTYV Deactivate PSST Flag
rfm_copy_sea RFM_COPY_SEA Copy Season
rfm_no_copy_sea RFM_NO_COPY_SEA Do not copy seasons

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: Item Categories
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVAP (
    MANDT,                  -- Client [MANDT]
    PSTYV,                  -- Item Category [PSTYV]
    FKREL,                  -- Relev.for Bill. [FKREL]
    PRSFD,                  -- Pricing Relev. [PRSFD]
    POSGR,                  -- Screen seq.grp [BIFGR]
    PARGR,                  -- PartnDet.Proc. [PARGR]
    PSGRP,                  -- BOM Application [CAPID]
    STULI,                  -- Material struct [STULI]
    ASWPA,                  -- Alternat. manually [ASWPA]
    STRUM,                  -- Struct. scope [STRUM]
    PROPAGATE_PAOBJNR_BOM,  -- Propagate Prof. Sgmt [SD_SLS_PROPAGATE_PAOBJNR_BOM]
    EVRWR,                  -- Determine cost [EVRWR]
    KOWRR,                  -- Stat. Value [KOWRR]
    FELDP,                  -- Field sel.item [FELDP]
    FAKSP,                  -- Billing Block [FAKSP]
    SHELL,                  -- BOM display [SHELL]
    ERLRE,                  -- Completion Rule [ERLRE]
    TXN08,                  -- Standard Text [TXN08]
    DIAFM,                  -- Dialog shrt qty [DIAFM]
    KDERL,                  -- Bus.data - item [KDERL]
    TXTGR,                  -- TextDetermProc. [TXTGR]
    POSAR,                  -- Item Type [POSAR]
    LFREL,                  -- Item Del.f.Dlv. [LFREL_AP]
    ERNAM,                  -- Created By [ERNAM]
    ETERL,                  -- SchedLinesAllwd [ETERL]
    GWREL,                  -- Relev.wgt/vol. [GWREL]
    KOMPP,                  -- Check component [KOMPP]
    FEHGR,                  -- Incompl.Proced. [FEHGR]
    SHKZG,                  -- Returns [SHKZG_VA]
    EQMAT,                  -- Mat.block [EQMAT]
    STGAP,                  -- ItmCatStatGroup [STGAP]
    KALSM,                  -- OutputDetrmProc [KALSMBP]
    SOBKZ,                  -- Special Stock [SOBKZ]
    CMPNT,                  -- Credit Active [CMPNT]
    STRAT,                  -- Proc.strategy [STRATCON]
    STSMA,                  -- Status Profile [J_STSMA]
    MENG1,                  -- Order qty = 1 [MENG1]
    ALEKZ,                  -- PurchOrder [ALEKZ]
    FPART,                  -- BillingPlanType [FPART]
    CHAUT,                  -- AutoBatchDeterm [CHAUT]
    EXCOP,                  -- Legal Control [EXCOP]
    SVGNG,                  -- ActivCat TObj [SVGNG]
    TYPFD,                  -- Variant matching [TYPFD]
    LTYPA,                  -- Matl variant action [LTYPA]
    LTYPV,                  -- ATP material variant [LTYPV]
    WKMAT,                  -- Value contract matl [WKMAT]
    RKTIO,                  -- Response [RKTIO]
    SEGAL,                  -- Excl./Incl. [SEGAL]
    STDTE,                  -- BOM config.date [STDTE]
    RDERL,                  -- Roundng permitd [RDERL]
    EFFEC,                  -- Param. effect. [EFFEC]
    FFPRF,                  -- DIP Profile [AD01PROFNR]
    SCHEME_RMA,             -- Procedure [RMA_SCHEMA]
    SCHEME_VF,              -- Procedure [VF_SCHEMA]
    FAKTF,                  -- Billing form [FAKTF]
    RRREL,                  -- Rev. Recognition [RR_RELTYP]
    ACDATV,                 -- Acc. Period Start [RR_ACDATV]
    UVEIB,                  -- DocPricingProc. [UVEIB]
    OIBOM,                  -- Oil BOM [OIB_BOM]
    OIBCST,                 -- Cost summation [OIB_CST]
    OIUSEREXIT,             -- Routine Number [GRPNO]
    REVSP,                  -- Revenue Dist. [RR_REVSP]
    REVEVTYP,               -- Revenue Event [RR_REVEVTYP_CUST]
    MILL_BATCH_REF,         -- Ret.w.BatchRef [MILL_BATCH_REF]
    MILL_BATCH_SEL_D,       -- Def.Batch SelInd. [MILL_BATCH_SEL_DEF]
    RBACONTROL,             -- RBA Control [RBACONTROL]
    FSH_SEADET,             -- Season Det. [FSH_SEADET]
    FSH_VASS_DETC,          -- VAS Determin. Mode [FSH_VASS_DETC]
    FSH_AUTODELOC,          -- Auto Deallocation [FSH_AUTODELOC]
    ENH_REJ_LOGIC,          -- Enh. Rejection Logic [ENHANCED_REJECTION_LOGIC]
    AUTO_REJECTION,         -- Auto Reject SO Item [AUTO_SO_ITEM_REJECTION_FROM_PO]
    REASON_FOR_REJ,         -- RejectionReason [ABGRU_VA]
    UPDATE_SO_ON_CONF_PO,   -- Upd Only ConfPO [UPDATE_SO_ON_CONF_PO]
    SPDIPO,                 -- Ttl Qty in Del.Stat. [SPDIPO]
    SPDTP,                  -- Ttl Qty Billing St. [SPDTP]
    AUTO_DEALLOC,           -- Unassign Auto. [ARUN_AUTO_DEALLOC]
    LVART,                  -- BOS type [LVART]
    MILL_SE_KKNMT,          -- Ind: Charac. trnsfr [MILL_SE_KKNMT]
    RFM_COPY_SO_PO,         -- Copy item details [RFM_COPY_SO_PO]
    RFM_DIV_CANC,           -- Cancellation [RFM_DIV_CANC]
    RFM_DEL_SEAS_CANC,      -- Delete Season [RFM_DEL_SEAS_CANC]
    RFM_DIV_QTY_REDUCE,     -- Quantity reduction [RFM_DIV_QTY_REDUCE]
    RFM_CREATE_POITM_CANC,  -- Create PO Item [RFM_CREATE_POITM_CANC]
    RFM_PSST_RULE_DEACT,    -- Deactivate PSST Flag [RFM_PSST_DEACT_PSTYV]
    RFM_COPY_SEA,           -- Copy Season [RFM_COPY_SEA]
    RFM_NO_COPY_SEA,        -- Do not copy seasons [RFM_NO_COPY_SEA]
    PRIMARY KEY (MANDT, PSTYV)
);

Learn More