FRET

Transparent Table Application Table
38 Fields 3 CDS Views

Assignment of Procurement to Issue Docs in Mdse Distribution

FRET is an SAP database table in S/4HANA. Assignment of Procurement to Issue Docs in Mdse Distribution. It contains 38 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FSH_ATP_VBBE_ALL view left_outer Read View on Table VBBE
fsh_atp_vbbe_p view left_outer Read View on Table VBBE - with Parameters
fsh_atp_vbbe_sel view left_outer View for ATP_VBBE fields

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY btypb btypb Proc. doc. cat.
KEY blnrb blnrb Doc. no., procrmnt
KEY bposb bposb Doc. item, proc.
KEY btypa btypa Doc. cat., issue
KEY blnra blnra Issue document no.
KEY bposa bposa Doc. item, issue
gablv gablv Business proc.
matnr matnr Material
pmenb pmenb Plnd qty, proc.
peinb peinb Unit plnd qty, proc
imngb imngb Act. qty. proc.
ieinb ieinb Unit, act.qty/proc.
pmena pmena Planned qty. iss
peina peina Unit, plnd qty, iss
imnga imnga Act. qty issue
ieina ieina Unit act.qty issue
bartv bartv Proc. method
mngcd mngcd CD quantity
eincd eincd Unit, CD quantity
mngft mngft FT quantity
einft einft Unit, FT quantity
vervf vervf Distribution method
mngvt mngvt Distr. qty
einvt einvt Unit, distrib. qty
mngpa mngpa PA quantity
einpa einpa Unit, PA quantity
werka werab Issuing plant
abntp abntp Recip. cat.
abnnr nrabn Recipient
kzfsa kzfsa Record error ID
kzvst kzvst Complete dist
stsve stsve Status
stman stman Processing status
stbes stbes Procurement status
erfdat erfda Created on
erfusr ernam Created By
erfzt erzet Time

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Assignment of Procurement to Issue Docs in Mdse Distribution
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FRET (
    MANDT,   -- Client [mandt]
    BTYPB,   -- Proc. doc. cat. [btypb]
    BLNRB,   -- Doc. no., procrmnt [blnrb]
    BPOSB,   -- Doc. item, proc. [bposb]
    BTYPA,   -- Doc. cat., issue [btypa]
    BLNRA,   -- Issue document no. [blnra]
    BPOSA,   -- Doc. item, issue [bposa]
    GABLV,   -- Business proc. [gablv]
    MATNR,   -- Material [matnr]
    PMENB,   -- Plnd qty, proc. [pmenb]
    PEINB,   -- Unit plnd qty, proc [peinb]
    IMNGB,   -- Act. qty. proc. [imngb]
    IEINB,   -- Unit, act.qty/proc. [ieinb]
    PMENA,   -- Planned qty. iss [pmena]
    PEINA,   -- Unit, plnd qty, iss [peina]
    IMNGA,   -- Act. qty issue [imnga]
    IEINA,   -- Unit act.qty issue [ieina]
    BARTV,   -- Proc. method [bartv]
    MNGCD,   -- CD quantity [mngcd]
    EINCD,   -- Unit, CD quantity [eincd]
    MNGFT,   -- FT quantity [mngft]
    EINFT,   -- Unit, FT quantity [einft]
    VERVF,   -- Distribution method [vervf]
    MNGVT,   -- Distr. qty [mngvt]
    EINVT,   -- Unit, distrib. qty [einvt]
    MNGPA,   -- PA quantity [mngpa]
    EINPA,   -- Unit, PA quantity [einpa]
    WERKA,   -- Issuing plant [werab]
    ABNTP,   -- Recip. cat. [abntp]
    ABNNR,   -- Recipient [nrabn]
    KZFSA,   -- Record error ID [kzfsa]
    KZVST,   -- Complete dist [kzvst]
    STSVE,   -- Status [stsve]
    STMAN,   -- Processing status [stman]
    STBES,   -- Procurement status [stbes]
    ERFDAT,  -- Created on [erfda]
    ERFUSR,  -- Created By [ernam]
    ERFZT,   -- Time [erzet]
    PRIMARY KEY (MANDT, BTYPB, BLNRB, BPOSB, BTYPA, BLNRA, BPOSA)
);

Learn More