C_GRC_ProdPlantChangeLog

Product plant change log | view: CGRCPRODPLNTCHG | Extraction: Not supported | Component: Information System
Tables used: CDHDR, MARA, MARA, MARC, CDPOS
Column Name Description
Product FK Product Number
Plant FK Plant
ChangeDocument FK Change Number of Document
ChangeDocDatabaseTableField Field Name
ChangeDocItemChangeType Type of Change Show values
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
MinimumLotSizeQuantity Minimum Lot Size
MaximumLotSizeQuantity Maximum Lot Size
FixedLotSizeQuantity Fixed lot size
SafetyStockQuantity Safety Stock
Column Name Description
ChangeDocCreationDate Creation Date of the Change Document
ProfileValidityStartDate Date from Which the Plant-Specific Material Status Is Valid
ConsumptionRefUsageEndDate To date of the material to be copied for consumption
Column Name Description
ChangeDocItemChangeType Type of Change Show values
PeriodType Period Indicator Show values
IsCoProduct Indicator: Material can be co-product Show values
HasPostToInspectionStock Has Post to Inspection Stock Show values
IsBatchManagementRequired Batch Management Requirement Indicator for Plant Show values
IsNegativeStockAllowed Negative stocks allowed in plant Show values
IsPurgAcrossPurgGroup Purchasing Across Purchasing Group Show values
IsInternalBatchManaged Batch management indicator (internal) Show values
ProductCFOPCategory Material CFOP category Show values
ProductIsExciseTaxRelevant Excise Tax Relevance Indicator Show values
ProcurementType Procurement Type Show values
ProductIsCriticalPrt Indicator: Critical part Show values
OriglBatchManagementIsRequired Indicator for Original Batch Management Show values
IsMarkedForDeletion Flag Material for Deletion at Plant Level Show values
Column Name Description Domain name
LastChangedByUser Changed By User UNAME
ChangeDocNewFieldValue New contents of changed field
ChangeDocPreviousFieldValue Old contents of changed field
ProductExternalID External Representation of Material Number CHAR40
ProfitCenter Profit Center PRCTR
GoodsReceiptDuration Goods receipt processing time in days DEC3
MaintenanceStatusName Maintenance status PSTAT
UnderDelivToleranceLimit Underdelivery tolerance limit DEC2_1
OverDelivToleranceLimit Overdelivery tolerance limit DEC2_1
ConsumptionQtyMultiplier Multiplier for reference material for consumption DEC2_2
GoodIssueProcessingDays Goods Issue Processing Time in Days DEC3
PlannedDeliveryDurationInDays Planned Delivery Time in Days DEC3
ProductConfiguration Internal object number CUOBJ
ChangeDocObjectClass Object class OBJECTCL
DatabaseTable Table Name AS4TAB
Master Data Relations Join Conditions
Value Table for ABC Indicator
  • Client
  • ABC Indicator
  • C_GRC_PRODPLANTCHANGELOG.MANDT == TMABC.MANDT
  • C_GRC_PRODPLANTCHANGELOG.ABCINDICATOR == TMABC.MAABC
Checking Group for Availability Check
  • Checking Group for Availability Check
  • Client
  • C_GRC_PRODPLANTCHANGELOG.AVAILABILITYCHECKTYPE == TMVF.MTVFP
  • C_GRC_PRODPLANTCHANGELOG.MANDT == TMVF.MANDT
Unit of Measure
  • Client
  • Base Unit of Measure
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T006.MANDT
  • C_GRC_PRODPLANTCHANGELOG.BASEUNIT == T006.MSEHI
Currency
  • Change documents, referenced currency
  • Client
  • C_GRC_PRODPLANTCHANGELOG.CHANGEDOCNEWCURRENCY == TCURC.WAERS
  • C_GRC_PRODPLANTCHANGELOG.MANDT == TCURC.MANDT
