Which CDS Views use AFRU?

AFRU is used by 7 CDS view(s), including: E_MaintenanceOrderConfirmation, E_OrderConfirmation, I_ConfirmationCount, I_OrderConfirmationBasic, I_ProjNtwkActivityConfirmation, P_MaintenanceOrderConfirmation, P_MfgOrderOperationConf.

How many fields does AFRU have?

AFRU has 141 fields. Key fields: mandt, rueck, rmzhl.

AFRU

Transparent Table Application Table

141 Fields 7 CDS Views

Order Confirmations

AFRU is an SAP database table in S/4HANA. Order Confirmations. It contains 141 fields. 7 CDS views read from this table.

CDS Views using this table (7)

View	Type	Join	VDM	Description
E_MaintenanceOrderConfirmation	view	from	EXTENSION	Maint Order Confirmation - Extension
E_OrderConfirmation	view	from	EXTENSION	Order Confirmation - Extension
I_ConfirmationCount	view_entity	from	BASIC	Confirmation Count
I_OrderConfirmationBasic	view	from	BASIC	Order Confirmation Basic
I_ProjNtwkActivityConfirmation	view	from	BASIC	Project Network Activity Confirmation
P_MaintenanceOrderConfirmation	view	from	BASIC	Maintenance Order Confirmation
P_MfgOrderOperationConf	view	from	BASIC

Fields (141)

