SAP TOTAL_K003 Table in S/4 HANA - Price Catalog









TOTAL_K003 is a standard SAP Table which is used to store Price Catalog data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the TOTAL_K003 table(ECC)

Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Structure
Database Table: TOTAL_K003


TOTAL_K003 table structure field list

Below is the full TOTAL_K003 field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field


Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP SHLP Field
MANDTClientMANDTCLNT3(0) T000MANDT
PRINBRPRICAT: Unique internal catalog numberPRINBRCHAR10(0) PRICAT_K001PRINBRPRNPRICAT_HEADERPRINBR
PRODUCTGROUPPRICAT: PGI or assortment module from Pricat IDocPRIPRODUCTGROUPCHAR18(0) PRICAT_K002PRIPRODUCTGROUP
EAN_UPC_BASEPRICAT: EAN/UPC Code of Base Unit of MeasurePRIEANBASISCHAR35(0) PRIEAN
VALIDITY_BASEPrice Catalog Inbound Start of Validity PeriodPRIVALIDITYDATS8(0) DATUM
EAN_UPC_TYPEType of material identificationPRIEANTYPCHAR2(0) PRIEANTYP
BEARB_STATUSPRICAT: Status of material/unit of measure processingPRIBEARBSTATCHAR2(0) PRIBEARBSTAT
STATEINDICATORPRICAT: Movement Indicator for the ItemPRISTATEINDICATORCHAR2(0) PRISTATEINDICATOR
PUR_GROUPPurchasing GroupEKGRPCHAR3(0) T024EKGRPEKG
MATERIAL_GROUPPRICAT: Material Group from MessagePRIMATKLCHAR35(0) PRICHAR35
MAT_ID_SENDERPRICAT: Material Number of the Sender of the MessagePRIMATLIEFCHAR35(0) PRICHAR35
SHELF_LIFE_MSGPRICAT: Shelf life expiration in time unit from messagePRIMHDCHAR6(0) PRIPERIODE
SHELF_LIFE_QUALPRICAT: Qualifier for periodsPRIQUALPERIODCHAR3(0) PRIQUALPERIOD
COMPOSITIONPRICAT: Product CompositionPRICOMPOSITIONCHAR3(0) PRICHAR3
MATNRMaterial NumberMATNRCHAR40(0) MARAMATN1MATNRMATS_MAT1MATNR
MATL_TYPEMaterial typeMTARTCHAR4(0) T134MTARTMTA
MATL_GROUPMaterial GroupMATKLCHAR9(0) MATKLMKLS_WBWGMATKL
MATL_CATMaterial CategoryATTYPCHAR2(0) ATTYPMTY
DEL_FLAGFlag Material for Deletion at Client LevelLVOMACHAR1(0) XFELD
CONTAINERContainer requirementsBEHVOCHAR2(0) T144BEHVO
STOR_CONDSStorage conditionsRAUBECHAR2(0) T142RAUBE
TEMP_CONDSTemperature conditions indicatorTEMPBCHAR2(0) T143TEMPB
HAZ_MAT_NOHazardous material numberSTOFFCHAR40(0) MGEFMATN3STOFFSTO
DIVISIONDivisionSPARTCHAR2(0) TSPASPARTSPAC_SPARTSPART
SEASONSeason CategorySAISOCHAR4(0) T6WSPSAISOSAISO
ALLOWED_WTAllowed packaging weightERGEWQUAN13(3) MENG13
PACK_WT_UNUnit of weight (allowed packaging weight)ERGEIUNIT3(0) T006CUNITMEINS
PACK_WT_UN_ISOUnit of weight (allowed packaging weight) in ISO codeERGEI_ISOCHAR3(0) T006IISOCD_UNIT
ALLWD_VOLAllowed packaging volumeERVOLQUAN13(3) MENG13
PACK_VO_UNVolume unit (allowed packaging volume)ERVOEUNIT3(0) T006CUNITMEINS
PACK_VO_UN_ISOVolume unit (allowed packaging volume) in ISO codeERVOE_ISOCHAR3(0) T006IISOCD_UNIT
VAR_ORD_UNVariable Purchase Order Unit ActiveVABMECHAR1(0) VABME
BATCH_MGMTBatch management requirement indicatorXCHPFCHAR1(0) XFELD
SH_MAT_TYPPackaging Material TypeVHIARTCHAR4(0) TVTYTRATY
FILL_LEVELMaximum level (by volume)FUELGDEC3(0) DEC3
STACK_FACTStacking factorSTFAKINT25(0) INT2
MAT_GRP_SMMaterial Group: Packaging MaterialsMAGRVCHAR4(0) TVEGRMAGRV
MINREMLIFEMinimum Remaining Shelf LifeMHDRZDEC4(0) DEC4
SHELF_LIFETotal shelf lifeMHDHBDEC4(0) DEC4
STOR_PCTStorage percentageMHDLPDEC3(0) DEC3
SAESON_YRSeason YearSAISJCHAR4(0) GJAHRCJAHRWMSAISJ
PRICE_BANDPrice Band CategoryPLGTPCHAR2(0) TWPTPLGTP
EMPTIESBOMEmpties Bill of MaterialW_MITLEERGCHAR1(0) FLAG
EXTMATLGRPExternal Material GroupEXTWGCHAR18(0) Assigned to domainEXTWG
CONT_UNITContent unitINHMEUNIT3(0) T006CUNITMEINS
CONT_UNIT_ISOContent unit in ISO codeINHME_ISOCHAR3(0) T006IISOCD_UNIT
NET_CONTNet contentsINHALQUAN13(3) MENG13
COMPPRUNITComparison price unitVPREHDEC5(0) PACK3
GROSS_CONTGross contentsINHBRQUAN13(3) MENG13
ENVT_RLVTEnvironmentally RelevantKZUMWCHAR1(0) XFELD
SEASMATCATRollout in a SeasonSAITYCHAR2(0) T6WSASAITYWMSAITY
HAZMATPROFDangerous Goods Indicator ProfileADGE_PROFLCHAR3(0) TDG41ADGD_PROFL
HIGH_VISCIndicator: Highly ViscousADGE_IHIVICHAR1(0) X
LOOSEORLIQIndicator: In Bulk/LiquidADGE_ILOOSCHAR1(0) X
CLOSED_BOXPackaging Material is Closed PackagingKZGVHCHAR1(0) XFELD
APPD_B_RECApproved Batch Record RequiredXGCHPCHAR1(0) XFELD
PERIOD_IND_EXPIRPeriod Indicator for Shelf Life Expiration DateDATTPCHAR1(0) PERKZDATTPH_PERDKZEPRKZ
ROUND_RULE_EXPIRRounding rule for calculation of SLEDRDMHDCHAR1(0) RDMHD
PROD_COMP_PACKAGIndicator: Product composition printed on packagingPRZUSCHAR1(0) XFELD
SALES_UNITSales unitVRKMEUNIT3(0) T006CUNITMEINS
SALES_UNIT_ISOSales unit in ISO codeVRKME_ISOCHAR3(0) T006IISOCD_UNIT
ISSUE_UNITUnit of issueAUSMEUNIT3(0) T006CUNITMEINS
ISSUE_UNIT_ISOUnit of issue in ISO codeAUSME_ISOCHAR3(0) T006IISOCD_UNIT
COUNTRYORICountry of Origin of Material (Non-Preferential Origin)HERKLCHAR3(0) T005LAND1LND
COUNTRYORI_ISOMaterial's country of origin in ISO codeHERKL_ISOCHAR2(0) INTCA
REGIONORIGRegion of Origin of Material (Non-Preferential Origin)HERKRCHAR3(0) T005SREGIO
COMM_CODECommodity CodeSTAWNCHAR17(0) T604STAWN
.INCLU--AP0(0)
LOCK_STATUSLock Status (Yes or No)WRF_LOCK_STATUSCHAR1(0) FLAG
SATNRCross-Plant Configurable MaterialSATNRCHAR40(0) Assigned to domainMATN1MATNR
VENDOR_SATNRPrice Catalog: Grouping Field: Generic Article AssignmentWRF_VENDOR_SATNRCHAR20(0) WRF_VENDOR_SATNR
SATNR_HEAD_FLAGMaster VariantWRF_MASTER_VARIANTCHAR1(0) CHAR1
PROC_STATUSProcessing StatusWRF_PROCSTATUSCHAR2(0) WRF_PRICAT_PROCWRF_PROCSTATUSPROC_STATUSWRF_PROCSTATUS
TAKE_OVER_DATETransfer Date (in PRICAT Data Pool)WRF_TAKE_OVER_DATEDATS8(0) DATUM
TRIGGER_DATEPrimary Update Date Set OnlineWRF_TRIGGER_DATEDATS8(0) DATUM
MORE_MATNRPrice Catalog Indicator EAN for Mat. No. = 1..nMORE_MATNRCHAR1(0) FLAG
REF_ARTICLEMaterial group reference materialWWGDACHAR40(0) MARAMATN1MATNRMAT
HIER_IDHierarchyWRF_HIER_CNTCHAR2(0) WRF_HIERCNTRTHIERWRF_HIERID_STATUSHIER_ID
HIER_NODEHierarchy NodeWRF_STRUC_NODECHAR18(0) WRF_NODESRTNODEWRF_MATGRP_CSHLPNODE
MERKMALSPROFILCharacteristic ProfileWRF_PROFILCHAR18(0) KLASSEKLAWMPRCLASS
MANUAL_CHANGEManual ChangeMANUAL_CHANGECHAR1(0) FLAG
PROFILENAMEProfile NameWRF_PROFILENAMECHAR40(0) TEXT40
CONFIG_KLARTConfiguration Class TypeKLART_VARCHAR3(0) Assigned to domainKLASSENARTKAR
CONFIG_CLASSConfiguration ClassCLASS_VARCHAR18(0) KLASSEKLA
.INCLU--AP0(0)
CAT_GROUP_1KATALOG_GRUPPECATALOGUE_GROUPCHAR12(0) WRF_CAT_GROUPCATALOGUE_GROUP
CAT_GROUP_2KATALOG_GRUPPECATALOGUE_GROUPCHAR12(0) WRF_CAT_GROUPCATALOGUE_GROUP
CAT_GROUP_3KATALOG_GRUPPECATALOGUE_GROUPCHAR12(0) WRF_CAT_GROUPCATALOGUE_GROUP
IV_OLDGeneral FlagFLAGCHAR1(0) FLAG
REF_EAN_LINEREF0(0)




Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!