1. Home
  2. Resources
  3. SAP Tables
  4. CIF_MATLOC - Outbound Structure for Location Product

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
METHOD Method to be Executed During the Transfer of an Object CIFMETHOD CHAR 1 0
D Delete (for example a schedule line)
C Change (for example a schedule line)
N New (for example a schedule line)
R Remove total object (for example deletion of an order)
A Add, Stock is Added or Reduced
M Maintain, New or Change but not Delete
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
X Yes
NULL No
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
NULL Lot-for-lot order quantity
1 Lot-for-lot with rounding
2 Lot size as in short-term period
SLLSZEXACT Indicator: Exact Lot Size CIFSLSLZEX CHAR 1 0
X Yes
NULL No
SLLSZFIXED Indicator: Fixed Lot Size CIFSLSLZFX CHAR 1 0
X Yes
NULL No
SLLSZRANGE Indicator: Target Days' Supply for Lot Size Calculation CIFSLSLZRA CHAR 1 0
X Yes
NULL No
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
1 Backward consumption only
2 Backward/forward consumption
3 Forward consumption only
4 Forward/backward consumption
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
NULL Individual and collective requirements
1 Individual requirements only
2 Collective requirements only
MISKZ Mixed MRP indicator MISKZ CHAR 1 0
1 Subassembly planning with final assembly
2 Gross requirements planning
3 Subassembly planning without final assembly
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
E In-house production
F External procurement
NULL No procurement
X Both procurement types
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
X true
- false
NULL unknown
SHIPF SNP: Fix Shipments after Planning Period CIF_SNPSHF CHAR 1 0
X true
- false
NULL unknown
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
X true
- false
NULL unknown
BST_MNG_US Flag: Consume Total Stock CIF_BSTUSE CHAR 1 0
X true
- false
NULL unknown
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
X Flag set. Event has occurred.
NULL Flag is Not Set
PLAN_SELF Object Planned with Solution Procedure CIFFKTNFLG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
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
X Yes
NULL No
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
X Yes
NULL No
CUOBJ_TYPE Category of External ID of Configuration (CUOBJ) CIFCUOBJTY CHAR 1 0
G ID Is a 32-Byte GUID
I ID Is a CUOBJ
CUOBJ_ID External Identification of CUOBJ CIFCUOBJID CHAR 32 0
KZKFG Configurable Material KZKFG CHAR 1 0
X Yes
NULL No
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
NULL Determine Network Alerts and Direct Alerts
1 Only Determine Direct Alerts
2 Do Not Determine Alerts
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
NULL No
X Yes
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
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
PRO_LTP Standard and Sales Promotion Deliveries Are Deliverable CIFPRO_LTP CHAR 1 0
X Yes
NULL No
OS_LIMIT Alert Threshold for Out of Stock Alerts CIFOSLIMIT QUAN 13 3
DEADPILE Indicator: Not Palletable CIFDEADPIL CHAR 1 0
X Yes
NULL No
COSTPROF TLB Cost Profile CIFCOSTPRF CHAR 10 0
PSSFLAG Parameter-Dependent ATP Safety Stock CIFPSSFLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
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
NULL Lot Lies in First Demand Period
1 Lot Always Lies in First Period
2 Lot Always Lies in Last Period
SNPLOTBEG Start Time for Grouping Period CIFSNPLOTB CHAR 1 0
NULL Start with First Period
X Start with Period in Which a Shortage Exists
MAABC ABC Indicator MAABC CHAR 1 0
RPSTATUS Replenishment Control of Location Product CIFRPSTAT CHAR 2 0
00 Inactive for automatic replenishment
01 Inactive for automatic replenishment due to cross-docking
09 Auto. replen. with man. trgt stck level and man. reord. pnt
10 Auto. replen. with man. trgt stock level and dyn. reord. pnt
11 Auto replen. with dyn. trgt stock level and dyn. reord. pnt
12 Only manual replenishment possible
13 Replenishment is manual, but can also be automatic
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
1
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
X Flag set. Event has occurred.
NULL Flag is Not Set
LISTSTATUS Listing Status CIFLSTSTAT NUMC 1 0
1
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
X Upsizing Allowed over Maximum Coverage Period
N No Upsizing Allowed
NULL Upsizing Allowed up to Maximum Coverage Period
MIXTP Mixing of Turn and Promotion on One Means of Transportation CIFMIXTP CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
USETP Use of Turn Stock for Promotions CIFUSETP CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
PROM_PREDL Advance Delivery of Promotions Allowed CIFPROMPRD CHAR 1 0
X Yes
NULL No
UNTKZ Underdelivery Tolerance (for DIMP) CIFUNTKZ CHAR 1 0
X Yes
NULL No
CONVH_NEW CIF: PP/DS Horizon CIFCONVH_NEW DEC 4 0
PEG_ST_QUALI Inspection Stock Is Available CIFPEGSTQUALI CHAR 1 0
NULL Not set
X Set
PEG_ST_RESTR Restricted-Use Stock Is Available CIFPEGSTRESTR CHAR 1 0
NULL Not set
X Set
PEG_ST_BLOCKED Blocked Stock Is Available CIFPEGSTBLOCKED CHAR 1 0
NULL Not set
X Set
PEG_ST_TR_LOC Stock in Transfer Between Locations Is Available CIFPEGSTTRLOC CHAR 1 0
NULL Not set
X Set
PEG_ST_TR_SLOC Stock in Transfer Between Sublocations Is Available CIFPEGSTTRSLOC CHAR 1 0
NULL Not set
X Set