1. Home
  2. Resources
  3. SAP Tables
  4. TWPIV - General control of aggregated sales upload POS

SAP Table TWPIV

General control of aggregated sales upload POS

TWPIV (General control of aggregated sales upload POS) 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 TWPIV to other SAP tables.

TWPIV table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
INPRO POS inbound profile POSINTPROF TWPIS CHAR 4 0
FINVM Flag: Inventory Management POSFINVMAN CHAR 1 0
NULL No inventory management
X Inventory management without aggregation
1 Inventory management aggregated at value-only material level
FBILL Flag: billing POSBILLING CHAR 1 0
NULL No billing
X Billing, with billing document saved
1 Billing, with billing document not saved
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
FSTAT Flag: RIS Statistics Update POSFSTAT CHAR 1 0
NULL Function inactive
X Function active
ANDEB Anonymous Customer POSANDEB KNA1 CHAR 10 0
LGORT Storage Location LGORT_D CHAR 4 0
BWAVK Movement type: Sale POSBWAVK T156 CHAR 3 0
BWART Movement type: return POSBWART T156 CHAR 3 0
AUART Sales order type POSAUART TVAK CHAR 4 0
PSTYV Item category POSPSTYV TVPT CHAR 4 0
FKARA Billing Type POSFKARA TVFK CHAR 4 0
KALSM Calculation schema POSKALSM T683 CHAR 6 0
KSCHL Condition type, sales price POSFKSCHL T685 CHAR 4 0
KKSCH Condition type SP valuation price POSKKSCHL T685 CHAR 4 0
KPSTY Cond. type FI valuation price POSKPSTYV T685 CHAR 4 0
NUMLI Number of items per document POSNUMLI INT4 10 0
FXSTR Explode material POSEXSTR CHAR 1 0
NULL Function inactive
X Function active
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
SRESP Send Confirmation POSSRESP CHAR 1 0
NULL Function inactive
X Function active
CSGMT Flag: Consignment Processing POS_CSGMT CHAR 1 0
X Yes
NULL No

TWPIV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TWPIV ANDEB TWPIV MANDT KNA1 General Data in Customer Master MANDT
TWPIV ANDEB TWPIV ANDEB KNA1 General Data in Customer Master KUNNR
TWPIV AUART TWPIV AUART TVAK Sales Document Types AUART
TWPIV AUART TWPIV MANDT TVAK Sales Document Types MANDT
TWPIV BWART TWPIV MANDT T156 Movement Type MANDT
TWPIV BWART TWPIV BWART T156 Movement Type BWART
TWPIV BWAVK TWPIV MANDT T156 Movement Type MANDT
TWPIV BWAVK TWPIV BWAVK T156 Movement Type BWART
TWPIV FKARA TWPIV MANDT TVFK Billing: Document Types MANDT
TWPIV FKARA TWPIV FKARA TVFK Billing: Document Types FKART
TWPIV INPRO TWPIV INPRO TWPIS POS interface: profile for internal interfaces INPRO
TWPIV INPRO TWPIV MANDT TWPIS POS interface: profile for internal interfaces MANDT
TWPIV KALSM 'A' T683 Pricing procedures KVEWE
TWPIV KALSM 'V' T683 Pricing procedures KAPPL
TWPIV KALSM TWPIV KALSM T683 Pricing procedures KALSM
TWPIV KALSM TWPIV MANDT T683 Pricing procedures MANDT
TWPIV KKSCH TWPIV KKSCH T685 Conditions: Types KSCHL
TWPIV KKSCH TWPIV MANDT T685 Conditions: Types MANDT
TWPIV KKSCH 'A' T685 Conditions: Types KVEWE
TWPIV KKSCH 'V' T685 Conditions: Types KAPPL
TWPIV KPSTY TWPIV MANDT T685 Conditions: Types MANDT
TWPIV KPSTY 'A' T685 Conditions: Types KVEWE
TWPIV KPSTY 'V' T685 Conditions: Types KAPPL
TWPIV KPSTY TWPIV KPSTY T685 Conditions: Types KSCHL
TWPIV KSCHL TWPIV MANDT T685 Conditions: Types MANDT
TWPIV KSCHL 'A' T685 Conditions: Types KVEWE
TWPIV KSCHL 'V' T685 Conditions: Types KAPPL
TWPIV KSCHL TWPIV KSCHL T685 Conditions: Types KSCHL
TWPIV MANDT TWPIV MANDT T000 Clients MANDT
TWPIV PSTYV TWPIV MANDT TVPT Sales documents: Item categories MANDT
TWPIV PSTYV TWPIV PSTYV TVPT Sales documents: Item categories PSTYV