1. Home
  2. Resources
  3. SAP Tables
  4. TWPIS - POS interface: profile for internal interfaces

SAP Table TWPIS

POS interface: profile for internal interfaces

TWPIS (POS interface: profile for internal interfaces) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TWPIS to other SAP tables.

TWPIS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
INPRO POS inbound profile POSINTPROF CHAR 4 0
FBEST Flag: no inventory management POSFBEST CHAR 1 0
NULL Function inactive
X Function active
FFAKT Flag: no billing POSFFAKT CHAR 1 0
NULL Function inactive
X Function active
FFIBU Flag: no FI postings POSFFIBU CHAR 1 0
NULL Function inactive
X Function active
FREPL Update replenishment-based Inventory Management POSFREPL CHAR 1 0
NULL No Replenishment-Based Inventory Management
X Integrated Replenishment-Based Inventory Management
1 Special Replenishment-Based Inventory Management
ANDEB Anonymous Customer POSANDEB KNA1 CHAR 10 0
CPDDE One-time customer POSCPDDEBI KNA1 CHAR 10 0
AUART Sales order type POSAUART TVAK CHAR 4 0
KALSM Calculation schema POSKALSM T683 CHAR 6 0
KSCHL Condition type, sales price POSFKSCHL T685 CHAR 4 0
PSTYV Item category POSPSTYV TVPT CHAR 4 0
WPSTY Item category, payment list POSWPSTYV TVPT CHAR 4 0
FKARA Billing Type POSFKARA TVFK CHAR 4 0
KAUAR Cred. sale: order type POSKAUART TVAK CHAR 4 0
KKALS Credit. sale: calculation schema POSKKALSM T683 CHAR 6 0
KKSCH Condition type SP valuation price POSKKSCHL T685 CHAR 4 0
KPSTY Cond. type FI valuation price POSKPSTYV T685 CHAR 4 0
KFKAR Credit.sale: billing type POSKFKARA TVFK CHAR 4 0
LGORT Storage Location LGORT_D CHAR 4 0
ISTVK Flag: update statistics POSFLISTVK CHAR 1 0
X true
- false
NULL unknown
BTYPV Default doc. category, store order inbound - replenishment VWWSBTYPVO CHAR 1 0
NULL Create PO, otherwise error will occur
1 Create purchase requisition, otherwise error will occur
2 Create PO, if error occurs create PReq., otherwise error
3 Pur. Order
4 Delivery
7 Sales order
8 PO copy (no message to external vendor)
A Warehouse order if stock exists, otherwise third-party order
B Warehouse order, but third-party order for large qties
C Stock on-hand, if avail.; otherwise other DC; otherw. direct
DEFLFART Default delivery type VWWSDLFART CHAR 4 0
MEFIND Default value key for unit determination MEFINDUNG CHAR 1 0
NULL Missing unit of measure filled with order unit
0 Missing unit of measure filled with base unit of measure
2 Missing unit of measure will lead to errors
WARNLEVEL Store order warning level WARNLEVEL CHAR 1 0
2 Log all errors
3 Log all errors and warnings
4 Log all errors, warnings and notes
DEFBA Store order: default order document type DEFBA CHAR 2 0
NB Corresponds to standard PO in MM Purchasing
UB Corresponds to stock transfer order in MM Purchasing
SUBSTNB Store order substitute for doc. type NB SUBSTNB CHAR 4 0
SUBSTUB Store order substitute for doc. type UB SUBSTUB CHAR 4 0
FSTAT Flag: RIS Statistics Update POSFSTAT CHAR 1 0
NULL Function inactive
X Function active
GPONZU Indicator: group same store order items GPONZU CHAR 1 0
X Yes
NULL No
FSTATBW Flag: BW Statistics Update POSFSTATBW CHAR 1 0
NULL Function inactive
X Function active
FSTATRISBW Flag: RIS and BW Statistics Update POSFSTATRISBW CHAR 1 0
NULL Function inactive
X Function active

TWPIS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TWPIS ANDEB TWPIS MANDT KNA1 General Data in Customer Master MANDT
TWPIS ANDEB TWPIS ANDEB KNA1 General Data in Customer Master KUNNR
TWPIS AUART TWPIS MANDT TVAK Sales Document Types MANDT
TWPIS AUART TWPIS AUART TVAK Sales Document Types AUART
TWPIS CPDDE TWPIS MANDT KNA1 General Data in Customer Master MANDT
TWPIS CPDDE TWPIS CPDDE KNA1 General Data in Customer Master KUNNR
TWPIS FKARA TWPIS MANDT TVFK Billing: Document Types MANDT
TWPIS FKARA TWPIS FKARA TVFK Billing: Document Types FKART
TWPIS KALSM 'V' T683 Pricing procedures KAPPL
TWPIS KALSM TWPIS KALSM T683 Pricing procedures KALSM
TWPIS KALSM T001 MANDT T683 Pricing procedures MANDT
TWPIS KALSM 'A' T683 Pricing procedures KVEWE
TWPIS KAUAR TWPIS KAUAR TVAK Sales Document Types AUART
TWPIS KAUAR TWPIS MANDT TVAK Sales Document Types MANDT
TWPIS KFKAR TWPIS MANDT TVFK Billing: Document Types MANDT
TWPIS KFKAR TWPIS KFKAR TVFK Billing: Document Types FKART
TWPIS KKALS TWPIS KKALS T683 Pricing procedures KALSM
TWPIS KKALS T001 MANDT T683 Pricing procedures MANDT
TWPIS KKALS 'A' T683 Pricing procedures KVEWE
TWPIS KKALS 'V' T683 Pricing procedures KAPPL
TWPIS KKSCH T001 MANDT T685 Conditions: Types MANDT
TWPIS KKSCH 'A' T685 Conditions: Types KVEWE
TWPIS KKSCH 'V' T685 Conditions: Types KAPPL
TWPIS KKSCH TWPIS KKSCH T685 Conditions: Types KSCHL
TWPIS KPSTY 'A' T685 Conditions: Types KVEWE
TWPIS KPSTY 'V' T685 Conditions: Types KAPPL
TWPIS KPSTY TWPIS KPSTY T685 Conditions: Types KSCHL
TWPIS KPSTY TWPIS MANDT T685 Conditions: Types MANDT
TWPIS KSCHL 'V' T685 Conditions: Types KAPPL
TWPIS KSCHL TWPIS KSCHL T685 Conditions: Types KSCHL
TWPIS KSCHL T001 MANDT T685 Conditions: Types MANDT
TWPIS KSCHL 'A' T685 Conditions: Types KVEWE
TWPIS MANDT TWPIS MANDT T000 Clients MANDT
TWPIS PSTYV TWPIS PSTYV TVPT Sales documents: Item categories PSTYV
TWPIS PSTYV TWPIS MANDT TVPT Sales documents: Item categories MANDT
TWPIS WPSTY TWPIS MANDT TVPT Sales documents: Item categories MANDT
TWPIS WPSTY TWPIS WPSTY TVPT Sales documents: Item categories PSTYV