SAP Table PRICAT_K004_MARK
Price Catalog: k004 + Flag
PRICAT_K004_MARK (Price Catalog: k004 + Flag) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link PRICAT_K004_MARK to other SAP tables.
Source: PRICAT_K004_MARK (Price Catalog: k004 + Flag)
PRICAT_K004_MARK table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||
| PRINBR | PRICAT: Unique internal catalog number | PRINBR | PRICAT_K001 | CHAR | 10 | 0 | ||||||||||||||||
| PRODUCTGROUP | PRICAT: PGI or assortment module from Pricat IDoc | PRIPRODUCTGROUP | PRICAT_K002 | CHAR | 18 | 0 | ||||||||||||||||
| EAN_UPC_ALTUNIT | PRICAT: EAN/UPC code of the unit of measure | PRIEANUNIT | CHAR | 35 | 0 | |||||||||||||||||
| VALIDITY_UNIT | PRICAT: Date From Which the Unit Change is Valid | PRIVALIDITYU | DATS | 8 | 0 | |||||||||||||||||
| VALIDITY_BASE | Price Catalog Inbound Start of Validity Period | PRIVALIDITY | PRICAT_K003 | DATS | 8 | 0 | ||||||||||||||||
| EAN_UPC_TYPE | Type of material identification | PRIEANTYP | CHAR | 2 | 0 | |||||||||||||||||
| EAN_UPC_BASE | PRICAT: EAN/UPC Code of Base Unit of Measure | PRIEANBASIS | PRICAT_K003 | CHAR | 35 | 0 | ||||||||||||||||
| EAN_UPC_SUBLINE | PRICAT: Higher-level unit of measure of base unit of measure | PRISUBLINE | CHAR | 35 | 0 | |||||||||||||||||
| QUANTITY_SUBLINE | PRICAT: Quantity of lower-level material unit | PRIQTYSUBL | NUMC | 15 | 0 | |||||||||||||||||
| QUANTITY_UNIT | PRICAT: No. of base units contained | PRIQTYUNIT | NUMC | 15 | 0 | |||||||||||||||||
| DELIVERY_UNIT_ID | PRICAT: Unit is delivery unit of the sender | PRIDELUNIT | NUMC | 17 | 0 | |||||||||||||||||
| INVOICE_UNIT_ID | PRICAT: Unit is billing unit of the sender | PRIINVUNIT | NUMC | 17 | 0 | |||||||||||||||||
| ORDER_UNIT_ID | PRICAT: Unit is the order unit of the sender | PRIORDUNIT | NUMC | 17 | 0 | |||||||||||||||||
| PACKAGE_TYPE | PRICAT: Packing type of the unit | PRIPACKTYP | CHAR | 17 | 0 | |||||||||||||||||
| PROD_ID_SENDER | PRICAT: Internal Naterial no. of Sender for Unit of Measure | PRIPRODID | CHAR | 35 | 0 | |||||||||||||||||
| BEARB_STATUS | PRICAT: Status of material/unit of measure processing | PRIBEARBSTAT | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||
| TRANSPORT | PRICAT: ID for Transfer | PRIKZTRANSPORT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| ITEM_NUMBER | PRICAT: Print sequence of the vendor | PRIPRODGRP | NUMC | 6 | 0 | |||||||||||||||||
| NON_PUBLIC | PRICAT: Customer-specific material or unit of measure (y/n) | PRINONPUBL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| NON_PUBLIC_ILN | PRICAT: Cust.-spec. Material or Unit of Measure for this ILN | PRINONPUBLILN | CHAR | 35 | 0 | |||||||||||||||||
| NON_PUBLIC_ILN2 | PRICAT: Cust.-spec. Material or Unit of Measure for this ILN | PRINONPUBLILN2 | CHAR | 35 | 0 | |||||||||||||||||
| NON_PUBLIC_ILN3 | PRICAT: Cust.-spec. Material or Unit of Measure for this ILN | PRINONPUBLILN3 | CHAR | 35 | 0 | |||||||||||||||||
| NON_PUBLIC_ILN4 | PRICAT: Cust.-spec. Material or Unit of Measure for this ILN | PRINONPUBLILN4 | CHAR | 35 | 0 | |||||||||||||||||
| NON_PUBLIC_ILN5 | PRICAT: Cust.-spec. Material or Unit of Measure for this ILN | PRINONPUBLILN5 | CHAR | 35 | 0 | |||||||||||||||||
| ALT_UNIT | Alternative Unit of Measure for Stockkeeping Unit | LRMEI | T006 | UNIT | 3 | 0 | ||||||||||||||||
| ALT_UNIT_ISO | Alternative unit of measure to stockkeeping unit in ISO code | LRMEI_ISO | T006I | CHAR | 3 | 0 | ||||||||||||||||
| NUMERATOR | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | 0 | |||||||||||||||||
| DENOMINATR | Denominator for conversion to base units of measure | UMREN | DEC | 5 | 0 | |||||||||||||||||
| LENGTH | Length | LAENG | QUAN | 13 | 3 | |||||||||||||||||
| WIDTH | Width | BREIT | QUAN | 13 | 3 | |||||||||||||||||
| HEIGHT | Height | HOEHE | QUAN | 13 | 3 | |||||||||||||||||
| UNIT_LENGTH | PRICAT: Unit for length | PRIUNITLN | T006 | UNIT | 3 | 0 | ||||||||||||||||
| UNIT_LENGTH_ISO | PRICAT: Unit for length | PRIUNITLNISO | T006I | CHAR | 3 | 0 | ||||||||||||||||
| UNIT_WIDTH | PRICAT: Unit for width | PRIUNITWD | T006 | UNIT | 3 | 0 | ||||||||||||||||
| UNIT_WIDTH_ISO | PRICAT: Unit for width in ISO | PRIUNITWDISO | T006I | CHAR | 3 | 0 | ||||||||||||||||
| UNIT_HEIGHT | PRICAT: Unit for height | PRIUNITHT | T006 | UNIT | 3 | 0 | ||||||||||||||||
| UNIT_HEIGHT_ISO | PRICAT: Unit for height in ISO code | PRIUNITHTISO | T006I | CHAR | 3 | 0 | ||||||||||||||||
| VOLUME | Volume | VOLUM | QUAN | 13 | 3 | |||||||||||||||||
| VOLUMEUNIT | Volume unit | VOLEH | T006 | UNIT | 3 | 0 | ||||||||||||||||
| VOLUMEUNIT_ISO | Volume unit in ISO code | VOLEH_ISO | T006I | CHAR | 3 | 0 | ||||||||||||||||
| GROSS_WT | Gross Weight | BRGEW | QUAN | 13 | 3 | |||||||||||||||||
| UNIT_OF_WT | Weight Unit | GEWEI | T006 | UNIT | 3 | 0 | ||||||||||||||||
| UNIT_OF_WT_ISO | Unit of weight in ISO code | GEWEI_ISO | T006I | CHAR | 3 | 0 | ||||||||||||||||
| UNIT_BASE | PRICAT: Lower-level unit of measure in a packing hierarchy | PRIUNITBASE | T006 | UNIT | 3 | 0 | ||||||||||||||||
| UNIT_BASE_ISO | PRICAT: Lower-lvl unit of measure in packing hierarchy (ISO) | PRIUNITBASE_ISO | T006I | CHAR | 3 | 0 | ||||||||||||||||
| UNIT_PURORD | PRICAT: Display unit for the order unit | PRIUNITPURORD | T006 | UNIT | 3 | 0 | ||||||||||||||||
| UNIT_PURORD_ISO | PRICAT: Display unit of the order unit in ISO code | PRIUNITPURORD_ISO | T006I | CHAR | 3 | 0 | ||||||||||||||||
| NET_WEIGHT | Net Weight | NTGEW | QUAN | 13 | 3 | |||||||||||||||||
| UNIT_OF_NET | Weight unit for net weight | PRINTGEWEI | T006 | UNIT | 3 | 0 | ||||||||||||||||
| UNIT_OF_NET_ISO | Weight unit for net weight in ISO code | PRINTGEWEI_ISO | T006I | CHAR | 3 | 0 | ||||||||||||||||
| HAZARD_LIMIT | PRICAT: Dangerous goods indicator limited quantity | PRIHAZLIM | CHAR | 17 | 0 | |||||||||||||||||
| BARCODE_ID | PRICAT: Bar code indicator on package | PRIBARCODE | CHAR | 3 | 0 | |||||||||||||||||
| PALLET_HANDL | PRICAT: Pallet handling (disposable, reusable etc.) | PRIPALHAND | CHAR | 17 | 0 | |||||||||||||||||
| PALLET_TYPE | PRICAT: Pallet type (ISO, Europallet etc.) | PRIPALTYPE | CHAR | 17 | 0 | |||||||||||||||||
| PALLET_LAYER | PRICAT: Number of layers per load container | PRIPALLAYR | NUMC | 18 | 0 | |||||||||||||||||
| PALLET_UNITS | PRICAT: Number of units per load carrier | PRIPALUNIT | NUMC | 18 | 0 | |||||||||||||||||
| PALLET_HIGHT | PRICAT: Pallet load height | PRIPALHIGH | NUMC | 18 | 0 | |||||||||||||||||
| UNIT_PALHT_ISO | PRICAT: Unit for pallet height in ISO code | PRIPALHT_ISO | CHAR | 3 | 0 | |||||||||||||||||
| PALLET_STACK | PRICAT: Pallet stacking factor | PRIPALSTAK | NUMC | 18 | 0 | |||||||||||||||||
| STATE_INFO | PRICAT: Movement Indicator for the Item | PRISTATEINDICATOR | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||
| HPEAN | Indicator: Main EAN | HPEAN | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| FLAG | General Flag | FLAG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
PRICAT_K004_MARK foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| PRICAT_K004_MARK | ALT_UNIT | SYST | MANDT | T006 | Units of Measurement | MANDT |
| PRICAT_K004_MARK | ALT_UNIT | PRICAT_K004_MARK | ALT_UNIT | T006 | Units of Measurement | MSEHI |
| PRICAT_K004_MARK | ALT_UNIT_ISO | PRICAT_K004_MARK | ALT_UNIT_ISO | T006I | ISO codes for units of measurement | ISOCODE |
| PRICAT_K004_MARK | ALT_UNIT_ISO | SYST | MANDT | T006I | ISO codes for units of measurement | CLIENT |
| PRICAT_K004_MARK | EAN_UPC_BASE | PRICAT_K004_MARK | PRINBR | PRICAT_K003 | PRICAT: Catalog item basic data | PRINBR |
| PRICAT_K004_MARK | EAN_UPC_BASE | PRICAT_K004_MARK | MANDT | PRICAT_K003 | PRICAT: Catalog item basic data | MANDT |
| PRICAT_K004_MARK | EAN_UPC_BASE | PRICAT_K004_MARK | VALIDITY_BASE | PRICAT_K003 | PRICAT: Catalog item basic data | VALIDITY_BASE |
| PRICAT_K004_MARK | EAN_UPC_BASE | PRICAT_K004_MARK | EAN_UPC_BASE | PRICAT_K003 | PRICAT: Catalog item basic data | EAN_UPC_BASE |
| PRICAT_K004_MARK | EAN_UPC_BASE | PRICAT_K004_MARK | PRODUCTGROUP | PRICAT_K003 | PRICAT: Catalog item basic data | PRODUCTGROUP |
| PRICAT_K004_MARK | MANDT | PRICAT_K004_MARK | MANDT | T000 | Clients | MANDT |
| PRICAT_K004_MARK | PRINBR | PRICAT_K004_MARK | PRINBR | PRICAT_K001 | PRICAT: Catalog header | PRINBR |
| PRICAT_K004_MARK | PRINBR | PRICAT_K004_MARK | MANDT | PRICAT_K001 | PRICAT: Catalog header | MANDT |
| PRICAT_K004_MARK | PRODUCTGROUP | PRICAT_K004_MARK | PRODUCTGROUP | PRICAT_K002 | PRICAT: Catalog item product groups | PRODUCTGROUP |
| PRICAT_K004_MARK | PRODUCTGROUP | PRICAT_K004_MARK | PRINBR | PRICAT_K002 | PRICAT: Catalog item product groups | PRINBR |
| PRICAT_K004_MARK | PRODUCTGROUP | PRICAT_K004_MARK | MANDT | PRICAT_K002 | PRICAT: Catalog item product groups | MANDT |
| PRICAT_K004_MARK | UNIT_BASE | PRICAT_K004_MARK | UNIT_BASE | T006 | Units of Measurement | MSEHI |
| PRICAT_K004_MARK | UNIT_BASE | SYST | MANDT | T006 | Units of Measurement | MANDT |
| PRICAT_K004_MARK | UNIT_BASE_ISO | SYST | MANDT | T006I | ISO codes for units of measurement | CLIENT |
| PRICAT_K004_MARK | UNIT_BASE_ISO | PRICAT_K004_MARK | UNIT_BASE_ISO | T006I | ISO codes for units of measurement | ISOCODE |
| PRICAT_K004_MARK | UNIT_HEIGHT | PRICAT_K004_MARK | UNIT_HEIGHT | T006 | Units of Measurement | MSEHI |
| PRICAT_K004_MARK | UNIT_HEIGHT | SYST | MANDT | T006 | Units of Measurement | MANDT |
| PRICAT_K004_MARK | UNIT_HEIGHT_ISO | PRICAT_K004_MARK | UNIT_HEIGHT_ISO | T006I | ISO codes for units of measurement | ISOCODE |
| PRICAT_K004_MARK | UNIT_HEIGHT_ISO | SYST | MANDT | T006I | ISO codes for units of measurement | CLIENT |
| PRICAT_K004_MARK | UNIT_LENGTH | PRICAT_K004_MARK | UNIT_LENGTH | T006 | Units of Measurement | MSEHI |
| PRICAT_K004_MARK | UNIT_LENGTH | SYST | MANDT | T006 | Units of Measurement | MANDT |
| PRICAT_K004_MARK | UNIT_LENGTH_ISO | PRICAT_K004_MARK | UNIT_LENGTH_ISO | T006I | ISO codes for units of measurement | ISOCODE |
| PRICAT_K004_MARK | UNIT_LENGTH_ISO | SYST | MANDT | T006I | ISO codes for units of measurement | CLIENT |
| PRICAT_K004_MARK | UNIT_OF_NET | SYST | MANDT | T006 | Units of Measurement | MANDT |
| PRICAT_K004_MARK | UNIT_OF_NET | PRICAT_K004_MARK | UNIT_OF_NET | T006 | Units of Measurement | MSEHI |
| PRICAT_K004_MARK | UNIT_OF_NET_ISO | PRICAT_K004_MARK | UNIT_OF_NET_ISO | T006I | ISO codes for units of measurement | ISOCODE |
| PRICAT_K004_MARK | UNIT_OF_NET_ISO | SYST | MANDT | T006I | ISO codes for units of measurement | CLIENT |
| PRICAT_K004_MARK | UNIT_OF_WT | SYST | MANDT | T006 | Units of Measurement | MANDT |
| PRICAT_K004_MARK | UNIT_OF_WT | PRICAT_K004_MARK | UNIT_OF_WT | T006 | Units of Measurement | MSEHI |
| PRICAT_K004_MARK | UNIT_OF_WT_ISO | PRICAT_K004_MARK | UNIT_OF_WT_ISO | T006I | ISO codes for units of measurement | ISOCODE |
| PRICAT_K004_MARK | UNIT_OF_WT_ISO | SYST | MANDT | T006I | ISO codes for units of measurement | CLIENT |
| PRICAT_K004_MARK | UNIT_PURORD | SYST | MANDT | T006 | Units of Measurement | MANDT |
| PRICAT_K004_MARK | UNIT_PURORD | PRICAT_K004_MARK | UNIT_PURORD | T006 | Units of Measurement | MSEHI |
| PRICAT_K004_MARK | UNIT_PURORD_ISO | PRICAT_K004_MARK | UNIT_PURORD_ISO | T006I | ISO codes for units of measurement | ISOCODE |
| PRICAT_K004_MARK | UNIT_PURORD_ISO | SYST | MANDT | T006I | ISO codes for units of measurement | CLIENT |
| PRICAT_K004_MARK | UNIT_WIDTH | SYST | MANDT | T006 | Units of Measurement | MANDT |
| PRICAT_K004_MARK | UNIT_WIDTH | PRICAT_K004_MARK | UNIT_WIDTH | T006 | Units of Measurement | MSEHI |
| PRICAT_K004_MARK | UNIT_WIDTH_ISO | PRICAT_K004_MARK | UNIT_WIDTH_ISO | T006I | ISO codes for units of measurement | ISOCODE |
| PRICAT_K004_MARK | UNIT_WIDTH_ISO | SYST | MANDT | T006I | ISO codes for units of measurement | CLIENT |
| PRICAT_K004_MARK | VALIDITY_BASE | PRICAT_K004_MARK | VALIDITY_BASE | PRICAT_K003 | PRICAT: Catalog item basic data | VALIDITY_BASE |
| PRICAT_K004_MARK | VALIDITY_BASE | PRICAT_K004_MARK | EAN_UPC_BASE | PRICAT_K003 | PRICAT: Catalog item basic data | EAN_UPC_BASE |
| PRICAT_K004_MARK | VALIDITY_BASE | PRICAT_K004_MARK | PRODUCTGROUP | PRICAT_K003 | PRICAT: Catalog item basic data | PRODUCTGROUP |
| PRICAT_K004_MARK | VALIDITY_BASE | PRICAT_K004_MARK | PRINBR | PRICAT_K003 | PRICAT: Catalog item basic data | PRINBR |
| PRICAT_K004_MARK | VALIDITY_BASE | PRICAT_K004_MARK | MANDT | PRICAT_K003 | PRICAT: Catalog item basic data | MANDT |
| PRICAT_K004_MARK | VOLUMEUNIT | SYST | MANDT | T006 | Units of Measurement | MANDT |
| PRICAT_K004_MARK | VOLUMEUNIT | PRICAT_K004_MARK | VOLUMEUNIT | T006 | Units of Measurement | MSEHI |
| PRICAT_K004_MARK | VOLUMEUNIT_ISO | PRICAT_K004_MARK | VOLUMEUNIT_ISO | T006I | ISO codes for units of measurement | ISOCODE |
| PRICAT_K004_MARK | VOLUMEUNIT_ISO | SYST | MANDT | T006I | ISO codes for units of measurement | CLIENT |
