REFXCN_SALES

Sales Data | #masterdata | Component: Real Estate Localization China
Column Name Description
MANDT Client
GUID GUID for inbound data
Column Name Description
πŸ’² Currency for Contract (WAERS):
UMSWERT Net Value in Document Currency
Column Name Description
πŸ“ Base Unit of Measure (UNIT):
UMSMENGE Scale Quantity in base unit of measure
Column Name Description
DOCDATE Sales date for idoc
PROCESS_DATE Process Date
PROCESS_TIME Process Time
Column Name Description
VORZMENGE Plus and minus sign Show values
PROCESSED Proessed or not ( X = Processed ) Show values
Column Name Description Domain name
DOCNUM IDOC Number CHAR16
SNDPRN Store ID CHAR10
PACKAGE_ID Trade Type CHAR32
QUALARTNR Commodity Type Identification CHAR4
ARTNR Material Number MATNR
AKTIONSNR Promotion Code CHAR15
CONDID20 Counter ID for Real Estate POS integration CHAR6
BBYNR Promotion Type CHAR6
UPD_TMSTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Currency for Contract
  • REFXCN_SALES.MANDT == TCURC.MANDT
  • REFXCN_SALES.WAERS == TCURC.WAERS