_SOURCEOFSUPPLY

14 Fields

_SOURCEOFSUPPLY is an SAP database table in S/4HANA. It contains 14 fields.

Fields (14)

KeyField CDS FieldsUsed in Views
KEY PMRPSourceOfSupplyInternalID PMRPSourceOfSupplyInternalID 1
KEY PMRPSourceOfSupplyName PMRPSourceOfSupplyName 6
_ProductionLine _WorkCenter 1
_Supplier _Supplier 1
_SupplyingPlant _SupplyingPlant 1
AdvncdPlngSOSDesc AdvncdPlngSOSDesc 1
AdvncdPlngSupNameSrce AdvncdPlngSupNameSrce 1
GoodsReceiptDuration GoodsReceiptDuration 1
InHouseProductionTime InHouseProductionTime 1
PlannedDeliveryDuration PlannedDeliveryDuration 1
ProductionLine ProductionLine 2
ReceivingPlant ReceivingPlant 2
Supplier Supplier 2
SupplyingPlant SupplyingPlant 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _SOURCEOFSUPPLY (
    PMRPSOURCEOFSUPPLYINTERNALID,
    PMRPSOURCEOFSUPPLYNAME,
    _PRODUCTIONLINE,
    _SUPPLIER,
    _SUPPLYINGPLANT,
    ADVNCDPLNGSOSDESC,
    ADVNCDPLNGSUPNAMESRCE,
    GOODSRECEIPTDURATION,
    INHOUSEPRODUCTIONTIME,
    PLANNEDDELIVERYDURATION,
    PRODUCTIONLINE,
    RECEIVINGPLANT,
    SUPPLIER,
    SUPPLYINGPLANT,
    PRIMARY KEY (PMRPSOURCEOFSUPPLYINTERNALID, PMRPSOURCEOFSUPPLYNAME)
);

Learn More