SAP Table CIF_R3LOT

Inspection Lots for APO in Internal Format

CIF_R3LOT (Inspection Lots for APO in Internal Format) 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_R3LOT to other SAP tables.

Source: CIF_R3LOT (Inspection Lots for APO in Internal Format)

CIF_R3LOT table fields

Field Data element Checktable Datatype Length Decimals
PRUEFLOS Inspection Lot Number QPLOS NUMC 12 0
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 MATNR CHAR 18 0
WERKVORG Plant Where Stock for Inspection Lot Is Held QWERKVORG CHAR 4 0
LOSMENGE Inspection Lot Quantity QLOSMENGE QUAN 13 3
LMENGEZUB Quantity That Must Be Posted QLMENGEZUB QUAN 13 3
MENGENEINH Base Unit of Measure for The Inspection Lot Quantity QLOSMENGEH UNIT 3 0
ERSTELDAT Date on Which the Data Record Was Created QDATUMERST DATS 8 0
ERSTELZEIT Time of Lot Creation QERSTEZEIT TIMS 6 0
PASTRTERM Inspection Start Date QPRSTART DATS 8 0
PASTRZEIT Inspection Start Time QSTARTZEIT TIMS 6 0
PAENDTERM End Date of the Inspection QPRENDE DATS 8 0
PAENDZEIT Inspection End Time QENDEZEIT TIMS 6 0
CHARG Batch Number CHARG_D CHAR 10 0
LAGORTVORG Storage Location for Inspection Lot Stock QLGORTVORG CHAR 4 0
STATUSREL Status: Released CIFSTATREL CHAR 1 0
NULL Undefined (No Value Set)
1 Created
2 Partially Released
3 Released
ATPCAT ATP Category in APO CIFATPCAT CHAR 2 0
SPECIALSTO Special Stock Indicator CIFSPECSTO CHAR 1 0
SPECSTOKEY Key for Special Stock Section CIFSSKEY CHAR 16 0
SSKEYSYST Logical system LOGSYS CHAR 10 0
SPECSTOEXT External Display of Account Assignment Object CIFSSEXT CHAR 40 0
PRED_AUFNR Order Number AUFNR CHAR 12 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
HERKUNFT Inspection Lot Origin QHERK CHAR 2 0
CANCELLED Status Cancelled QSTATCNL CHAR 1 0
NULL Indicator is not set
X Indicator is set