SAP ABAP Table TWPIR (General control of upload of sales as per receipts POS)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WPOS (Package) IS-R: POS interface

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TWPIR	Table Relationship Diagram
Short Description	General control of upload of sales as per receipts POS

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	INPRO	☑	POSINTPROF	POSINTPROF	CHAR	4	0	POS inbound profile	TWPIS
3	FINVM	☐	POSFINVMN2	POSFLAG	CHAR	1	0	Flag: Inventory Management
4	FBILL	☐	POSBILLING	POSBILLC	CHAR	1	0	Flag: billing
5	FREPL	☐	POSFREPL	POSFREPL	CHAR	1	0	Update replenishment-based Inventory Management
6	FSTAT	☐	POSFSTAT	POSFLAG	CHAR	1	0	Flag: RIS Statistics Update
7	ANDEB	☐	POSANDEB	KUNNR	CHAR	10	0	Anonymous Customer	KNA1
8	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
9	BWAVK	☐	POSBWAVK	BWART	CHAR	3	0	Movement type: Sale	T156
10	BWART	☐	POSBWART	BWART	CHAR	3	0	Movement type: return	T156
11	AUART	☐	POSAUART	AUART	CHAR	4	0	Sales order type	TVAK
12	PSTYV	☐	POSPSTYV	PSTYV	CHAR	4	0	Item category	*
13	FKARA	☐	POSFKARA	FKART	CHAR	4	0	Billing Type	TVFK
14	KALSM	☐	POSKALSM	KALSM	CHAR	6	0	Calculation schema	T683
15	KSCHL	☐	POSFKSCHL	KSCHL	CHAR	4	0	Condition type, sales price	T685
16	KKSCH	☐	POSKKSCHL	KSCHL	CHAR	4	0	Condition type SP valuation price	T685
17	KPSTY	☐	POSKPSTYV	KSCHL	CHAR	4	0	Cond. type FI valuation price	T685
18	NUMTR	☐	POSNUMTR	INT4	INT4	10	0	No.receipts to be aggregated
19	FXSTR	☐	POSEXSTR	POSFLAG	CHAR	1	0	Explode material
20	FSTATBW	☐	POSFSTATBW	POSFLAG	CHAR	1	0	Flag: BW Statistics Update
21	FSTATRISBW	☐	POSFSTATRISBW	POSFLAG	CHAR	1	0	Flag: RIS and BW Statistics Update
22	.INCLU--AP	☐				0	0	Append Consignment to Table TWPIR
23	CSGMT	☐	POS_CSGMT	XFELD	CHAR	1	0	Flag: Consignment Processing

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TWPIR	ANDEB	KNA1	KUNNR	KEY	1	CN
2	TWPIR	AUART	TVAK	AUART	KEY	1	CN
3	TWPIR	BWART	T156	BWART		1	CN
4	TWPIR	BWAVK	T156	BWART		1	CN
5	TWPIR	FKARA	TVFK	FKART	KEY	1	CN
6	TWPIR	INPRO	TWPIS	INPRO	KEY	1	CN
7	TWPIR	KALSM	T683	KALSM	KEY	1	CN
8	TWPIR	KKSCH	T685	KSCHL	KEY	1	CN
9	TWPIR	KPSTY	T685	KSCHL	KEY	1	CN
10	TWPIR	KSCHL	T685	KSCHL	KEY	1	CN
11	TWPIR	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20100310
SAP Release Created in