SAP ABAP Table TOTAL_K003 (Price Catalog)
Hierarchy
☛
EA-RETAIL (Software Component) SAP Enterprise Extension Retail
⤷ SD-EDI (Application Component) Electronic Data Interchange
⤷ VPRI (Package) Application Development R/3 Retail/CP EDI messages
⤷ SD-EDI (Application Component) Electronic Data Interchange
⤷ VPRI (Package) Application Development R/3 Retail/CP EDI messages
Basic Data
Table Category | INTTAB | Structure |
Structure | TOTAL_K003 | Table Relationship Diagram |
Short Description | Price Catalog |
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 | PRICAT: Catalog item basic data | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | PRINBR | PRINBR | PRINBR | CHAR | 10 | 0 | PRICAT: Unique internal catalog number | PRICAT_K001 | |
4 | PRODUCTGROUP | PRIPRODUCTGROUP | PRIPRODUCTGROUP | CHAR | 18 | 0 | PRICAT: PGI or assortment module from Pricat IDoc | PRICAT_K002 | |
5 | EAN_UPC_BASE | PRIEANBASIS | PRIEAN | CHAR | 35 | 0 | PRICAT: EAN/UPC Code of the Base Unit of Measure | ||
6 | VALIDITY_BASE | PRIVALIDITY | DATUM | DATS | 8 | 0 | Price Catalog Inbound Start of Validity Period | ||
7 | EAN_UPC_TYPE | PRIEANTYP | PRIEANTYP | CHAR | 2 | 0 | Type of material identification | ||
8 | BEARB_STATUS | PRIBEARBSTAT | PRIBEARBSTAT | CHAR | 2 | 0 | PRICAT: Status of material/unit of measure processing | ||
9 | STATEINDICATOR | PRISTATEINDICATOR | PRISTATEINDICATOR | CHAR | 2 | 0 | PRICAT: Movement Indicator for the Item | ||
10 | PUR_GROUP | EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | T024 | |
11 | MATERIAL_GROUP | PRIMATKL | PRICHAR35 | CHAR | 35 | 0 | PRICAT: Material group from the message (char 35) | ||
12 | MAT_ID_SENDER | PRIMATLIEF | PRICHAR35 | CHAR | 35 | 0 | PRICAT: Material number of the sender of the message | ||
13 | SHELF_LIFE_MSG | PRIMHD | PRIPERIODE | CHAR | 6 | 0 | PRICAT: Shelf life expiration in time unit from message | ||
14 | SHELF_LIFE_QUAL | PRIQUALPERIOD | PRIQUALPERIOD | CHAR | 3 | 0 | PRICAT: Qualifier for periods | ||
15 | COMPOSITION | PRICOMPOSITION | PRICHAR3 | CHAR | 3 | 0 | PRICAT: Product composition | ||
16 | .INCLUDE | 0 | 0 | PRICAT: Catalog item basic data from MARART segment | |||||
17 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
18 | MATL_TYPE | MTART | MTART | CHAR | 4 | 0 | Material type | T134 | |
19 | MATL_GROUP | MATKL | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
20 | MATL_CAT | ATTYP | ATTYP | CHAR | 2 | 0 | Material Category | ||
21 | DEL_FLAG | LVOMA | XFELD | CHAR | 1 | 0 | Flag Material for Deletion at Client Level | ||
22 | CONTAINER | BEHVO | BEHVO | CHAR | 2 | 0 | Container requirements | T144 | |
23 | STOR_CONDS | RAUBE | RAUBE | CHAR | 2 | 0 | Storage conditions | T142 | |
24 | TEMP_CONDS | TEMPB | TEMPB | CHAR | 2 | 0 | Temperature conditions indicator | T143 | |
25 | HAZ_MAT_NO | STOFF | STOFF | CHAR | 18 | 0 | Hazardous material number | MGEF | |
26 | DIVISION | SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
27 | SEASON | SAISO | SAISO | CHAR | 4 | 0 | Season Category | T6WSP | |
28 | ALLOWED_WT | ERGEW | MENG13 | QUAN | 13 | 3 | Allowed packaging weight | ||
29 | PACK_WT_UN | ERGEI | MEINS | UNIT | 3 | 0 | Unit of weight (allowed packaging weight) | T006 | |
30 | PACK_WT_UN_ISO | ERGEI_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit of weight (allowed packaging weight) in ISO code | T006I | |
31 | ALLWD_VOL | ERVOL | MENG13 | QUAN | 13 | 3 | Allowed packaging volume | ||
32 | PACK_VO_UN | ERVOE | MEINS | UNIT | 3 | 0 | Volume unit (allowed packaging volume) | T006 | |
33 | PACK_VO_UN_ISO | ERVOE_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Volume unit (allowed packaging volume) in ISO code | T006I | |
34 | VAR_ORD_UN | VABME | VABME | CHAR | 1 | 0 | Variable Purchase Order Unit Active | ||
35 | BATCH_MGMT | XCHPF | XFELD | CHAR | 1 | 0 | Batch management requirement indicator | ||
36 | SH_MAT_TYP | VHIART | TRATY | CHAR | 4 | 0 | Shipping material type | TVTY | |
37 | FILL_LEVEL | FUELG | DEC3 | DEC | 3 | 0 | Filling level (by volume) | ||
38 | STACK_FACT | STFAK | INT2 | INT2 | 5 | 0 | Stacking factor | ||
39 | MAT_GRP_SM | MAGRV | MAGRV | CHAR | 4 | 0 | Material Group: Packaging Materials | TVEGR | |
40 | MINREMLIFE | MHDRZ | DEC4 | DEC | 4 | 0 | Minimum Remaining Shelf Life | ||
41 | SHELF_LIFE | MHDHB | DEC4 | DEC | 4 | 0 | Total shelf life | ||
42 | STOR_PCT | MHDLP | DEC3 | DEC | 3 | 0 | Storage percentage | ||
43 | SAESON_YR | SAISJ | CJAHR | CHAR | 4 | 0 | Season Year | ||
44 | PRICE_BAND | PLGTP | PLGTP | CHAR | 2 | 0 | Price band category | TWPT | |
45 | EMPTIESBOM | W_MITLEERG | FLAG | CHAR | 1 | 0 | Empties Bill of Material | ||
46 | EXTMATLGRP | EXTWG | EXTWG | CHAR | 18 | 0 | External material group | * | |
47 | CONT_UNIT | INHME | MEINS | UNIT | 3 | 0 | Content unit | T006 | |
48 | CONT_UNIT_ISO | INHME_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Content unit in ISO code | T006I | |
49 | NET_CONT | INHAL | MENG13 | QUAN | 13 | 3 | Net contents | ||
50 | COMPPRUNIT | VPREH | PACK3 | DEC | 5 | 0 | Comparison price unit | ||
51 | GROSS_CONT | INHBR | MENG13 | QUAN | 13 | 3 | Gross contents | ||
52 | ENVT_RLVT | KZUMW | XFELD | CHAR | 1 | 0 | Indicator: Environmentally relevant | ||
53 | SEASMATCAT | SAITY | SAITY | CHAR | 2 | 0 | Categories of seasonal materials | T6WSA | |
54 | HAZMATPROF | ADGE_PROFL | ADGD_PROFL | CHAR | 3 | 0 | Dangerous goods indicator profile | TDG41 | |
55 | HIGH_VISC | ADGE_IHIVI | X | CHAR | 1 | 0 | Indicator: Highly viscous | ||
56 | LOOSEORLIQ | ADGE_ILOOS | X | CHAR | 1 | 0 | Indicator: In bulk/liquid | ||
57 | CLOSED_BOX | KZGVH | XFELD | CHAR | 1 | 0 | Shipping material is closed packaging | ||
58 | APPD_B_REC | XGCHP | XFELD | CHAR | 1 | 0 | Indicator: Approved batch record required | ||
59 | PERIOD_IND_EXPIR | DATTP | DATTP | CHAR | 1 | 0 | Period Indicator for Shelf Life Expiration Date | ||
60 | ROUND_RULE_EXPIR | RDMHD | RDMHD | CHAR | 1 | 0 | Rounding rule for calculation of SLED | ||
61 | PROD_COMP_PACKAG | PRZUS | XFELD | CHAR | 1 | 0 | Indicator: Product composition printed on packaging | ||
62 | .INCLUDE | 0 | 0 | PRICAT: Catalog item basic data from MAW1RT segment | |||||
63 | SALES_UNIT | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
64 | SALES_UNIT_ISO | VRKME_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Sales unit in ISO code | T006I | |
65 | ISSUE_UNIT | AUSME | MEINS | UNIT | 3 | 0 | Unit of issue | T006 | |
66 | ISSUE_UNIT_ISO | AUSME_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit of issue in ISO code | T006I | |
67 | COUNTRYORI | HERKL | LAND1 | CHAR | 3 | 0 | Country of origin of the material | T005 | |
68 | COUNTRYORI_ISO | HERKL_ISO | INTCA | CHAR | 2 | 0 | Material's country of origin in ISO code | ||
69 | REGIONORIG | HERKR | REGIO | CHAR | 3 | 0 | Region of origin of material (non-preferential origin) | T005S | |
70 | COMM_CODE | STAWN | STAWN | CHAR | 17 | 0 | Commodity Code/Import Code Number for Foreign Trade | T604 | |
71 | .INCLU--AP | 0 | 0 | Price Catalog Inbound: New Fields | |||||
72 | LOCK_STATUS | WRF_LOCK_STATUS | FLAG | CHAR | 1 | 0 | Price Catalog: Lock Status (Yes or No) | ||
73 | SATNR | SATNR | MATNR | CHAR | 18 | 0 | Cross-Plant Configurable Material | * | |
74 | VENDOR_SATNR | WRF_VENDOR_SATNR | WRF_VENDOR_SATNR | CHAR | 20 | 0 | Price Catalog: Grouping Field: Generic Material Assignment | ||
75 | SATNR_HEAD_FLAG | WRF_MASTER_VARIANT | CHAR1 | CHAR | 1 | 0 | Master Variant | ||
76 | PROC_STATUS | WRF_PROCSTATUS | WRF_PROCSTATUS | CHAR | 2 | 0 | Processing Status | WRF_PRICAT_PROC | |
77 | TAKE_OVER_DATE | WRF_TAKE_OVER_DATE | DATUM | DATS | 8 | 0 | Price Catalog: Transfer Date (in PRICAT Data Pool) | ||
78 | TRIGGER_DATE | WRF_TRIGGER_DATE | DATUM | DATS | 8 | 0 | Primary Update Date Set Online | ||
79 | MORE_MATNR | MORE_MATNR | FLAG | CHAR | 1 | 0 | Price Catalog Indicator EAN for Mat. No. = 1..n | ||
80 | REF_ARTICLE | WWGDA | MATNR | CHAR | 18 | 0 | Material group reference material | MARA | |
81 | HIER_ID | WRF_HIER_CNT | WRF_HIERCNT | CHAR | 2 | 0 | Hierarchy | ||
82 | HIER_NODE | WRF_STRUC_NODE | WRF_NODES | CHAR | 18 | 0 | Hierarchy Node | ||
83 | MERKMALSPROFIL | WRF_PROFIL | KLASSE | CHAR | 18 | 0 | Characteristic Profile | ||
84 | MANUAL_CHANGE | MANUAL_CHANGE | FLAG | CHAR | 1 | 0 | Manual Change | ||
85 | PROFILENAME | WRF_PROFILENAME | TEXT40 | CHAR | 40 | 0 | Profile Name | ||
86 | IV_OLD | FLAG | FLAG | CHAR | 1 | 0 | General Flag | ||
87 | REF_EAN_LINE | CL_PRICAT_EAN_LINE | REF | 0 | 0 |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 200 |