Field
Type
Length
Data element
Description
GIFT_RECIPIENT
CHAR
000001
IS-M: BP Authorized to Receive Gifts
EMPLOYEE
CHAR
000001
IS-M: Employee Indicator
NO_ADVERTISING
CHAR
000001
IS-M: No Advertising
ASSOCIATION
CHAR
000001
IS-M: Association Indicator
INTERNAL_PARTNER
CHAR
000001
IS-M: Internal Business Partner Indicator
SOCIAL_FACILITY
CHAR
000001
IS-M: Social Facility Indicator
OWNED_BY_PUBLISHER
CHAR
000001
IS-M: Indicator: Owned By Publisher
PUBLISHER_SALESORG
CHAR
000004
IS-M: Publisher's Sales Organization
ADVERTISER
CHAR
000001
IS-M: Selection Indicator for Advertiser
AGENCY
CHAR
000001
IS-M: Agency Indicator
CREATIVE_AGENCY
CHAR
000001
IS-M: Creative Boutique Indicator
DISTRIBUTION_AGENCY
CHAR
000001
IS-M: Distribution Agency Indicator
PLANNING_AGENCY
CHAR
000001
IS-M: Planning Agency Indicator
AGENCY_TYPE
CHAR
000001
IS-M: Agency Type
CREDIT_STANDING_QUERY
CHAR
000001
IS-M: Credit Query Indicator
CREDITWORTHINESS
CHAR
000002
IS-M: Creditworthiness Indicator
SOCIAL_INSURANCE_NUMBER
CHAR
000020
Social Insurance Number
CUSTOMER_SALES
TTYP
000000
SALES_REGION
CHAR
000050
IS-M: Sales Region
SALES_REGION_POPULATION
NUMC
000010
IS-M: Population of Sales Area
RETAIL_EMPLOYEE_NUMBER
NUMC
000005
IS-M: Number of Retail Employees
EHASTRA_POINT_OF_SALE_TYPE
CHAR
000002
IS-M: Point of Sale Category
EHASTRA_POINT_OF_SALE_TEXT
CHAR
000004
POS Type
EHASTRA_SALES_AREA
CHAR
000002
IS-M: POS Area Key
EHASTRA_SALES_INFLUENCE
CHAR
000002
External Sales Influence at POS (Primary)
EHASTRA_SERVICE_TYPE
CHAR
000001
Service Type at Point of Sale
EHASTRA_CUST_FREQ_PER_WEEK
CHAR
000001
IS-M: POS Customer Frequency per Week
EHASTRA_SHOP_OPENING_TIME
CHAR
000001
IS-M: Point of Sale Opening Time
EHASTRA_SHOP_CLOSING_TIME
CHAR
000001
IS-M: POS Closing Time
MBR_FORECAST_SYSTEM
CHAR
000002
IS-M: Automatic Payment System
BAG_TRANSACTION_NUMBER
CHAR
000005
IS-M: BAG Transaction Number
ISPC_NUMBER
CHAR
000010
IS-M: ISPC Number
VDZ_NUMBER
CHAR
000020
IS-M: VDZ Number
LOTTERY_AGENT
CHAR
000001
IS-M: Lottery Agent Indicator
OPENING_TYPE_MONDAY
CHAR
000001
IS-M: Opening Type Monday
OPENING_TYPE_TUESDAY
CHAR
000001
IS-M: Opening Type Tuesday
OPENING_TYPE_WEDNESDAY
CHAR
000001
IS-M: Opening Type Wednesday
OPENING_TYPE_THURSDAY
CHAR
000001
IS-M: Opening Type Thursday
OPENING_TYPE_FRIDAY
CHAR
000001
IS-M: Opening Type Friday
OPENING_TYPE_SATURDAY
CHAR
000001
IS-M: Opening Type Saturday
OPENING_TYPE_SUNDAY
CHAR
000001
IS-M: Opening Type Sunday
RIGHT_OF_RETURN
CHAR
000001
IS-M: Right of Return
RETURN_TYPE
CHAR
000001
Return Type
RETURN_METHOD
CHAR
000001
Return Method
BILLING_BLOCK_FOR_RETURN_NOTIF
CHAR
000001
IS-M: Billing Block for Return Notification
EDI_PARTICIPANT
CHAR
000001
IS-M: Indicator: Business Partner Is EDI Participant
EDI_PARTICIPANT_NUMBER
NUMC
000008
IS-M: EDI Participant Number
EDI_PARTICIPANT_TYPE
NUMC
000001
IS-M: EDI Participant Type
RETAILER_COMMENT
CHAR
000050
IS-M: Comment 50 Characters in Length
RETURN_RETAILER
CHAR
000010
IS-M: Retailer
NUMBER_POSTERS
INT2
000005
Number of Advertising Spaces at Point of Sale
PLANNING_CALENDER
CHAR
000002
Planning Calendar for Point of Sale
POS_SEASON
CHAR
000002
Season Indicator
POS_CHAINCODE
CHAR
000010
Retail Chain to Which POS Belongs
POS_CHAINCHANNEL
CHAR
000010
Distribution Channel of Retail Chain to Which POS Belongs
POS_CHAINID
CHAR
000010
ID of POS in Retail Chain
POS_SHOPINSHOP
CHAR
000001
IS-M: Shop in Shop Indicator
POS_SALES_AREA
CHAR
000002
POS Shelf Space - Shop-in-Shop
POS_SHOP_CATEGORY
CHAR
000004
Category of Main Business (Shop-in-Shop)
GEO_CATEGORY
CHAR
000002
Geography Category (Geographical Location) for Point of Sale
POS_NO_OF_POS
INT2
000005
Number of POS with Same Address
POS_NO_OF_SUPPLIERS
INT2
000005
Number of Press Vendors for a Point of Sale
POS_PRESS_SALES_CATEGORY
CHAR
000005
Type of Press Products
POS_PRESS_SALES_VOLUME
CHAR
000005
Weekly Press Sales
POS_INT_SALES_INFLUENCE_1
CHAR
000002
Internal (Primary) Influencing Factor for POS Sales
POS_INT_SALES_INFLUENCE_2
CHAR
000002
Internal (Secondary) Influencing Factor for POS Sales
POS_INT_SALES_INFLUENCE_3
CHAR
000002
Internal (Tertiary) Influencing Factor for POS Sales
EHASTRA_SALES_INFLUENCE_2
CHAR
000002
External (Secondary) Influencing Factor for POS Sales
EHASTRA_SALES_INFLUENCE_3
CHAR
000002
External (Tertiary) Influencing Factor for POS Sales
POS_CUST_FREQUENCE_ORIG
CHAR
000002
POS: Origin of Customer Frequency
POS_CASH_SCANNER
CHAR
000001
Scanner Cash Desk at Point of Sale
POS_SALES_COUNTER
CHAR
000001
Sales Counter at Point of Sale
POS_BUSINESS_HOURS_ID
CHAR
000003
Business Hours ID (Default Number)
MO_MORNING_OPEN
TIMS
000006
Business Hours: Monday Mornings From
MO_MORNING_CLOSE
TIMS
000006
Business Hours: Monday Mornings To
MO_AFTERNOON_OPEN
TIMS
000006
Business Hours: Monday Afternoons From
MO_AFTERNOON_CLOSE
TIMS
000006
Business Hours: Monday Afternoons To
TU_MORNING_OPEN
TIMS
000006
Business Hours: Tuesday Mornings From
TU_MORNING_CLOSE
TIMS
000006
Business Hours: Tuesday Mornings To
TU_AFTERNOON_OPEN
TIMS
000006
Business Hours: Tuesday Afternoons From
TU_AFTERNOON_CLOSE
TIMS
000006
Business Hours: Tuesday Afternoons To
WE_MORNING_OPEN
TIMS
000006
Business Hours: Wednesday Mornings From
WE_MORNING_CLOSE
TIMS
000006
Business Hours: Wednesday Mornings To
WE_AFTERNOON_OPEN
TIMS
000006
Business Hours: Wednesday Afternoons From
WE_AFTERNOON_CLOSE
TIMS
000006
Business Hours: Wednesday Afternoons To
TH_MORNING_OPEN
TIMS
000006
Business Hours: Thursday Mornings From
TH_MORNING_CLOSE
TIMS
000006
Business Hours: Thursday Mornings To
TH_AFTERNOON_OPEN
TIMS
000006
Business Hours: Thursday Afternoons From
TH_AFTERNOON_CLOSE
TIMS
000006
Business Hours: Thursday Afternoons To
FR_MORNING_OPEN
TIMS
000006
Business Hours: Friday Mornings From
FR_MORNING_CLOSE
TIMS
000006
Business Hours: Friday Mornings To
FR_AFTERNOON_OPEN
TIMS
000006
Business Hours: Friday Afternoons From
FR_AFTERNOON_CLOSE
TIMS
000006
Business Hours: Friday Afternoons To
SA_MORNING_OPEN
TIMS
000006
Business Hours: Saturday Mornings From
SA_MORNING_CLOSE
TIMS
000006
Business Hours: Saturday Mornings To
SA_AFTERNOON_OPEN
TIMS
000006
Business Hours: Saturday Afternoons From
SA_AFTERNOON_CLOSE
TIMS
000006
Business Hours: Saturday Afternoons To
SU_MORNING_OPEN
TIMS
000006
Business Hours: Sunday Mornings From
SU_MORNING_CLOSE
TIMS
000006
Business Hours: Sunday Mornings To
SU_AFTERNOON_OPEN
TIMS
000006
Business Hours: Sunday Afternoons From
SU_AFTERNOON_CLOSE
TIMS
000006
Business Hours: Sunday Afternoons To
RECALL_CALENDER
CHAR
000002
Recall Calendar
RECALL_ALLOWED_MO
CHAR
000001
Recall Allowed on Monday
RECALL_ALLOWED_TU
CHAR
000001
Recall Allowed on Tuesday
RECALL_ALLOWED_WD
CHAR
000001
Recall Allowed on Wednesday
RECALL_ALLOWED_TH
CHAR
000001
Recall Allowed on Thursday
RECALL_ALLOWED_FR
CHAR
000001
Recall Allowed on Friday
RECALL_ALLOWED_SA
CHAR
000001
Recall Allowed on Saturday
RECALL_ALLOWED_SU
CHAR
000001
Recall Allowed on Sunday
RECALL_GROUP
CHAR
000004
Recall Group
RETAILER_SALES
TTYP
000000
RETAILER_POSAID
TTYP
000000
Length: 32867 Date: 20240425 Time: 162508 sap01-206 ( 68 ms )
