SAP ABAP Table /POSDW/MON_BALANCING (Display Structure for Balancing)
Hierarchy
BI_CONT (Software Component) Business Intelligence Content
   BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
     /POSDW/SALES_AUDIT_DATA (Package) Classes for Manipulation of Data and API Connection
Basic Data
Table Category INTTAB    Structure 
Structure /POSDW/MON_BALANCING   Table Relationship Diagram
Short Description Display Structure for Balancing    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 .INCLUDE       0   0   Transaction  
2 .INCLUDE       0   0   Transaction - Database Fields  
3 .INCLUDE       0   0   Transaction - Database Fields (Key Fields)  
4 RETAILSTOREID /POSDW/RETAILSTOREID /POSDW/RETAILSTOREID CHAR 10   0   Store  
5 BUSINESSDAYDATE /POSDW/BUSINESSDAYDATE /POSDW/DATE DATS 8   0   Posting Date  
6 TRANSTYPECODE /POSDW/TRANSACTIONTYPECODE /POSDW/TRANSACTIONTYPECODE CHAR 4   0   Transaction Type /POSDW/TRANTY
7 WORKSTATIONID /POSDW/WORKSTATIONID /POSDW/WORKSTATIONID CHAR 10   0   POS Number  
8 TRANSNUMBER /POSDW/TRANSACTIONSEQUENCENUMB /POSDW/TRANSACTIONSEQUENCENUMB CHAR 20   0   Transaction Number  
9 BEGINTIMESTAMP /POSDW/BEGINDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Starts  
10 ENDTIMESTAMP /POSDW/ENDDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Ends  
11 DEPARTMENT /POSDW/DEPARTMENT /POSDW/CHAR10ALPHA CHAR 10   0   Department  
12 OPERATORQUAL /POSDW/OPERATORQUALIFIER /POSDW/OPERATORQUALIFIER CHAR 1   0   Operator Qualifier  
13 OPERATORID /POSDW/OPERATORID /POSDW/CHAR30ALPHA CHAR 30   0   Cashier Number or Name  
14 TRANSCURRENCY /POSDW/TRANSACTIONCURRENCY WAERS CUKY 5   0   Transaction Currency *
15 PARTNERQUALIFIER /POSDW/PARTNERQUALIFIER /POSDW/PARTNERQUALIFIER CHAR 1   0   Qualifier for Partner Number  
16 PARTNERID /POSDW/PARTNERID /POSDW/CHAR13ALPHA CHAR 13   0   Partner Number  
17 .INCLUDE       0   0   Transaction - Enhanced Fields  
18 TRANSINDEX /POSDW/TRANSINDEX /POSDW/TRANSINDEX INT4 10   0   Transaction Index  
19 NONCOMPFLAG /POSDW/NONCOMPFLAG /POSDW/FLAG CHAR 1   0   Indicator for Non-Comparable Sales  
20 TRANSTYPEGROUP /POSDW/TRANSACTIONTYPEGROUP /POSDW/TRANSACTIONTYPEGROUP CHAR 4   0   Transaction Type Group /POSDW/TRANTG
21 BUSINESSTYPE /POSDW/BUSINESSTYPE /POSDW/BUSINESSTYPE CHAR 1   0   Business Transaction  
22 REVERSALFLAG /POSDW/REVERSALFLAG /POSDW/FLAG CHAR 1   0   Reversal Indicator  
23 TRANSDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
24 PLANT /POSDW/PLANT CHAR4 CHAR 4   0   Plant  
25 STORECURRENCY /POSDW/STORECURRENCY WAERS CUKY 5   0   Local Currency *
26 PLANTCUSTOMER /POSDW/PLANTCUSTOMER /POSDW/CHAR10ALPHA CHAR 10   0   Customer Number of Plant  
27 BUSINESSLOCATION /POSDW/BUSINESSLOCATION /POSDW/CHAR10ALPHA CHAR 10   0   Business Location Identifier (IS-OIL/MRN)  
28 TURNOVER /POSDW/TRANSTURNOVER /POSDW/CURRENCY CURR 15   2   Sales Totals Per Transaction  
29 INDEXCURRENCY /POSDW/INDEXCURRENCY WAERS CUKY 5   0   Currency for Sales Totals *
30 VERSION /POSDW/TRANSACTION_VERSION /POSDW/TRANSACTION_VERSION INT1 3   0   Version of POS Transaction  
31 TOTALS_TYPE /POSDW/TOTALSTYPE CHAR1 CHAR 1   0   Totals Type  
32 ITEM_TYPE /POSDW/ITEMTYPE /POSDW/RETAILTYPECODE CHAR 4   0   Item Category *
33 VALUE_TOTAL /POSDW/BAL_VAL_TOT /POSDW/CURRENCY CURR 15   2   Total Value in Totals Record  
34 VALUE_SUM /POSDW/BAL_VAL_SUM /POSDW/CURRENCY CURR 15   2   Total Value of POS Transactions  
35 VALUE_DIFF_ABS /POSDW/BAL_VAL_DIFF_ABS /POSDW/CURRENCY CURR 15   2   Absolute Difference in Value  
36 VALUE_DIFF_REL /POSDW/BAL_VAL_DIFF_REL DEC3_3 DEC 6   3   Relative Difference in Value  
37 COUNT_TOTAL /POSDW/BAL_CNT_TOT INT4 INT4 10   0   Total Number of POS Transactions in Total Record  
38 COUNT_SUM /POSDW/BAL_CNT_SUM INT4 INT4 10   0   Total Number of POS Transactions (Sum of Single Records)  
39 COUNT_DIFF /POSDW/BAL_CNT_DIFF_ABS INT4 INT4 10   0   Absolute Difference in Number  
40 COUNT_DIFF_REL /POSDW/BAL_CNT_DIFF_REL DEC3_3 DEC 6   3   Relative Difference in Number  
41 ICON_DIFFERENCE /POSDW/BAL_DIF_ICON INT1 INT1 3   0   Variance in Balancing  
42 NO_TOTAL_TRANS XFELD XFELD CHAR 1   0   Checkbox  
43 DISABLE_TENDER_L /POSDW/LINE_BALANCING_OFF /POSDW/LINE_BALANCING_OFF CHAR 1   0   Flag Indicating Line Balancing Is Off  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /POSDW/MON_BALANCING TRANSTYPECODE /POSDW/TRANTY TRANSTYPECODE KEY 1 CN
2 /POSDW/MON_BALANCING TRANSTYPEGROUP /POSDW/TRANTG TRANSTYPEGROUP 1 CN
History
Last changed by/on SAP  20100326 
SAP Release Created in 30B