TWPIV

Transparent Table Customizing Table
25 Fields 1 CDS Views

General control of aggregated sales upload POS

TWPIV is an SAP database table in S/4HANA. General control of aggregated sales upload POS. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_POSInbAggrgdSalesSettings view from BASIC Settings for Aggregated Sales in POS Inbound

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY inpro POSINTPROF Inbound Profile
finvm POSFINVMAN Inventory Mgmt
fbill POSBILLING Billing
frepl POSFREPL UpdateRepl. IM
fstat POSFSTAT RIS Update
andeb POSANDEB Anonym.Customer
lgort LGORT_D Location
bwavk POSBWAVK Mov. type: Sale
bwart POSBWART MT: return
auart POSAUART S. doc. type
pstyv POSPSTYV I.cat.standard
fkara POSFKARA Bill. Type
kalsm POSKALSM Cal. schema
kschl POSFKSCHL Condition type
kksch POSKKSCHL Cond.type Val
kpsty POSKPSTYV FI val. price
numli POSNUMLI Number of items
fxstr POSEXSTR Explode mat.
fstatbw POSFSTATBW BW Update
fstatrisbw POSFSTATRISBW RIS and BW Update
sresp POSSRESP Confirmation
send_partial_conf WPOS_PARTIAL_CONF Partial Confirmation
pos_wo_listing POS_WITHOUT_LISTING POS Inb w/o Listing
csgmt POS_CSGMT Consignment

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.

-- General control of aggregated sales upload POS
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TWPIV (
    MANDT,              -- Client [MANDT]
    INPRO,              -- Inbound Profile [POSINTPROF]
    FINVM,              -- Inventory Mgmt [POSFINVMAN]
    FBILL,              -- Billing [POSBILLING]
    FREPL,              -- UpdateRepl. IM [POSFREPL]
    FSTAT,              -- RIS Update [POSFSTAT]
    ANDEB,              -- Anonym.Customer [POSANDEB]
    LGORT,              -- Location [LGORT_D]
    BWAVK,              -- Mov. type: Sale [POSBWAVK]
    BWART,              -- MT: return [POSBWART]
    AUART,              -- S. doc. type [POSAUART]
    PSTYV,              -- I.cat.standard [POSPSTYV]
    FKARA,              -- Bill. Type [POSFKARA]
    KALSM,              -- Cal. schema [POSKALSM]
    KSCHL,              -- Condition type [POSFKSCHL]
    KKSCH,              -- Cond.type Val [POSKKSCHL]
    KPSTY,              -- FI val. price [POSKPSTYV]
    NUMLI,              -- Number of items [POSNUMLI]
    FXSTR,              -- Explode mat. [POSEXSTR]
    FSTATBW,            -- BW Update [POSFSTATBW]
    FSTATRISBW,         -- RIS and BW Update [POSFSTATRISBW]
    SRESP,              -- Confirmation [POSSRESP]
    SEND_PARTIAL_CONF,  -- Partial Confirmation [WPOS_PARTIAL_CONF]
    POS_WO_LISTING,     -- POS Inb w/o Listing [POS_WITHOUT_LISTING]
    CSGMT,              -- Consignment [POS_CSGMT]
    PRIMARY KEY (MANDT, INPRO)
);

Learn More