Currency
  • Change documents, referenced currency
  • Client
  • C_GRC_PRODPLANTCHANGELOG.CHANGEDOCPREVIOUSCURRENCY == TCURC.WAERS
  • C_GRC_PRODPLANTCHANGELOG.MANDT == TCURC.MANDT
Configurable material
  • Client
  • Configurable material
  • C_GRC_PRODPLANTCHANGELOG.MANDT == MARA.MANDT
  • C_GRC_PRODPLANTCHANGELOG.CONFIGURABLEPRODUCT == MARA.MATNR
Consignment Control
  • Client
  • Consignment Control
  • Consignment Control
Reference plant for consumption
  • Client
  • Reference plant for consumption
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T001W.MANDT
  • C_GRC_PRODPLANTCHANGELOG.CONSUMPTIONREFERENCEPLANT == T001W.WERKS
Reference material for consumption
  • Client
  • Reference material for consumption
  • C_GRC_PRODPLANTCHANGELOG.MANDT == MARA.MANDT
  • C_GRC_PRODPLANTCHANGELOG.CONSUMPTIONREFERENCEPRODUCT == MARA.MATNR
Foreign trade: control code
  • ?
  • Client
  • Control code for consumption taxes in foreign trade
  • C_GRC_PRODPLANTCHANGELOG.[column in domain "LAND1"] == T604F.LAND1
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T604F.MANDT
  • C_GRC_PRODPLANTCHANGELOG.CONSUMPTIONTAXCTRLCODE == T604F.STEUC
Country/Region of Origin of Product
  • Country/Region of Origin of Product
  • Client
  • C_GRC_PRODPLANTCHANGELOG.COUNTRYOFORIGIN == T005.LAND1
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T005.MANDT
Distribution profile of material in plant
  • Distribution profile of material in plant
  • Client
  • C_GRC_PRODPLANTCHANGELOG.DISTRCNTRDISTRIBUTIONPROFILE == TMFPF.FPRFM
  • C_GRC_PRODPLANTCHANGELOG.MANDT == TMFPF.MANDT
Period version
  • Client
  • Fiscal Year Variant
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T009.MANDT
  • C_GRC_PRODPLANTCHANGELOG.FISCALYEARVARIANT == T009.PERIV
Unit of measure
  • Client
  • Unit of issue
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T006.MANDT
  • C_GRC_PRODPLANTCHANGELOG.GOODSISSUEUNIT == T006.MSEHI
Consignment Control
  • Client
  • Consignment Control
  • Consignment Control
Material freight group
  • Client
  • Material freight group
  • C_GRC_PRODPLANTCHANGELOG.MANDT == TMFG.MANDT
  • C_GRC_PRODPLANTCHANGELOG.MATERIALFREIGHTGROUP == TMFG.MFRGR
MRP controller
  • MRP Controller
  • Client
  • Plant
  • C_GRC_PRODPLANTCHANGELOG.MRPRESPONSIBLE == T024D.DISPO
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T024D.MANDT
  • C_GRC_PRODPLANTCHANGELOG.PLANT == T024D.WERKS
MRP type
  • Client
  • MRP Type
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T438A.MANDT
  • C_GRC_PRODPLANTCHANGELOG.MRPTYPE == T438A.DISMM
Reference Material for Original Batches
  • Reference Material for Original Batches
  • Client
  • C_GRC_PRODPLANTCHANGELOG.ORIGINALBATCHREFERENCEMATERIAL == MARA.MATNR
  • C_GRC_PRODPLANTCHANGELOG.MANDT == MARA.MANDT
Plant
  • Client
  • Plant
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T001W.MANDT
  • C_GRC_PRODPLANTCHANGELOG.PLANT == T001W.WERKS
Product Number
  • Client
  • Product Number
  • C_GRC_PRODPLANTCHANGELOG.MANDT == MARA.MANDT
  • C_GRC_PRODPLANTCHANGELOG.PRODUCT == MARA.MATNR