Key	Field	Data Element	Description
KEY	mandt	mandt	Client
KEY	rueck	co_rueck	Confirmation
KEY	rmzhl	co_rmzhl	Counter
	ersda	ru_ersda	Entry Date
	ernam	ru_ernam	Entered by User
	laeda	laeda	Last Change
	aenam	aenam	Changed By
	budat	buchdatum	Posting Date
	arbid	objektid	Object ID
	werks	werks_d	Plant
	ltxa1	co_rtext	Confirm. text
	txtsp	spras	Language
	iserh	iserh	Conf Break Time
	zeier	dzeier	Break Time Unit
	ile01	co_ismngeh	Unit/activity
	ism01	ru_ismng	Acty to Confirm
	ile02	co_ismngeh	Unit/activity
	ism02	ru_ismng	Acty to Confirm
	ile03	co_ismngeh	Unit/activity
	ism03	ru_ismng	Acty to Confirm
	ile04	co_ismngeh	Unit/activity
	ism04	ru_ismng	Acty to Confirm
	ile05	co_ismngeh	Unit/activity
	ism05	ru_ismng	Acty to Confirm
	ile06	co_ismngeh	Unit/activity
	ism06	ru_ismng	Acty to Confirm
	abarb	co_abarb	Processing %
	ismnw	ismnw	Actual work
	ismne	arbeite	Unit for work
	learr	learr	Activity Type
	idaur	idaur	Actual Duration
	idaue	idaure	Un/actual dur.
	zcode	dzcode	Std value code
	loart	lohnart	Wage type
	qualf	qualf	Suitability
	anzma	anzms	No. employees
	logrp	lohngrp	Wage Group
	gmnga	ru_gmnga	Confd Yield Quantity
	lmnga	ru_lmnga	Yield Quantity
	xmnga	ru_xmnga	Scrap Quantity
	gmein	meins	Base Unit
	meinh	ru_vorme	Confirmation Unit
	grund	co_agrnd	Reason
	pernr	co_pernr	Personnel no.
	isdd	ru_isdd	Start Execution
	isdz	ru_isdz	Act. Start Time
	ierd	ru_ierd	Finish Setup
	ierz	ru_ierz	Finish Setup
	isbd	ru_isbd	Start of Proc.
	isbz	ru_isbz	Start of Proc.
	iebd	ru_iebd	Fin. Processing
	iebz	ru_iebz	Fin. Processing
	isad	ru_isad	Start Teardown
	isaz	ru_isaz	Start Teardown
	iedd	ru_iedd	Finish Execut.
	iedz	ru_iedz	Actual finish
	pedd	co_pedd	Forecast finish
	pedz	co_pedz	Forecast End
	wablnr	mblnr	Material Doc.
	weblnr	weblnr	Doc.gds mvt err
	aueru	aueru_vs	Final Confirmtn
	ausor	ausbu	Clear Open Res.
	stndr	stndr	Standard conf.
	manur	manur	Type Confirm.
	meilr	meilr	Milestone Conf.
	aufpl	co_aufpl	Plan No.f.Oper.
	aplzl	co_aplzl	Counter
	aufnr	aufnr	Order
	aplfl	plnfolge	Sequence
	vornr	vornr	Activity
	sumnr	sumkntnr	Sup. Op. Node
	ofm01	co_schaetz	Forecast Value
	ofe01	ru_progvge	Std value unit
	lek01	co_leikz	No Remain. Act.
	ofm02	co_schaetz	Forecast Value
	ofe02	ru_progvge	Std value unit
	lek02	co_leikz	No Remain. Act.
	ofm03	co_schaetz	Forecast Value
	ofe03	ru_progvge	Std value unit
	lek03	co_leikz	No Remain. Act.
	ofm04	co_schaetz	Forecast Value
	ofe04	ru_progvge	Std value unit
	lek04	co_leikz	No Remain. Act.
	ofm05	co_schaetz	Forecast Value
	ofe05	ru_progvge	Std value unit
	lek05	co_leikz	No Remain. Act.
	ofm06	co_schaetz	Forecast Value
	ofe06	ru_progvge	Std value unit
	lek06	co_leikz	No Remain. Act.
	ofmnw	remnw	Remaining work
	ofmne	ofmne	Unit Remng Work
	leknw	leknw	No Remain. Work
	odaur	odaur	Remaining dur.
	odaue	odaue	Unit/remaining
	stokz	co_stokz	Reversed
	stzhl	co_stzhl	Cancelled Conf.
	smeng	mgvrg	Operation Qty
	rueck_mst	co_rueck	Confirmation
	rmzhl_mst	co_rmzhl	Counter
	pdsnr	pdsnr_d	Number
	kapid	kapid	Capacity ID
	split	cy_split	Split number
	zausw	dzausw	Time rec.ID no.
	orind	orind	Application
	origf	origf	Origin
	canum	cy_count	Counter
	belnr_ist	co_belnr	Document Number
	belnr_umb	co_belnr	Document Number
	rmnga	ru_rmnga	Rework Quantity
	catsbelnr	catsbelnr	Document no.
	satza	co_satza	Record Type
	erzet	ru_erzet	Entry Time
	catsprice	catsprice	Price
	catstcurr	twaer	Trans. Currency
	catspeinh	peinh	Price unit
	bemot	bemot	AcctIndicator
	iprz1	ru_iprzs	Process Qty
	ipre1	ru_iprze	Process Unit
	iprk1	ru_iprzk	No Remain. Act.
	exnam	ru_exnam	Created by
	exerd	ru_exerd	Created on
	exerz	ru_exerz	Time
	prz01	co_prznr	Business Process
	oprz1	oprz1	Remaining Proc.
	opre1	opre1	RemainProc.Unit
	skokrs	kokrs	CO Area
	skostl	skostl	Send. CCtr
	nodat	nodat	No date update
	ismnu	arbeite	Unit for work
	ofmnu	arbeite	Unit for work
	packno	packno	Package number
	extid	ru_extid	External Key
	schgrup	schgrup	Shift Grouping
	kaptprog	kaptprog	Shift Definition
	obmat	ucmat	Orig.Batch Matl
	obcha	uccha	Original Batch
	licha	lichn	Supplier Batch
	myear	mjahr	Mat. Doc. Year
	me_sfcid	co_mes_int_sfcid	MES SFC ID
	me_2nd_conf_qty	co_mes_second_conf_qty	Rework (ME)
	no_goodsmovement_via_api	no_goodsmovement_via_api	No Goods Movement

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.

