REFXCN_SALES - Sales Data
Sales Data information is stored in SAP table REFXCN_SALES.
It is part of development package GLO_REFX_POS2_CN_DDIC in software component RE-FX-LC-CN. This development package consists of objects that can be grouped under "Real Estate POS Integration for China enhanced - DDIC".
It is part of development package GLO_REFX_POS2_CN_DDIC in software component RE-FX-LC-CN. This development package consists of objects that can be grouped under "Real Estate POS Integration for China enhanced - DDIC".
Fields for table REFXCN_SALES
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| GUID | GUID for inbound data | X | REFXCN_GUID | CHAR | 64 | |
| DOCNUM | IDOC Number | REFXCN_DOCNUM | CHAR | 32 | ||
| SNDPRN | Store ID | REFXCN_SNDPRN | CHAR | 20 | ||
| DOCDATE | Sales date for idoc | REFXCN_SALEDATE | DATS | 16 | ||
| PACKAGE_ID | Trade Type | REFXCN_TRADETYPE | CHAR | 64 | ||
| QUALARTNR | Commodity Type Identification | REFXCN_QUALARTNR | CHAR | 8 | ||
| ARTNR | Material Number | MATNR | CHAR | 80 | ||
| VORZMENGE | Plus and minus sign | PLUSM | CHAR | 2 | ||
| UMSMENGE | Scale Quantity in base unit of measure | SMENG | QUAN | 7 | ||
| UNIT | Base Unit of Measure | MEINS | UNIT | 6 | ||
| UMSWERT | Net Value in Document Currency | NETWR | CURR | 8 | ||
| WAERS | Currency for Contract | RECNWAERS_CN | CUKY | 10 | TCURC | |
| AKTIONSNR | Promotion Code | REFXCN_AKTIONSNR | CHAR | 30 | ||
| CONDID20 | Counter ID for Real Estate POS integration | REFXCN_COUNTER | CHAR | 12 | ||
| BBYNR | Promotion Type | REFXCN_PROMTYPE | CHAR | 12 | ||
| UPD_TMSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
| PROCESSED | Proessed or not ( X = Processed ) | REFXCN_PRCSS | CHAR | 2 | ||
| PROCESS_DATE | Process Date | REFXCN_DATE | DATS | 16 | ||
| PROCESS_TIME | Process Time | REFXCN_TIME | TIMS | 12 |