Follow us on LinkedIn for your next SAP project

SAP Table CIF_MATLOC

Outbound Structure for Location Product

CIF_MATLOC (Outbound Structure for Location Product) 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 CIF_MATLOC to other SAP tables.

CIF_MATLOC table fields

Field Data element Checktable Datatype Length Decimals Possible values
METHOD
Method to be Executed During the Transfer of an Object
CIFMETHOD
CHAR
1 0
MATNR
Material Number
CIFMATNR
CHAR
40 0
LOCNO
Location
CIFLOCNO
CHAR
20 0
LOCTYPE
APO Location Type
CIFLOCTYPE
CHAR
4 0
PLANNR_PPS
Production Planner
PLANNR_PPS
CHAR
3 0
PLANNR_SNP
SNP Planner
PLANNR_SNP
CHAR
3 0
PLANNR_DEM
Sales Planner
PLANNR_DEM
CHAR
3 0
PLANNR_TRA
Transportation Planner
PLANNR_TRA
CHAR
3 0
MANOT
Indicator; material memo exists
MANOT
CHAR
1 0
MTVFP
Checking Group for Availability Check
MTVFP
CHAR
2 0
ATP_CHMOD
Check Mode
ATP_CHMOD
CHAR
3 0
WHATBOM
Indicator: Where should the BOM and task list be exploded?
APOWHATBOM
CHAR
1 0
DIBER
MRP Area Indicator
CIF_DIBER
CHAR
1 0
CONHAP
Consumption of Handling Capacity in Units of Volume
SNPCONHAP
QUAN
13 3
HUNIT
Unit
UNIT
UNIT
3 0
CONINP
Consumption of Storage Capacity per Unit of Material
SNPCONIMP
QUAN
13 3
IUNIT
Unit
UNIT
UNIT
3 0
KDMATID
Customer Material Number in APO
KDMAT_APO
CHAR
40 0
CHKHOR
ATP: Checking horizon in days
CIFCHKHOR
NUMC
3 0
CALIND
ATP: Indicator for checking horizon in APO
CALIND
CHAR
1 0
LSZKY
External Key for Lot Size Profile in APO
CIFLSZKY
CHAR
10 0
LSZTX
Description of Lot Size Profile
CIFLSZTX
CHAR
20 0
BSTFE
Fixed lot size
BSTFE
QUAN
13 3
BSTMI
Minimum Lot Size
BSTMI
QUAN
13 3
BSTMA
Maximum Lot Size
BSTMA
QUAN
13 3
BSTRF
Rounding value for purchase order quantity
BSTRF
QUAN
13 3
AUSSS
Assembly scrap in percent
AUSSS
DEC
5 2
RDPRF
Rounding Profile in APO
CIFRDPRF
CHAR
8 0
SVTTY
Target Days' Supply for Material
CIFSVTTY
DEC
11 0
CATGRP
Category Group
CIFCATGRP
CHAR
3 0
LGKND
Lot-size calculation in make-to-order production
LGKND
CHAR
1 0
SLLSZEXACT
Indicator: Exact Lot Size
CIFSLSLZEX
CHAR
1 0
SLLSZFIXED
Indicator: Fixed Lot Size
CIFSLSLZFX
CHAR
1 0
SLLSZRANGE
Indicator: Target Days' Supply for Lot Size Calculation
CIFSLSLZRA
CHAR
1 0
DPREX
SNP: Requirements Profile - External
CIFSNPDPRX
CHAR
10 0
DPRTX
SNP: Profile Description
CIFSNPDSCR
CHAR
20 0
D1HOR
SNP: Demand Horizon in Days (Area 1)
CIFSNPD1HR
DEC
3 0
D2HOR
SNP: Demand Horizon in Days (Area 2)
CIFSNPD2HR
DEC
3 0
FCSTH
SNP: Forecast Horizon in Days
CIFSNPFCST
DEC
3 0
PULLH
SNP: Deployment Horizon in Days (PULL)
CIFSNPPLLH
DEC
3 0
SPREX
SNP: Supply Profile - External
CIFSNPSPRX
CHAR
10 0
SPRTX
SNP: Profile Description
CIFSNPDSCR
CHAR
20 0
S1HOR
SNP: Demand Horizon in Days (Area 1)
CIFSNPD1HR
DEC
3 0
S2HOR
SNP: Demand Horizon in Days (Area 2)
CIFSNPD2HR
DEC
3 0
PRODH
SNP: Production Horizon in Days
CIFSNPPRDH
DEC
3 0
SHIPH
SNP: Stock Transfer Horizon in Days
CIFSNPSHPH
DEC
3 0
PUSHH
SNP: Deployment Horizon in Days (PUSH)
CIFSNPPSHH
DEC
3 0
DPLEX
SNP: External Deployment Profile
CIFSNPDPLX
CHAR
10 0
DPLTX
SNP: Profile Description
CIFSNPDSCR
CHAR
20 0
DPLFS
Fair Share Rule
CIFSNPDPFS
CHAR
2 0
DPLPU
Indicator: Push Distribution
CIFSNPDPPU
CHAR
1 0
RQMKY
External Number of Lot Size Profile in Matl Master Record
CIFRQMKY
CHAR
10 0
RQMTX
Description of PP Requirements Profile
CIFRQMTX
CHAR
20 0
VRMOD
Consumption mode
VRMOD
CHAR
1 0
VINT1
Consumption period: backward
VINT1
NUMC
3 0
VINT2
Consumption period: forward
VINT2
NUMC
3 0
STRA1
Planning strategy
STRA1
CHAR
2 0
SBDKZ
Dependent requirements ind. for individual and coll. reqmts
SBDKZ
CHAR
1 0
MISKZ
Mixed MRP indicator
MISKZ
CHAR
1 0
GRPRT
GR Processing Time
GRPRT
DEC
11 0
GIPRT
Goods Issue Processing Time
GIPRT
DEC
11 0
SAFTY
Safety Stock
CIFSAFTY
FLTP
16 16
RRP_TYPE
Planning Procedure for Production Planning
CIFRRPTYPE
CHAR
1 0
EKGRP
Purchasing Group
EKGRP
CHAR
3 0
BESKZ
Procurement Type
BESKZ
CHAR
1 0
LGRAD
Service level
LGRAD
DEC
3 1
PLIFZ
Planned Delivery Time in Days
PLIFZ
DEC
3 0
LSUOM
Unit of Measure of Lot Size
CIFLSUOM
UNIT
3 0
PRMTY
VMI Promotion Lead Time
CIFPRMTY
DEC
11 0
SCOST
Product-Dependent Storage Costs
CIFSCOST
DEC
13 3
VEGRP
VMI Purchasing Group
CIFVEGRP
CHAR
20 0
AT101
Character field of length 40
CHAR40
CHAR
40 0
AT102
30 Characters
CHAR30
CHAR
30 0
AT103
Char 20
CHAR20
CHAR
20 0
AT104
Character Field Length = 10
CHAR10
CHAR
10 0
AT105
Character Field Length = 10
CHAR10
CHAR
10 0
KOSCH_GRP
Allocation: Seq. Product Alloc. Procedures, Location-Dep.
CIF_KSCHGR
CHAR
18 0
KOSCH
Allocations: Product Allocations Procedure, Location-Dep.
CIF_KOSCH
CHAR
18 0
DIUOM
ATP: Unit of Measure for Display
CIF_DIUOM
UNIT
3 0
PRIO
Product Priority
CIF_PRIO
INT1
3 0
PRODF
SNP: Fix Production After Planning Period
CIF_SNPRDF
CHAR
1 0
SHIPF
SNP: Fix Shipments after Planning Period
CIF_SNPSHF
CHAR
1 0
PSPLI
Time Requirements Distribution Indicator (Period Split)
CIF_SNPSPL
CHAR
1 0
PEG_PST_MX
Maximum Duration of Backward Pegging Relationship
CIF_PEGPMX
DEC
11 0
PEG_PST_AL
Minimum Duration of Backward Pegging Relationship for Alert
CIF_PEGPAL
DEC
11 0
PEG_FUT_MX
Maximum Duration of Pegging Relationship
CIF_PEGFUT
DEC
11 0
UNETO
Underdelivery tolerance limit
UNETO
DEC
3 1
UEETO
Overdelivery tolerance limit
UEETO
DEC
3 1
GES_MNG_US
Flag: Consume Total Stock
CIF_BSTUSE
CHAR
1 0
BST_MNG_US
Flag: Consume Total Stock
CIF_BSTUSE
CHAR
1 0
EXPLDATE_F
Determination of BOM Explosion Date
CIF_EXPLDF
CHAR
1 0
PROC_COSTI
Procurement Costs for the Product, Format INT4
CIFPRCCSTI
INT4
10 0
ERHOR
Opening Period
CIFERHOR
DEC
11 0
FREIZ
Release period
CIFFREIZ
DEC
11 0
TBID_RPM
Time Buckets Profile ID
CIFTBID
CHAR
22 0
FIXHZ
Product-Specific Planning Time Fence
CIFFIXHZ
DEC
11 0
FIXDAT
Firming date
CIFFIXDAT
DATS
8 0
FIXTIM
Firming Time
CIFFIXTIM
TIMS
6 0
PACKAGE_ID
Heuristic Package
CIFHEUPKID
CHAR
12 0
HEUR_ID
Heuristic
CIFHEURID
CHAR
12 0
PARTOFPKGE
Part of Planning Package
CIFPRTOPKG
CHAR
1 0
PLAN_SELF
Object Planned with Solution Procedure
CIFFKTNFLG
CHAR
1 0
PEGFUTALRT
Minimum Duration for Forwards Pegging Relationship for Alert
CIFPGFUTAL
DEC
11 0
REORD
Reorder Point
CIFREORD
FLTP
16 16
REORD_DUR
Report Coverage
CIFREORDUR
DEC
11 0
TARGET_DUR
Target Range of Coverage (Target Days' Supply)
CIFTRGTDUR
DEC
11 0
REORD_METH
Selection of Reorder Point Procedure
CIFREORMTH
CHAR
1 0
SAFTY_METH
Switch: Maximum from Safety Stock/Time
CIFSFTYMTH
CHAR
1 0
MSDPSBMETH
Method for Calculating Safety Stock
CIFMSDPMTH
CHAR
2 0
MAXSTOCK
Maximum Storage Capacity for a Product
CIFMAXSTCK
FLTP
16 16
PROD_COST
Product Manufacturing Costs
CIFPRDCOST
INT4
10 0
PEG_STRAT
Pegging Strategy
CIFPGSTRAT
NUMC
2 0
SSPEN
Penalty for Falling Below Safety Stock
CIFSSPEN
DEC
13 3
SATNR
Cross-Plant Configurable Material
CIFSATNR
CHAR
40 0
SPHOR
Target Location Coverage Using Source Safety Stock Push
CIFSPHOR
DEC
3 0
COSEX
SNP: External Cost Function
CIFCOSEX
CHAR
10 0
TARGETMETH
Target Stock Level Procedure
CIFTARGMTH
CHAR
1 0
CONHAP_OUT
Consumption at Handling Cap. in Unit of Measure (Outbound)
CIFCONHOUT
QUAN
13 3
HUNIT_OUT
Unit of Measurement of Size
CIFUNIT
UNIT
3 0
LADGR
Loading Group
LADGR
CHAR
4 0
CNF_PROPAG
Quantity propagation by confirmations
CIFCNFPROP
INT1
3 0
CNF_COMPNT
Component adjustment by confirmation
CIFCNFCOMP
INT1
3 0
CNF_DURATN
Remaining Net Duration Adjustment by Confirmation
CIFCNFDURA
INT1
3 0
CNF_GMSYNC
Indicator: Synchronous Posting of Goods Issue
CIFCNFSYNC
CHAR
1 0
CUOBJ_TYPE
Category of External ID of Configuration (CUOBJ)
CIFCUOBJTY
CHAR
1 0
CUOBJ_ID
External Identification of CUOBJ
CIFCUOBJID
CHAR
32 0
KZKFG
Configurable Material
KZKFG
CHAR
1 0
PERVR
Period Indicator
CIFPERVR
CHAR
1 0
PER_AMOUNT
Number of Periods
CIFPERAZ
DEC
3 0
TSTRID
Planning Calendar for Periodical Lot Size Processing
CIFLOTTSID
CHAR
10 0
RQCOVERTYP
Receipt Date Determination with Period Factor
CIFRQCVTYP
DEC
4 3
RQCOVERFLG
Indicator for Determining Availability Date
CIFRQCVFLG
CHAR
1 0
NDCOSTWE
Costs Goods Receipt Network Design
CIFCOSTWE
FLTP
16 16
NDCOSTWA
Costs Goods Issue Network Design
CIFCOSTWA
FLTP
16 16
DTQKY
External Key for Delivery Time Quota Profile
CIFDTQTY
CHAR
20 0
RCRRCPHOR
ATP: Horizon for Initial Creation of Receipts in Cal. Days
CIFRRCPHOR
NUMC
3 0
GET_ALERTS
CIF: Determination/Restriction of Alerts for a Product
CIFGTALERT
CHAR
1 0
CONVH
CIF: PP/DS Horizon
CIFCONVH
DEC
3 0
CTHOR
CIF: Requirements Ascertainment Horizon in Calendar Days
CIFCTHOR
DEC
11 0
ND_STORDU
CIF: Network Design: Average Retention Period in Days
CIFNDSTORD
DEC
15 2
ND_MNPRD_W
CIF: Average Number of Production Operations per Week
CIFNDMNPRD
DEC
5 2
PROFID
CIF: Conversion Rule
CIFPROFID
CHAR
12 0
BDGRP
CIF: Consumption Group
CIFBDGRP
CHAR
10 0
PEG_WALR_F
CIF: Preferred Pegging Without Alerts
CIFPEGWALF
CHAR
1 0
PEG_CONCUR
CIF: Competing Pegging
CIFPEGCCUR
CHAR
1 0
PEG_LOT_TM
CIF: Time Interval for Split for Competing Pegging
CIFPEGLOTM
DEC
11 0
DSBPH
CIF: Deployment: Safety Stock Horizon
CIFDSBPH
DEC
3 0
AJHOZ
Adjustment Period
CIFAJHOZ
DEC
11 0
SUPPLPLANT
Location
CIFLOCNO
CHAR
20 0
SUPPLSLOC
Issuing Storage Location
CIFSUPSLOC
CHAR
4 0
SUPPLTYPE
Indicator for Procurement Category
CIFSUPTYPE
CHAR
1 0
PROC_COST
Procurement Costs for the Product, Format DEC13
CIFPRCCOST
DEC
13 3
PHEXT
SNP: Production Horizon Extension in Days
CIFSNPPHEX
DEC
3 0
FRTME
Production unit
FRTME
UNIT
3 0
TOLPRPL
DIMP: Percentage Tolerance Plus
CIFTOLPRPL
DEC
3 1
TOLPRMI
DIMP: Percentage Tolerance Minus
CIFTOLPRMI
DEC
3 1
LASTL
Last Lot Exact
CIFLASTL
CHAR
1 0
EARLYSHIP
Time Frame for Creation of Orders
CIFEARLSHP
NUMC
3 0
PACKAGETYP
Planning Package Type
HEUROBJTYP
NUMC
3 0
FEDEM
Relative Forecast Error of Demand (in %)
CIFFEDEM
DEC
4 1
FERLD
Relative Forecast Error of Replenishment Lead Time (in %)
CIFFERLD
DEC
4 1
FCCONSUM
Consider Forecast Horizon in the Past
SNPFCCONSM
CHAR
1 0
PIPRT
Pick/Pack Time
CIFPIPRT
DEC
11 0
TLPRT
Transportation Lead Time
CIFTLPRT
DEC
11 0
SNPCHKHOR
SNP: Checking Horizon in Days
CIFSNPCKHR
NUMC
3 0
PKZPRODH
Date Type
CIFPKZPRDH
CHAR
2 0
PKZSHIPH
Date Type
CIFPKZSHPH
CHAR
2 0
SHLFLIFELC
Planning with Location-Dependent Product Shelf Life
CIFSHFLFLC
CHAR
1 0
SHLFLIFEDR
Shelf Life
CIFSHFLFDR
DEC
11 0
MATURITDUR
Maturation Time
CIFMTRYDUR
DEC
11 0
SLFLFERQMI
Minimum Shelf Life Required: Location-Dependent
CFSFLFRQMI
DEC
11 0
SLFLFERQMX
Maximum Shelf Life Required: Location-Dependent
CFSFLFRQMX
DEC
11 0
RRPSELGRP
Planning Group
CIFRRPSLGP
CHAR
2 0
PLANNERPUR
Purchasing Planner
CIFPLNRPUR
CHAR
3 0
PLANNERVMI
VMI Planner
CIFPLNRVMI
CHAR
3 0
PLANNERSMI
SMI Planner
CIFPLNRSMI
CHAR
3 0
PRO_ORD
Do Not Cover Sales Promotion with VMI Customer Stock
CIFPRO_ORD
CHAR
1 0
PRO_LTP
Standard and Sales Promotion Deliveries Are Deliverable
CIFPRO_LTP
CHAR
1 0
OS_LIMIT
Alert Threshold for Out of Stock Alerts
CIFOSLIMIT
QUAN
13 3
DEADPILE
Indicator: Not Palletable
CIFDEADPIL
CHAR
1 0
COSTPROF
TLB Cost Profile
CIFCOSTPRF
CHAR
10 0
PSSFLAG
Parameter-Dependent ATP Safety Stock
CIFPSSFLAG
CHAR
1 0
FXPPRODSET
Fixed Pegging Retained for Product When Document Changed
CIFPGPRSET
CHAR
1 0
ATDSP
Category Group for ATD Quantity (Inflows)
CIFMAATDSP
CHAR
3 0
ATDDM
Category Group for ATD Quantity (Outflows)
CIFMAATDDM
CHAR
3 0
SNPLOTSTRA
Strategy for Forming Period Lot Sizes in SNP
CIFSNPLOTS
CHAR
1 0
SNPLOTBEG
Start Time for Grouping Period
CIFSNPLOTB
CHAR
1 0
MAABC
ABC Indicator
MAABC
CHAR
1 0
RPSTATUS
Replenishment Control of Location Product
CIFRPSTAT
CHAR
2 0
MEASGRBUY
Units of Measure Group
CIFMEASGRB
CHAR
4 0
PURTIME
Purchase Order Processing Time of Purchasing Department
CIFPURTIME
DEC
11 0
MINSTOCK
Minimum Target Warehouse Stock for a Product
CIFMINSTK
FLTP
16 16
SALESPRICE
Product Sales Price
CIFSDPRICE
DEC
13 3
BWSCL
Source of Supply
BWSCL
CHAR
1 0
SELLCLASS
Selling Class
CIFSELLCL
NUMC
1 0
TARGETSTK
Target Stock
CIFTARGSTK
FLTP
16 16
STOCKMULTI
Stock Multiple
CIFSTKMUL
FLTP
16 16
RELTIME
Release Time
CIFRELTIME
DEC
11 0
SEASON
Season Indicator
CIFSEASONF
CHAR
1 0
LISTSTATUS
Listing Status
CIFLSTSTAT
NUMC
1 0
PROFCST
Forecast Profile for F&R
CIFPROFCST
CHAR
10 0
PROREPL
Replenishment Profile for F&R
CIFPROREPL
CHAR
10 0
PROEXCP
Profile for Handling FRP Errors in F&R
CIFPROEXCP
CHAR
10 0
PROCL
Capital Tie-Up Profile for F&R
CIFPROCL
CHAR
10 0
LEADTMSHFT
Replenishment Lead Time Shift
CIFLDTMSHF
NUMC
2 0
VMIKOSCH
Product Allocations: VMI Product Allocation Procedure
CIFVMIKOSC
CHAR
18 0
VMIKOSCH_G
Product Allocations: VMI Sequence of Prod. Alloc. Procedures
CIFVMIKOSG
CHAR
18 0
HUGRP
Handling Unit Group
CIFHUGRP
CHAR
4 0
MAXCOVER
Maximum Coverage Period in Days
CIFMXCOVER
INT1
3 0
MAXCOVERUP
Upsizing Indicator
CIFMXCOVUP
CHAR
1 0
MIXTP
Mixing of Turn and Promotion on One Means of Transportation
CIFMIXTP
CHAR
1 0
USETP
Use of Turn Stock for Promotions
CIFUSETP
CHAR
1 0
PROM_PREDL
Advance Delivery of Promotions Allowed
CIFPROMPRD
CHAR
1 0
UNTKZ
Underdelivery Tolerance (for DIMP)
CIFUNTKZ
CHAR
1 0
CONVH_NEW
CIF: PP/DS Horizon
CIFCONVH_NEW
DEC
4 0
PEG_ST_QUALI
Inspection Stock Is Available
CIFPEGSTQUALI
CHAR
1 0
PEG_ST_RESTR
Restricted-Use Stock Is Available
CIFPEGSTRESTR
CHAR
1 0
PEG_ST_BLOCKED
Blocked Stock Is Available
CIFPEGSTBLOCKED
CHAR
1 0
PEG_ST_TR_LOC
Stock in Transfer Between Locations Is Available
CIFPEGSTTRLOC
CHAR
1 0
PEG_ST_TR_SLOC
Stock in Transfer Between Sublocations Is Available
CIFPEGSTTRSLOC
CHAR
1 0