I_SUPDMNDALLDOCPURREQNBSC

CDS View
30 Fields 5 CDS Views

Basic View for Purchase Requisition

I_SUPDMNDALLDOCPURREQNBSC is a CDS View in S/4HANA. Basic View for Purchase Requisition. It contains 30 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_SupDmndAllDocPurReqn view from COMPOSITE View for Purchase Requisition
I_SupDmndAllDocPurReqnAssgC view left_outer COMPOSITE Cube View for Purchase Requisition Assignment Details
I_SupDmndAllDocPurReqnCube view from COMPOSITE Cube View for Purchase Requisition Details
I_SupDmndAllDocSupAmt view union_all COMPOSITE View for Supply of All Documents
I_SupDmndAllDocSupply view union_all COMPOSITE View for Supply of All Documents

Fields (30)

KeyField CDS FieldsUsed in Views
KEY AssignedSupplyType AssignedSupplyType 3
KEY Batch Batch 3
KEY Material Material 3
KEY Plant Plant 3
KEY ProductAvailabilityDate ProductAvailabilityDate 3
KEY StorageLocation StorageLocation 3
KEY SupplyItem SupplyItem 3
KEY SupplyNumber SupplyNumber 3
KEY SupplyScheduleLine SupplyScheduleLine 3
BaseUnit BaseUnit 3
CompanyCode CompanyCode 1
CrossPlantConfigurableProduct CrossPlantConfigurableProduct 3
Customer Customer 1
DocumentCurrency DocumentCurrency 2
GoodsReceiptDurationInDays GoodsReceiptDurationInDays 1
MaterialGroup MaterialGroup 3
MRPArea MRPArea 1
NetPriceAmount NetPriceAmount 2
OrderType OrderType 1
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 1
PurgReleaseSequenceStatus PurgReleaseSequenceStatus 1
RequestedDeliveryDate RequestedDeliveryDate 2
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
StockSegment StockSegment 1
SupAssgmtSource SupAssgmtSource 3
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.

-- Basic View for Purchase Requisition
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPDMNDALLDOCPURREQNBSC (
    ASSIGNEDSUPPLYTYPE,
    BATCH,
    MATERIAL,
    PLANT,
    PRODUCTAVAILABILITYDATE,
    STORAGELOCATION,
    SUPPLYITEM,
    SUPPLYNUMBER,
    SUPPLYSCHEDULELINE,
    BASEUNIT,
    COMPANYCODE,
    CROSSPLANTCONFIGURABLEPRODUCT,
    CUSTOMER,
    DOCUMENTCURRENCY,
    GOODSRECEIPTDURATIONINDAYS,
    MATERIALGROUP,
    MRPAREA,
    NETPRICEAMOUNT,
    ORDERTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURGRELEASESEQUENCESTATUS,
    REQUESTEDDELIVERYDATE,
    SALESORDER,
    SALESORDERITEM,
    STOCKSEGMENT,
    SUPASSGMTSOURCE,
    SUPPLIER,
    SUPPLYDELIVERYDATE,
    TOTALQUANTITY,
    PRIMARY KEY (ASSIGNEDSUPPLYTYPE, BATCH, MATERIAL, PLANT, PRODUCTAVAILABILITYDATE, STORAGELOCATION, SUPPLYITEM, SUPPLYNUMBER, SUPPLYSCHEDULELINE)
);

Learn More