Material Group
  • Product Group
  • Client
  • C_GRC_PRODPLANTCHANGELOG.PRODUCTGROUP == T023.MATKL
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T023.MANDT
Production Storage Location
  • Issue Storage Location
  • Client
  • Plant
  • C_GRC_PRODPLANTCHANGELOG.PRODUCTIONINVTRYMANAGEDLOC == T001L.LGORT
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T001L.MANDT
  • C_GRC_PRODPLANTCHANGELOG.PLANT == T001L.WERKS
Production Scheduling Profile
  • Client
  • Production Scheduling Profile
  • Plant
  • C_GRC_PRODPLANTCHANGELOG.MANDT == TCO43.MANDT
  • C_GRC_PRODPLANTCHANGELOG.PRODUCTIONSCHEDULINGPROFILE == TCO43.CO_PRODPRF
  • C_GRC_PRODPLANTCHANGELOG.PLANT == TCO43.WERKS
Work scheduler group
  • Production Supervisor
  • Client
  • Plant
  • C_GRC_PRODPLANTCHANGELOG.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T024F.MANDT
  • C_GRC_PRODPLANTCHANGELOG.PLANT == T024F.WERKS
Logistics handling group for workload calculation
  • Client
  • Logistics handling group for workload calculation
  • C_GRC_PRODPLANTCHANGELOG.MANDT == TLOG.MANDT
  • C_GRC_PRODPLANTCHANGELOG.PRODUCTLOGISTICSHANDLINGGROUP == TLOG.LOGGR
Product Type
  • Client
  • Product Type
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T134.MANDT
  • C_GRC_PRODPLANTCHANGELOG.PRODUCTTYPE == T134.MTART
Plant-Specific Material Status
  • Plant-Specific Material Status
  • Client
  • C_GRC_PRODPLANTCHANGELOG.PROFILECODE == T141.MMSTA
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T141.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T024.MANDT
  • C_GRC_PRODPLANTCHANGELOG.PURCHASINGGROUP == T024.EKGRP
Region of Origin
  • Country/Region of Origin of Product
  • Client
  • Region of Origin
  • C_GRC_PRODPLANTCHANGELOG.COUNTRYOFORIGIN == T005S.LAND1
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T005S.MANDT
  • C_GRC_PRODPLANTCHANGELOG.REGIONOFORIGIN == T005S.BLAND
Serial Number Profile
  • Serial Number Profile
  • Client
  • C_GRC_PRODPLANTCHANGELOG.SERIALNUMBERPROFILE == T377P.SERAIL
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T377P.MANDT
Source of Supply
  • Client
  • Source of Supply
  • C_GRC_PRODPLANTCHANGELOG.MANDT == TMBW1.MANDT
  • C_GRC_PRODPLANTCHANGELOG.SOURCEOFSUPPLYCATEGORY == TMBW1.BWSCL
Special procurement key
  • Client
  • Special procurement type
  • Plant
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T460A.MANDT
  • C_GRC_PRODPLANTCHANGELOG.SPECIALPROCUREMENTTYPE == T460A.SOBSL
  • C_GRC_PRODPLANTCHANGELOG.PLANT == T460A.WERKS
Stock determination group
  • Stock determination group
  • Client
  • Plant
  • C_GRC_PRODPLANTCHANGELOG.STOCKDETERMINATIONGROUP == T434G.EPRIO
  • C_GRC_PRODPLANTCHANGELOG.MANDT == T434G.MANDT
  • C_GRC_PRODPLANTCHANGELOG.PLANT == T434G.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Units of measure group
  • Client
  • ?
  • Unit of Measure Group
  • C_GRC_PRODPLANTCHANGELOG.MANDT == TWMEG.MANDT
  • C_GRC_PRODPLANTCHANGELOG.[column in domain "LRMEI"] == TWMEG.MEINS
  • C_GRC_PRODPLANTCHANGELOG.PRODUCTUNITGROUP == TWMEG.MEGRU