AFPO

Transparent Table Application Table
3 Fields 33 CDS Views

Order item

AFPO is an SAP database table in S/4HANA. Order item. It contains 3 fields. 33 CDS views read from this table.

CDS Views using this table (33)

ViewTypeJoinVDMDescription
ARUN_I_F_LINE view from Production Order Item level selection
Atpc_Cds_Afpo view from CDS View on AFPO Table for ATP
ATPC_CDS_AFPO_QTY_DIST view from CDS View on AFPO,RESB,AFKO for Qty. Dist for ATP
e_mrp_mfg_comps view left_outer
e_mrp_prod_demands view left_outer
F_Mmim_OrderItem_Vh view inner Value Help Order Items
FINOC_RULE_ORD_BASE view left_outer Orgl Change-Rule: Order Base
I_OrderItem view from BASIC Order Item
I_ProductCostCtrlgOrderItem view from BASIC Product Cost Controlling Order Item
I_SupDmndAllDocProdnOrdBsc view inner BASIC Basic View for Production Order
I_SupDmndAllDocProdnOrdCompBsc view inner BASIC Basic View for Production Order Components
I_SupDmndComponentBasic view inner BASIC Basic View for Components
I_SupDmndOvwProductionOrder view from BASIC Basic View for Production Order
I_TripOrderNumberVH view left_outer BASIC Order Number Value Help
MDCV_E_FAPW view from Compatibility View for table FAPW
MDCV_E_VFAPW view from Compatibility View for DDIC view VFAPW
P_ChgImpactOrderEffectivity view from BASIC
P_EBWObjectMaxStatus view inner BASIC
P_MfgOrderItem view from BASIC
P_Ra_Objects view left_outer BASIC
P_RTPCOrderFxdPrcProdDlvrdCost view inner BASIC
P_RTPCOrderFxdPricePrdDlvValue view inner BASIC
P_RTPCOrderItemFxdPricePrdAct1 view inner BASIC
P_VarConfignProdnOrderItem view from BASIC
pp_mrp_read_mfg_order view inner Read Manufacturing Order
pp_mrp_read_mfg_order_comp view inner Read Manufacturing Order Components
pp_mrp_read_mfg_order_comp view left_outer Read Manufacturing Order Components
PPH_E_AFPO_1 view from
pph_mrp_afpo view from
PRODCMPLNCLICRLVTPRODNDOC view from License Relevant Production Order Items
SHSM_M_AUKOD view inner View for matchcode ID AUKO-D
vfco_dll_co88_with_op_l1 view inner
vfco_dll_co88_wo_op_l1 view left_outer

Fields (3)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY aufnr aufnr Order
KEY posnr co_posnr Item Number

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 item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AFPO (
    MANDT,  -- Client [mandt]
    AUFNR,  -- Order [aufnr]
    POSNR,  -- Item Number [co_posnr]
    PRIMARY KEY (MANDT, AUFNR, POSNR)
);

Learn More