I_SUPDMNDALLDOCPURGCONTR

CDS View
31 Fields 6 CDS Views

View for Purchasing Contract

I_SUPDMNDALLDOCPURGCONTR is a CDS View in S/4HANA. View for Purchasing Contract. It contains 31 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_SupDmndAllDocPurgContrAssgC view left_outer COMPOSITE Cube View for Purchasing Contract Assignment Details
I_SupDmndAllDocPurgContrC view from COMPOSITE Cube View for Purchasing Contract Details
I_SupDmndAllDocPurgContrRefC view inner COMPOSITE Cube View for Purchasing Contract Reference Details
I_SupDmndAllDocSupAmt view from COMPOSITE View for Supply of All Documents
I_SupDmndAllDocSupply view union_all COMPOSITE View for Supply of All Documents
P_SupDmndAllDocPurgContrAssgmt view from COMPOSITE View for Purchasing COntract

Fields (31)

KeyField CDS FieldsUsed in Views
KEY AssignedSupplyType AssignedSupplyType 4
KEY Batch Batch 4
KEY Material Material 4
KEY Plant Plant 4
KEY ProductAvailabilityDate ProductAvailabilityDate 4
KEY StorageLocation StorageLocation 4
KEY SupplyItem SupplyItem 4
KEY SupplyNumber SupplyNumber 4
KEY SupplyScheduleLine SupplyScheduleLine 4
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit 1
BaseUnit BaseUnit 4
CompanyCode CompanyCode 1
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 4
Customer Customer 1
DocumentCurrency DocumentCurrency 4
MaterialGroup MaterialGroup 4
MaterialType MaterialType 1
NetPriceAmount NetPriceAmount 4
NormalAssignedQuantityInBsUnt NormalAssignedQuantityInBsUnt 1
OpenSupplyQuantity OpenReleasedQuantity 1
OrderType OrderType 1
PreviewAssignedQuantityInBsUnt PreviewAssignedQuantityInBsUnt 1
PurchasingGroup PurchasingGroup 4
PurchasingOrganization PurchasingOrganization 1
ReleasedQuantity ReleasedQuantity 2
RequestedDeliveryDate RequestedDeliveryDate 4
StockSegment StockSegment 1
SupAssgmtSource SupAssgmtSource 4
Supplier Supplier 1
SupplyDeliveryDate SupplyDeliveryDate 1
TotalQuantity TotalQuantity 2

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.

-- View for Purchasing Contract
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPDMNDALLDOCPURGCONTR (
    ASSIGNEDSUPPLYTYPE,
    BATCH,
    MATERIAL,
    PLANT,
    PRODUCTAVAILABILITYDATE,
    STORAGELOCATION,
    SUPPLYITEM,
    SUPPLYNUMBER,
    SUPPLYSCHEDULELINE,
    ASSIGNEDQUANTITYINBASEUNIT,
    BASEUNIT,
    COMPANYCODE,
    CROSSPLANTCONFIGURABLEPRODUCT,
    CUSTOMER,
    DOCUMENTCURRENCY,
    MATERIALGROUP,
    MATERIALTYPE,
    NETPRICEAMOUNT,
    NORMALASSIGNEDQUANTITYINBSUNT,
    OPENSUPPLYQUANTITY,
    ORDERTYPE,
    PREVIEWASSIGNEDQUANTITYINBSUNT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    RELEASEDQUANTITY,
    REQUESTEDDELIVERYDATE,
    STOCKSEGMENT,
    SUPASSGMTSOURCE,
    SUPPLIER,
    SUPPLYDELIVERYDATE,
    TOTALQUANTITY,
    PRIMARY KEY (ASSIGNEDSUPPLYTYPE, BATCH, MATERIAL, PLANT, PRODUCTAVAILABILITYDATE, STORAGELOCATION, SUPPLYITEM, SUPPLYNUMBER, SUPPLYSCHEDULELINE)
);

Learn More