TWPIS

Transparent Table Customizing Table
32 Fields 1 CDS Views

POS interface: profile for internal interfaces

TWPIS is an SAP database table in S/4HANA. POS interface: profile for internal interfaces. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PointOfSaleInboundProfile view from BASIC Point of Sale Inbound Profile

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY inpro POSINTPROF Inbound Profile
fbest POSFBEST No inv. man.
ffakt POSFFAKT No bill
ffibu POSFFIBU No FI
frepl POSFREPL UpdateRepl. IM
andeb POSANDEB Anonym.Customer
cpdde POSCPDDEBI One-time cus.
auart POSAUART S. doc. type
kalsm POSKALSM Cal. schema
kschl POSFKSCHL Condition type
pstyv POSPSTYV I.cat.standard
wpsty POSWPSTYV Item cat. PayL
fkara POSFKARA Bill. Type
kauar POSKAUART Cr.sales type
kkals POSKKALSM Credit.cal.sch.
kksch POSKKSCHL Cond.type Val
kpsty POSKPSTYV FI val. price
kfkar POSKFKARA Cred.bill.type
lgort LGORT_D Location
istvk POSFLISTVK StatisticUpdate
btypv VWWSBTYPVO Doc cat. def.
deflfart VWWSDLFART Default del.typ
mefind MEFINDUNG UnitDeter.DefaultKey
warnlevel WARNLEVEL WarningLev
defba DEFBA Default DT
substnb SUBSTNB Subst.doc.type NB
substub SUBSTUB Subst.doc.type UB
fstat POSFSTAT RIS Update
gponzu GPONZU Group items
fstatbw POSFSTATBW BW Update
fstatrisbw POSFSTATRISBW RIS and BW Update

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.

-- POS interface: profile for internal interfaces
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TWPIS (
    MANDT,       -- Client [MANDT]
    INPRO,       -- Inbound Profile [POSINTPROF]
    FBEST,       -- No inv. man. [POSFBEST]
    FFAKT,       -- No bill [POSFFAKT]
    FFIBU,       -- No FI [POSFFIBU]
    FREPL,       -- UpdateRepl. IM [POSFREPL]
    ANDEB,       -- Anonym.Customer [POSANDEB]
    CPDDE,       -- One-time cus. [POSCPDDEBI]
    AUART,       -- S. doc. type [POSAUART]
    KALSM,       -- Cal. schema [POSKALSM]
    KSCHL,       -- Condition type [POSFKSCHL]
    PSTYV,       -- I.cat.standard [POSPSTYV]
    WPSTY,       -- Item cat. PayL [POSWPSTYV]
    FKARA,       -- Bill. Type [POSFKARA]
    KAUAR,       -- Cr.sales type [POSKAUART]
    KKALS,       -- Credit.cal.sch. [POSKKALSM]
    KKSCH,       -- Cond.type Val [POSKKSCHL]
    KPSTY,       -- FI val. price [POSKPSTYV]
    KFKAR,       -- Cred.bill.type [POSKFKARA]
    LGORT,       -- Location [LGORT_D]
    ISTVK,       -- StatisticUpdate [POSFLISTVK]
    BTYPV,       -- Doc cat. def. [VWWSBTYPVO]
    DEFLFART,    -- Default del.typ [VWWSDLFART]
    MEFIND,      -- UnitDeter.DefaultKey [MEFINDUNG]
    WARNLEVEL,   -- WarningLev [WARNLEVEL]
    DEFBA,       -- Default DT [DEFBA]
    SUBSTNB,     -- Subst.doc.type NB [SUBSTNB]
    SUBSTUB,     -- Subst.doc.type UB [SUBSTUB]
    FSTAT,       -- RIS Update [POSFSTAT]
    GPONZU,      -- Group items [GPONZU]
    FSTATBW,     -- BW Update [POSFSTATBW]
    FSTATRISBW,  -- RIS and BW Update [POSFSTATRISBW]
    PRIMARY KEY (MANDT, INPRO)
);

Learn More