C_NgtvStockAllowedProduct

Product with negative stock allowed | view: CGRCNGTVSTKPROD | Extraction: Not supported | Component: Information System
Tables used: CDHDR, MARA, MARA, MARC, CDPOS
Column Name Description
Product FK Product Number
Plant FK Plant
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
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
ProductExternalID External Representation of Material Number CHAR40
LastChangedByUser Changed By User UNAME
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
Master Data Relations Join Conditions
Value Table for ABC Indicator
  • ABC Indicator
  • Client
  • C_NGTVSTOCKALLOWEDPRODUCT.ABCINDICATOR == TMABC.MAABC
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == TMABC.MANDT
Checking Group for Availability Check
  • Client
  • Checking Group for Availability Check
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == TMVF.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.AVAILABILITYCHECKTYPE == TMVF.MTVFP
Unit of Measure
  • Client
  • Base Unit of Measure
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T006.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.BASEUNIT == T006.MSEHI
Configurable material
  • Client
  • Configurable material
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == MARA.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.CONFIGURABLEPRODUCT == MARA.MATNR
Consignment Control
  • Consignment Control
  • Consignment Control
  • Client
Reference plant for consumption
  • Client
  • Reference plant for consumption
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T001W.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.CONSUMPTIONREFERENCEPLANT == T001W.WERKS
Reference material for consumption
  • Client
  • Reference material for consumption
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == MARA.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.CONSUMPTIONREFERENCEPRODUCT == MARA.MATNR
Foreign trade: control code
  • Client
  • ?
  • Control code for consumption taxes in foreign trade
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T604F.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.[column in domain "LAND1"] == T604F.LAND1
  • C_NGTVSTOCKALLOWEDPRODUCT.CONSUMPTIONTAXCTRLCODE == T604F.STEUC
Country/Region of Origin of Product
  • Client
  • Country/Region of Origin of Product
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T005.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.COUNTRYOFORIGIN == T005.LAND1
Distribution profile of material in plant
  • Distribution profile of material in plant
  • Client
  • C_NGTVSTOCKALLOWEDPRODUCT.DISTRCNTRDISTRIBUTIONPROFILE == TMFPF.FPRFM
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == TMFPF.MANDT
Period version
  • Client
  • Fiscal Year Variant
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T009.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.FISCALYEARVARIANT == T009.PERIV
Unit of measure
  • Client
  • Unit of issue
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T006.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.GOODSISSUEUNIT == T006.MSEHI
Consignment Control
  • Consignment Control
  • Consignment Control
  • Client
Material freight group
  • Client
  • Material freight group
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == TMFG.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.MATERIALFREIGHTGROUP == TMFG.MFRGR
MRP controller
  • MRP Controller
  • Client
  • Plant
  • C_NGTVSTOCKALLOWEDPRODUCT.MRPRESPONSIBLE == T024D.DISPO
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T024D.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.PLANT == T024D.WERKS
MRP type
  • Client
  • MRP Type
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T438A.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.MRPTYPE == T438A.DISMM
Reference Material for Original Batches
  • Client
  • Reference Material for Original Batches
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == MARA.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.ORIGINALBATCHREFERENCEMATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T001W.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.PLANT == T001W.WERKS
Product Number
  • Client
  • Product Number
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == MARA.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.PRODUCT == MARA.MATNR
Material Group
  • Client
  • Product Group
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T023.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.PRODUCTGROUP == T023.MATKL
Production Storage Location
  • Client
  • Issue Storage Location
  • Plant
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T001L.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.PRODUCTIONINVTRYMANAGEDLOC == T001L.LGORT
  • C_NGTVSTOCKALLOWEDPRODUCT.PLANT == T001L.WERKS
Production Scheduling Profile
  • Production Scheduling Profile
  • Client
  • Plant
  • C_NGTVSTOCKALLOWEDPRODUCT.PRODUCTIONSCHEDULINGPROFILE == TCO43.CO_PRODPRF
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == TCO43.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.PLANT == TCO43.WERKS
Work scheduler group
  • Client
  • Production Supervisor
  • Plant
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T024F.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • C_NGTVSTOCKALLOWEDPRODUCT.PLANT == T024F.WERKS
Logistics handling group for workload calculation
  • Logistics handling group for workload calculation
  • Client
  • C_NGTVSTOCKALLOWEDPRODUCT.PRODUCTLOGISTICSHANDLINGGROUP == TLOG.LOGGR
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == TLOG.MANDT
Product Type
  • Client
  • Product Type
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T134.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.PRODUCTTYPE == T134.MTART
Plant-Specific Material Status
  • Client
  • Plant-Specific Material Status
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T141.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.PROFILECODE == T141.MMSTA
Purchasing Group
  • Client
  • Purchasing Group
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T024.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.PURCHASINGGROUP == T024.EKGRP
Region of Origin
  • Client
  • Region of Origin
  • Country/Region of Origin of Product
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T005S.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.REGIONOFORIGIN == T005S.BLAND
  • C_NGTVSTOCKALLOWEDPRODUCT.COUNTRYOFORIGIN == T005S.LAND1
Serial Number Profile
  • Serial Number Profile
  • Client
  • C_NGTVSTOCKALLOWEDPRODUCT.SERIALNUMBERPROFILE == T377P.SERAIL
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T377P.MANDT
Source of Supply
  • Client
  • Source of Supply
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == TMBW1.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.SOURCEOFSUPPLYCATEGORY == TMBW1.BWSCL
Special procurement key
  • Client
  • Special procurement type
  • Plant
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T460A.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.SPECIALPROCUREMENTTYPE == T460A.SOBSL
  • C_NGTVSTOCKALLOWEDPRODUCT.PLANT == T460A.WERKS
Stock determination group
  • Stock determination group
  • Client
  • Plant
  • C_NGTVSTOCKALLOWEDPRODUCT.STOCKDETERMINATIONGROUP == T434G.EPRIO
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == T434G.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.PLANT == T434G.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Units of measure group
  • Client
  • Unit of Measure Group
  • ?
  • C_NGTVSTOCKALLOWEDPRODUCT.MANDT == TWMEG.MANDT
  • C_NGTVSTOCKALLOWEDPRODUCT.PRODUCTUNITGROUP == TWMEG.MEGRU
  • C_NGTVSTOCKALLOWEDPRODUCT.[column in domain "LRMEI"] == TWMEG.MEINS