TWPIR

Transparent Table Customizing Table
24 Fields 1 CDS Views

General control of upload of sales as per receipts POS

TWPIR is an SAP database table in S/4HANA. General control of upload of sales as per receipts POS. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_POSInbSlsAsPerRcptsSettings view from BASIC Settings for Sales as per Receipts in POS Inbound

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY inpro POSINTPROF Inbound Profile
finvm POSFINVMN2 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
numtr POSNUMTR No. of receipts
fxstr POSEXSTR Explode mat.
fstatbw POSFSTATBW BW Update
fstatrisbw POSFSTATRISBW RIS and BW Update
sresp POSSRESP 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 upload of sales as per receipts POS
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TWPIR (
    MANDT,           -- Client [MANDT]
    INPRO,           -- Inbound Profile [POSINTPROF]
    FINVM,           -- Inventory mgmt [POSFINVMN2]
    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]
    NUMTR,           -- No. of receipts [POSNUMTR]
    FXSTR,           -- Explode mat. [POSEXSTR]
    FSTATBW,         -- BW Update [POSFSTATBW]
    FSTATRISBW,      -- RIS and BW Update [POSFSTATRISBW]
    SRESP,           -- Confirmation [POSSRESP]
    POS_WO_LISTING,  -- POS Inb w/o Listing [POS_WITHOUT_LISTING]
    CSGMT,           -- Consignment [POS_CSGMT]
    PRIMARY KEY (MANDT, INPRO)
);

Learn More