CFIN_AV_PO_SCH

Transparent Table Application Table
24 Fields 3 CDS Views

Scheduling Agreement Schedule Lines

CFIN_AV_PO_SCH is an SAP database table in S/4HANA. Scheduling Agreement Schedule Lines. It contains 24 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_CFinRpldPurgDocScheduleLine view_entity from EXTENSION CFin Rpld PD ScheduleLn - Extension
I_CFinRpldPurgDocScheduleLine view from BASIC CFin Rpld Purchasing Doc: Schedule Line
R_CFinRpldPurgDocScheduleLine view_entity from BASIC CFin Rpld Purchasing Doc Schedule Line

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
root_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
fins_logsys LOGSYS Logical system
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
etenr EETEN Schedule Line
eindt EINDT Delivery Date
slfdt SLFDT Stat. Del. Date
lpein LPEIN Delivery Date
menge ETMEN Scheduled Qty
wemng WEEMG Delivered
wamng WAMNG Issued
uzeit LZEIT Time
mahnz MAHNZE No. Rem./Exp.
bedat ETBDT PurchOrderDate
glmng GLMNG Qty Delivered
dabmg DABMG Qty Reduced
charg CHARG_D Batch
mng02 MNG06 Committed Qty
dat01 DAT05 Committed date
startdate FINS_CFIN_AV_SERV_PERIOD_START Start Date
enddate FINS_CFIN_AV_SERV_PERIOD_END End Date

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.

-- Scheduling Agreement Schedule Lines
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_AV_PO_SCH (
    MANDT,        -- Client [MANDT]
    DB_KEY,       -- NodeID [/BOBF/CONF_KEY]
    ROOT_KEY,     -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,   -- NodeID [/BOBF/CONF_KEY]
    FINS_LOGSYS,  -- Logical system [LOGSYS]
    EBELN,        -- Purchasing Doc. [EBELN]
    EBELP,        -- Item [EBELP]
    ETENR,        -- Schedule Line [EETEN]
    EINDT,        -- Delivery Date [EINDT]
    SLFDT,        -- Stat. Del. Date [SLFDT]
    LPEIN,        -- Delivery Date [LPEIN]
    MENGE,        -- Scheduled Qty [ETMEN]
    WEMNG,        -- Delivered [WEEMG]
    WAMNG,        -- Issued [WAMNG]
    UZEIT,        -- Time [LZEIT]
    MAHNZ,        -- No. Rem./Exp. [MAHNZE]
    BEDAT,        -- PurchOrderDate [ETBDT]
    GLMNG,        -- Qty Delivered [GLMNG]
    DABMG,        -- Qty Reduced [DABMG]
    CHARG,        -- Batch [CHARG_D]
    MNG02,        -- Committed Qty [MNG06]
    DAT01,        -- Committed date [DAT05]
    STARTDATE,    -- Start Date [FINS_CFIN_AV_SERV_PERIOD_START]
    ENDDATE,      -- End Date [FINS_CFIN_AV_SERV_PERIOD_END]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More