I_PURGQUOTAARRGMT

CDS View

Quota Arrgmt, Basic View, Interface

I_PURGQUOTAARRGMT is a CDS View in S/4HANA. Quota Arrgmt, Basic View, Interface. It contains 11 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
A_PurchasingQuotaArrangement view from BASIC Quota Arrangement
C_PurgQuotaArrgmtVH view from CONSUMPTION Consumption view, Quota Arrgmt Header VH
I_PurgQuotaArrgmtAPI01 view from BASIC Purchasing Quota Arrangement
I_PurgQuotaArrgmtTP view from TRANSACTIONAL Quota Arrgmt, Basic View, Interface
I_SourcesOfSupply view inner COMPOSITE Sources of Supply
P_SourcesOfSupply view union COMPOSITE Collection of all individual SOS records
R_PurgQuotaArrgmtTP view_entity from TRANSACTIONAL Quota Arrangement HDR

Fields (11)

KeyField CDS FieldsUsed in Views
KEY Material Material 4
KEY Plant Plant 4
KEY QuotaArrangement QuotaArrangement,QuotaArrangementForEdit,SourceDocument 3
CreatedByUser CreatedByUser 1
CreationDate CreationDate 2
LastChangeDateTime LastChangeDateTime 1
MaterialBaseUnit MaterialBaseUnit 2
MinQtyForSpltQuota MinQtyForSpltQuota 2
UserDescription UserDescription 1
ValidityEndDate ValidityEndDate 4
ValidityStartDate ValidityStartDate 4

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.

-- Quota Arrgmt, Basic View, Interface
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURGQUOTAARRGMT (
    MATERIAL,
    PLANT,
    QUOTAARRANGEMENT,
    CREATEDBYUSER,
    CREATIONDATE,
    LASTCHANGEDATETIME,
    MATERIALBASEUNIT,
    MINQTYFORSPLTQUOTA,
    USERDESCRIPTION,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (MATERIAL, PLANT, QUOTAARRANGEMENT)
);