CIC_SOURCE_OF_SUPPLY_UNION

CDS View
29 Fields 1 CDS Views

CIC Source of Supply Union

CIC_SOURCE_OF_SUPPLY_UNION is a CDS View in S/4HANA. CIC Source of Supply Union. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
CIC_SOURCE_OF_SUPPLY_JOIN view from Source of Supply for valid partners

Fields (29)

KeyField CDS FieldsUsed in Views
KEY Category Category 1
KEY Product Product 1
KEY ProductGroup ProductGroup 1
KEY PurchasingOrganization PurchasingOrganization 1
KEY Receiver Receiver 1
KEY SourceOfSupplyType SourceOfSupplyType 1
KEY Supplier Supplier 1
KEY ValidityEndDate ValidityEndDate 1
KEY ValidityStartDate ValidityStartDate 1
IncotermsClassification IncotermsClassification 1
IncotermsTransferLocationName IncotermsTransferLocationName 1
InfoRecordIsMarkedForDeletion InfoRecordIsMarkedForDeletion 1
IsPurchasingBlocked IsPurchasingBlocked 1
LogisticalRoundingProfile LogisticalRoundingProfile 1
MinimumOrderQuantity MinimumOrderQuantity 1
NetPriceAmount NetPriceAmount 1
NetPriceQuantity NetPriceQuantity 1
NetPriceUnit NetPriceUnit 1
OrderCurrency OrderCurrency 1
OrderQuantityUnit OrderQuantityUnit 1
PlannedDeliveryTimeDays PlannedDeliveryTimeDays 1
Priority Priority 1
PurchasingGroup PurchasingGroup 1
PurchasingInfoRecord PurchasingInfoRecord 1
ReceivingPlant ReceivingPlant 1
ReceivingTimeZone ReceivingTimeZone 1
SourceListRecord SourceListRecord 1
SupplierSubRange SupplierSubRange 1
SupplyingPlant SupplyingPlant 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.

-- CIC Source of Supply Union
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CIC_SOURCE_OF_SUPPLY_UNION (
    CATEGORY,
    PRODUCT,
    PRODUCTGROUP,
    PURCHASINGORGANIZATION,
    RECEIVER,
    SOURCEOFSUPPLYTYPE,
    SUPPLIER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATIONNAME,
    INFORECORDISMARKEDFORDELETION,
    ISPURCHASINGBLOCKED,
    LOGISTICALROUNDINGPROFILE,
    MINIMUMORDERQUANTITY,
    NETPRICEAMOUNT,
    NETPRICEQUANTITY,
    NETPRICEUNIT,
    ORDERCURRENCY,
    ORDERQUANTITYUNIT,
    PLANNEDDELIVERYTIMEDAYS,
    PRIORITY,
    PURCHASINGGROUP,
    PURCHASINGINFORECORD,
    RECEIVINGPLANT,
    RECEIVINGTIMEZONE,
    SOURCELISTRECORD,
    SUPPLIERSUBRANGE,
    SUPPLYINGPLANT,
    PRIMARY KEY (CATEGORY, PRODUCT, PRODUCTGROUP, PURCHASINGORGANIZATION, RECEIVER, SOURCEOFSUPPLYTYPE, SUPPLIER, VALIDITYENDDATE, VALIDITYSTARTDATE)
);

Learn More