SOLUTIONS

26 Fields

SOLUTIONS is an SAP database table in S/4HANA. It contains 26 fields.

Fields (26)

KeyField CDS FieldsUsed in Views
KEY Batch Batch 2
KEY Customer Customer 2
KEY Material Material 2
KEY Plant Plant 2
KEY ReferenceDocumentScheduleLine ReferenceDocumentScheduleLine 2
KEY SalesOrder SalesOrder 2
KEY SalesOrderItem SalesOrderItem 2
KEY SolutionType SolutionType 2
ActualDeliveryDate ActualDeliveryDate 2
ActualDeliveryQuantity ActualDeliveryQuantity 2
bubblequantity IssueQuantity 1
CompanyCodeCurrency CompanyCodeCurrency 2
Coverage SolutionCoverage 1
DeliveryDate DeliveryDate 2
DeliveryQuantity DeliveryQuantity 2
DeliveryQuantityInBaseUnit DeliveryQuantityInBaseUnit 2
DifferenceInDeliveryDates DifferenceInDeliveryDates 1
DifferenceOfQuantity DifferenceOfQuantity 1
IssueQuantity IssueQuantity 1
OriginalDeliveryQuantity OriginalDeliveryQuantity 1
Profit Profit 2
QuantityUnit QuantityUnit 1
Revenue Revenue 2
SolutionCoverage SolutionCoverage 1
SolutionMargin SolutionMargin 2
SolutionRank SolutionRank 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SOLUTIONS (
    BATCH,
    CUSTOMER,
    MATERIAL,
    PLANT,
    REFERENCEDOCUMENTSCHEDULELINE,
    SALESORDER,
    SALESORDERITEM,
    SOLUTIONTYPE,
    ACTUALDELIVERYDATE,
    ACTUALDELIVERYQUANTITY,
    BUBBLEQUANTITY,
    COMPANYCODECURRENCY,
    COVERAGE,
    DELIVERYDATE,
    DELIVERYQUANTITY,
    DELIVERYQUANTITYINBASEUNIT,
    DIFFERENCEINDELIVERYDATES,
    DIFFERENCEOFQUANTITY,
    ISSUEQUANTITY,
    ORIGINALDELIVERYQUANTITY,
    PROFIT,
    QUANTITYUNIT,
    REVENUE,
    SOLUTIONCOVERAGE,
    SOLUTIONMARGIN,
    SOLUTIONRANK,
    PRIMARY KEY (BATCH, CUSTOMER, MATERIAL, PLANT, REFERENCEDOCUMENTSCHEDULELINE, SALESORDER, SALESORDERITEM, SOLUTIONTYPE)
);

Learn More