AFVV

Transparent Table Application Table
3 Fields 8 CDS Views

DB structure of the quantities/dates/values in the operation

AFVV is an SAP database table in S/4HANA. DB structure of the quantities/dates/values in the operation. It contains 3 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_MaintOrderOperPlanningValues view from BASIC Maint. Order Operation Planning Values
I_NetworkActivity view left_outer BASIC Network Activity Details
I_NetworkActivityDatesQuantity view from BASIC Network Activity Dates/Quantities
I_OrderOperationDatesQty view_entity from BASIC Order Operation Dates
P_AFVG view inner BASIC Operation / Activity
P_ProcOrdMgmtOpBasic view inner BASIC Process order operation basic (afvc)
P_ProcOrdMgmtOpDetails view inner BASIC Process order mgmt operaton details
P_ProdOrdMgmtOpBasic view_entity inner BASIC Production Order Operations Basic View (AFVC)

Fields (3)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY aufpl co_aufpl Plan No.f.Oper.
KEY aplzl co_aplzl Counter

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.

-- DB structure of the quantities/dates/values in the operation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AFVV (
    MANDT,  -- Client [mandt]
    AUFPL,  -- Plan No.f.Oper. [co_aufpl]
    APLZL,  -- Counter [co_aplzl]
    PRIMARY KEY (MANDT, AUFPL, APLZL)
);

Learn More