1. Home
  2. Resources
  3. SAP Tables
  4. FRET - Assignment of Procurement to Issue Docs in Mdse Distribution

SAP Table FRET

Assignment of Procurement to Issue Docs in Mdse Distribution

FRET (Assignment of Procurement to Issue Docs in Mdse Distribution) 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 FRET to other SAP tables.

FRET table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BTYPB Procurement document category BTYPB CHAR 1 0
1 Purchase Order
2 Sales Order
3 Delivery
4 Putaway in distribution center
9 Entry for incomplete distribution
BLNRB Document number, procurement BLNRB CHAR 10 0
BPOSB Document item, procurement BPOSB NUMC 6 0
BTYPA Category of issue document, Merchandise Distribution BTYPA CHAR 1 0
1 Purchase Order
2 Sales Order
3 Delivery
4 Putaway in distribution center
9 Entry for incomplete distribution
BLNRA Issue document number BLNRA CHAR 10 0
BPOSA Document item, issue BPOSA NUMC 6 0
GABLV Business process GABLV CHAR 2 0
01 Push
02 Pull
03 Returns
NULL Defaults
MATNR Material Number MATNR MARA CHAR 18 0
PMENB Planned quantity for procurement PMENB QUAN 13 3
PEINB Unit of measure, planned quantity for procurement PEINB T006 UNIT 3 0
IMNGB Actual quantity, procurement IMNGB QUAN 13 3
IEINB Unit of measure, actual quantity, procurement IEINB T006 UNIT 3 0
PMENA Planned qty for issue PMENA QUAN 13 3
PEINA Unit of measure for planned quantity, issue PEINA T006 UNIT 3 0
IMNGA Act. qty issue IMNGA QUAN 13 3
IEINA Unit of measure for actual quantity issued IEINA T006 UNIT 3 0
BARTV Processing method for distribution BARTV CHAR 1 0
1 Putaway
2 Cross-docking
3 Flow-through
4 Cross-docking/flow-through
5 Cross-docking/putaway
MNGCD Quantity for cross-docking MNGCD QUAN 13 3
EINCD Unit of measure for cross-docking quantity EINCD T006 UNIT 3 0
MNGFT Quantity for flow-through MNGFT QUAN 13 3
EINFT Unit of measure for flow-through quantity EINFT T006 UNIT 3 0
VERVF Distribution method for distribution VERVF CHAR 1 0
1 Recipient-driven distribution
2 Merchandise-driven distribution
MNGVT Distributed quantity MNGVT QUAN 13 3
EINVT Unif of measure for distributed quantity EINVT T006 UNIT 3 0
MNGPA Quantity for putaway MNGPA QUAN 13 3
EINPA Unit of measure for putaway quantity EINPA T006 UNIT 3 0
WERKA Issuing plant WERAB T001W CHAR 4 0
ABNTP Recipient category ABNTP CHAR 2 0
01 Plant
02 Customer
ABNNR Number of recipient NRABN CHAR 10 0
KZFSA Indicates record containing errors KZFSA CHAR 1 0
NULL Not Selected
X Selected
KZVST Indicates that distribution is complete KZVST CHAR 1 0
NULL Not Selected
X Selected
STSVE General status STSVE CHAR 1 0
NULL Released for further processing
1 Blocked
2 Completed
STMAN Indicates processing status STMAN CHAR 1 0
NULL No change
1 Manually changed
STBES Procurement status STBES CHAR 1 0
1 Procurement complete
NULL Procurement open
ERFDAT Created on ERFDA DATS 8 0
ERFUSR Name of Person who Created the Object ERNAM CHAR 12 0
ERFZT Entry time ERZET TIMS 6 0
LGORT Storage Location LGORT_D CHAR 4 0
LGNUM Warehouse Number / Warehouse Complex LGNUM T300 CHAR 3 0
MD_ADJUST_EXEC Sytems of Adjustment and Execution of Merchandise Distributn DE_WMD_ADJUST_EXECUTE CHAR 1 0
1 Adjust Distribution in ERP, Execute in External WMS
2 Adjust Distribution and Execute in External WMS
KZVAS Indicates relevant SLS with sub-items FRM_VAS_REL CHAR 1 0
NULL Not Selected
X Selected
IND_UC_SPLIT Only one End Customer per Item DE_WMD_UC_SPLIT CHAR 1 0
X TRUE
NULL FALSE
UEBPO Higher-Level Item in Purchasing Documents UEBPO NUMC 5 0
MD_PROCESS_METH Process Method for Merchandise Distribution DE_WMD_PROCESS_METHOD CHAR 3 0
WPA Putaway
WCD Cross-Docking
WCV Cross-Docking with Pre-Packing
WCP Cross-Docking / Putaway
WCR Recipient-Driven Cross-Docking / Flow-Through
WCM Merchandise-Driven Cross-Docking / Flow-Through
WFR Recipient-Driven Flow-Through
WFM Merchandise-Driven Flow-Through
MD_PROCESS_ID Cross-Docking Process Number /SPE/CD_PROCESS CHAR 10 0

FRET foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FRET EINCD FRET MANDT T006 Units of Measurement MANDT
FRET EINCD FRET EINCD T006 Units of Measurement MSEHI
FRET EINFT FRET MANDT T006 Units of Measurement MANDT
FRET EINFT FRET EINFT T006 Units of Measurement MSEHI
FRET EINPA FRET EINPA T006 Units of Measurement MSEHI
FRET EINPA FRET MANDT T006 Units of Measurement MANDT
FRET EINVT FRET MANDT T006 Units of Measurement MANDT
FRET EINVT FRET EINVT T006 Units of Measurement MSEHI
FRET IEINA FRET MANDT T006 Units of Measurement MANDT
FRET IEINA FRET IEINA T006 Units of Measurement MSEHI
FRET IEINB FRET IEINB T006 Units of Measurement MSEHI
FRET IEINB FRET MANDT T006 Units of Measurement MANDT
FRET LGNUM SYST MANDT T300 WM Warehouse Numbers MANDT
FRET LGNUM FRET LGNUM T300 WM Warehouse Numbers LGNUM
FRET MANDT FRET MANDT T000 Clients MANDT
FRET MATNR FRET MANDT MARA General Material Data MANDT
FRET MATNR FRET MATNR MARA General Material Data MATNR
FRET PEINA FRET MANDT T006 Units of Measurement MANDT
FRET PEINA FRET PEINA T006 Units of Measurement MSEHI
FRET PEINB FRET MANDT T006 Units of Measurement MANDT
FRET PEINB FRET PEINB T006 Units of Measurement MSEHI
FRET WERKA FRET MANDT T001W Plants/Branches MANDT
FRET WERKA FRET WERKA T001W Plants/Branches WERKS