-- Order Confirmations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AFRU (
    MANDT,                     -- Client [mandt]
    RUECK,                     -- Confirmation [co_rueck]
    RMZHL,                     -- Counter [co_rmzhl]
    ERSDA,                     -- Entry Date [ru_ersda]
    ERNAM,                     -- Entered by User [ru_ernam]
    LAEDA,                     -- Last Change [laeda]
    AENAM,                     -- Changed By [aenam]
    BUDAT,                     -- Posting Date [buchdatum]
    ARBID,                     -- Object ID [objektid]
    WERKS,                     -- Plant [werks_d]
    LTXA1,                     -- Confirm. text [co_rtext]
    TXTSP,                     -- Language [spras]
    ISERH,                     -- Conf Break Time [iserh]
    ZEIER,                     -- Break Time Unit [dzeier]
    ILE01,                     -- Unit/activity [co_ismngeh]
    ISM01,                     -- Acty to Confirm [ru_ismng]
    ILE02,                     -- Unit/activity [co_ismngeh]
    ISM02,                     -- Acty to Confirm [ru_ismng]
    ILE03,                     -- Unit/activity [co_ismngeh]
    ISM03,                     -- Acty to Confirm [ru_ismng]
    ILE04,                     -- Unit/activity [co_ismngeh]
    ISM04,                     -- Acty to Confirm [ru_ismng]
    ILE05,                     -- Unit/activity [co_ismngeh]
    ISM05,                     -- Acty to Confirm [ru_ismng]
    ILE06,                     -- Unit/activity [co_ismngeh]
    ISM06,                     -- Acty to Confirm [ru_ismng]
    ABARB,                     -- Processing % [co_abarb]
    ISMNW,                     -- Actual work [ismnw]
    ISMNE,                     -- Unit for work [arbeite]
    LEARR,                     -- Activity Type [learr]
    IDAUR,                     -- Actual Duration [idaur]
    IDAUE,                     -- Un/actual dur. [idaure]
    ZCODE,                     -- Std value code [dzcode]
    LOART,                     -- Wage type [lohnart]
    QUALF,                     -- Suitability [qualf]
    ANZMA,                     -- No. employees [anzms]
    LOGRP,                     -- Wage Group [lohngrp]
    GMNGA,                     -- Confd Yield Quantity [ru_gmnga]
    LMNGA,                     -- Yield Quantity [ru_lmnga]
    XMNGA,                     -- Scrap Quantity [ru_xmnga]
    GMEIN,                     -- Base Unit [meins]
    MEINH,                     -- Confirmation Unit [ru_vorme]
    GRUND,                     -- Reason [co_agrnd]
    PERNR,                     -- Personnel no. [co_pernr]
    ISDD,                      -- Start Execution [ru_isdd]
    ISDZ,                      -- Act. Start Time [ru_isdz]
    IERD,                      -- Finish Setup [ru_ierd]
    IERZ,                      -- Finish Setup [ru_ierz]
    ISBD,                      -- Start of Proc. [ru_isbd]
    ISBZ,                      -- Start of Proc. [ru_isbz]
    IEBD,                      -- Fin. Processing [ru_iebd]
    IEBZ,                      -- Fin. Processing [ru_iebz]
    ISAD,                      -- Start Teardown [ru_isad]
    ISAZ,                      -- Start Teardown [ru_isaz]
    IEDD,                      -- Finish Execut. [ru_iedd]
    IEDZ,                      -- Actual finish [ru_iedz]
    PEDD,                      -- Forecast finish [co_pedd]
    PEDZ,                      -- Forecast End [co_pedz]
    WABLNR,                    -- Material Doc. [mblnr]
    WEBLNR,                    -- Doc.gds mvt err [weblnr]
    AUERU,                     -- Final Confirmtn [aueru_vs]
    AUSOR,                     -- Clear Open Res. [ausbu]
    STNDR,                     -- Standard conf. [stndr]
    MANUR,                     -- Type Confirm. [manur]
    MEILR,                     -- Milestone Conf. [meilr]
    AUFPL,                     -- Plan No.f.Oper. [co_aufpl]
    APLZL,                     -- Counter [co_aplzl]
    AUFNR,                     -- Order [aufnr]
    APLFL,                     -- Sequence [plnfolge]
    VORNR,                     -- Activity [vornr]
    SUMNR,                     -- Sup. Op. Node [sumkntnr]
    OFM01,                     -- Forecast Value [co_schaetz]
    OFE01,                     -- Std value unit [ru_progvge]
    LEK01,                     -- No Remain. Act. [co_leikz]
    OFM02,                     -- Forecast Value [co_schaetz]
    OFE02,                     -- Std value unit [ru_progvge]
    LEK02,                     -- No Remain. Act. [co_leikz]
    OFM03,                     -- Forecast Value [co_schaetz]
    OFE03,                     -- Std value unit [ru_progvge]
    LEK03,                     -- No Remain. Act. [co_leikz]
    OFM04,                     -- Forecast Value [co_schaetz]
    OFE04,                     -- Std value unit [ru_progvge]
    LEK04,                     -- No Remain. Act. [co_leikz]
    OFM05,                     -- Forecast Value [co_schaetz]
    OFE05,                     -- Std value unit [ru_progvge]
    LEK05,                     -- No Remain. Act. [co_leikz]
    OFM06,                     -- Forecast Value [co_schaetz]
    OFE06,                     -- Std value unit [ru_progvge]
    LEK06,                     -- No Remain. Act. [co_leikz]
    OFMNW,                     -- Remaining work [remnw]
    OFMNE,                     -- Unit Remng Work [ofmne]
    LEKNW,                     -- No Remain. Work [leknw]
    ODAUR,                     -- Remaining dur. [odaur]
    ODAUE,                     -- Unit/remaining [odaue]
    STOKZ,                     -- Reversed [co_stokz]
    STZHL,                     -- Cancelled Conf. [co_stzhl]
    SMENG,                     -- Operation Qty [mgvrg]
    RUECK_MST,                 -- Confirmation [co_rueck]
    RMZHL_MST,                 -- Counter [co_rmzhl]
    PDSNR,                     -- Number [pdsnr_d]
    KAPID,                     -- Capacity ID [kapid]
    SPLIT,                     -- Split number [cy_split]
    ZAUSW,                     -- Time rec.ID no. [dzausw]
    ORIND,                     -- Application [orind]
    ORIGF,                     -- Origin [origf]
    CANUM,                     -- Counter [cy_count]
    BELNR_IST,                 -- Document Number [co_belnr]
    BELNR_UMB,                 -- Document Number [co_belnr]
    RMNGA,                     -- Rework Quantity [ru_rmnga]
    CATSBELNR,                 -- Document no. [catsbelnr]
    SATZA,                     -- Record Type [co_satza]
    ERZET,                     -- Entry Time [ru_erzet]
    CATSPRICE,                 -- Price [catsprice]
    CATSTCURR,                 -- Trans. Currency [twaer]
    CATSPEINH,                 -- Price unit [peinh]
    BEMOT,                     -- AcctIndicator [bemot]
    IPRZ1,                     -- Process Qty [ru_iprzs]
    IPRE1,                     -- Process Unit [ru_iprze]
    IPRK1,                     -- No Remain. Act. [ru_iprzk]
    EXNAM,                     -- Created by [ru_exnam]
    EXERD,                     -- Created on [ru_exerd]
    EXERZ,                     -- Time [ru_exerz]
    PRZ01,                     -- Business Process [co_prznr]
    OPRZ1,                     -- Remaining Proc. [oprz1]
    OPRE1,                     -- RemainProc.Unit [opre1]
    SKOKRS,                    -- CO Area [kokrs]
    SKOSTL,                    -- Send. CCtr [skostl]
    NODAT,                     -- No date update [nodat]
    ISMNU,                     -- Unit for work [arbeite]
    OFMNU,                     -- Unit for work [arbeite]
    PACKNO,                    -- Package number [packno]
    EXTID,                     -- External Key [ru_extid]
    SCHGRUP,                   -- Shift Grouping [schgrup]
    KAPTPROG,                  -- Shift Definition [kaptprog]
    OBMAT,                     -- Orig.Batch Matl [ucmat]
    OBCHA,                     -- Original Batch [uccha]
    LICHA,                     -- Supplier Batch [lichn]
    MYEAR,                     -- Mat. Doc. Year [mjahr]
    ME_SFCID,                  -- MES SFC ID [co_mes_int_sfcid]
    ME_2ND_CONF_QTY,           -- Rework (ME) [co_mes_second_conf_qty]
    NO_GOODSMOVEMENT_VIA_API,  -- No Goods Movement [no_goodsmovement_via_api]
    PRIMARY KEY (MANDT, RUECK, RMZHL)
);

Depth:

AFRU

CDS Views using this table (7)

Fields (141)

Learn More