I_PURGSCHEAGRMTRELDOC

CDS View
16 Fields 2 CDS Views

Scheduling Agreement Release Document

I_PURGSCHEAGRMTRELDOC is a CDS View in S/4HANA. Scheduling Agreement Release Document. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SchedAgrmtReleaseListItem view left_outer COMPOSITE Schedule Agreement Release List Item
I_SchedgAgrmtReleaseDoc view from COMPOSITE Scheduling Agrmt Release Documentation

Fields (16)

KeyField CDS FieldsUsed in Views
KEY ReleaseCode ReleaseCode 2
KEY SchedulingAgreement SchedulingAgreement 1
KEY SchedulingAgreementItem SchedulingAgreementItem 1
KEY SchedulingAgreementReleaseType SchedulingAgreementReleaseType 2
InboundDeliveryNote InboundDeliveryNote 1
IsSchedgAgreementItemReld IsSchedgAgreementItemReld 1
LastGoodsReceiptDate LastGoodsReceiptDate 1
LastGoodsReceiptQuantity LastGoodsReceiptQuantity 1
MaterialGoAheadPeriodEndDate MaterialGoAheadPeriodEndDate 1
ProductionGoAheadPeriodEndDate ProductionGoAheadPeriodEndDate 1
SchedgAgrmtCumltvRcvdQty SchedgAgrmtCumltvRcvdQty 1
SchedgAgrmtReleaseCreationDate SchedgAgrmtReleaseCreationDate 1
SchedgAgrmtReleaseCreationTime SchedgAgrmtReleaseCreationTime 1
SchedgAgrmtRelTransmissionDate SchedgAgrmtRelTransmissionDate 1
SchedgAgrmtRelTransmissionTime SchedgAgrmtRelTransmissionTime 1
SchedgAgrmtStopReleaseStatus SchedgAgrmtStopReleaseStatus 1

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 Release Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURGSCHEAGRMTRELDOC (
    RELEASECODE,
    SCHEDULINGAGREEMENT,
    SCHEDULINGAGREEMENTITEM,
    SCHEDULINGAGREEMENTRELEASETYPE,
    INBOUNDDELIVERYNOTE,
    ISSCHEDGAGREEMENTITEMRELD,
    LASTGOODSRECEIPTDATE,
    LASTGOODSRECEIPTQUANTITY,
    MATERIALGOAHEADPERIODENDDATE,
    PRODUCTIONGOAHEADPERIODENDDATE,
    SCHEDGAGRMTCUMLTVRCVDQTY,
    SCHEDGAGRMTRELEASECREATIONDATE,
    SCHEDGAGRMTRELEASECREATIONTIME,
    SCHEDGAGRMTRELTRANSMISSIONDATE,
    SCHEDGAGRMTRELTRANSMISSIONTIME,
    SCHEDGAGRMTSTOPRELEASESTATUS,
    PRIMARY KEY (RELEASECODE, SCHEDULINGAGREEMENT, SCHEDULINGAGREEMENTITEM, SCHEDULINGAGREEMENTRELEASETYPE)
);

Learn More