REF

REF is an SAP database table in S/4HANA. It contains 58 fields.

Fields (58)

KeyField CDS FieldsUsed in Views
KEY ConditionType ConditionType 1
KEY PricingDocumentItem PricingDocumentItem 1
KEY PricingKey PricingKey 1
KEY SubConditionType SubConditionType 1
KEY VersStockRecordUUID VersStockRecordUUID 1
BegingingBookBalancetTimestamp BegingingBookBalancetTimestamp 1
BusinessPlace BusinessPlace 1
CmmdtyPriceExpsrMassUnit CmmdtyPriceExpsrMassUnit 1
CmmdtyPriceExpsrQtyInMassUnit CmmdtyPriceExpsrQtyInMassUnit 1
CmmdtyPriceExpsrQtyInVolUnit CmmdtyPriceExpsrQtyInVolUnit 1
CmmdtyPriceExpsrVolumeUnit CmmdtyPriceExpsrVolumeUnit 1
Commodity Commodity 1
CommodityExposureUnit CommodityExposureUnit 1
CommodityQuantity CommodityQuantity 1
CommodityUnit CommodityUnit 1
CompanyCode CompanyCode 2
DailyGrainReportDate DailyGrainReportDate 1
DailyGrainReportDisplayUnit DailyGrainReportDisplayUnit 1
DailyGrainReportType DailyGrainReportType 1
DiscPremQtyScheduleType DiscPremQtyScheduleType 1
DiscPremQtyScheduleUniqueID DiscPremQtyScheduleUniqueID 1
DiscPremQtyScheduleVersion DiscPremQtyScheduleVersion 1
DocumentDate RefInvcDocumentDate 1
EndOfDayBusinessEntityKey EndOfDayBusinessEntityKey 1
EndOfDayTimestamp EndOfDayTimestamp 1
GoodsMovementType GoodsMovementType 1
HandleLossRsrvID HandleLossRsrvID 1
HandleLossRsrvItem HandleLossRsrvItem 1
HandleLossRsrvVersion HandleLossRsrvVersion 1
LoadDataCaptureObjectID LoadDataCaptureObjectID 1
Material Material 1
MaterialBaseUnit MaterialBaseUnit 1
MessageText MessageText 1
MTMCalculationGroup MTMCalculationGroup 1
MTMConditionGroupCategory MTMConditionGroupCategory 1
MTMDataSourceType MTMDataSourceType 1
NetDryErrorCode NetDryErrorCode 1
NetExposureQuantity NetExposureQuantity 1
NetPriceExpsrQtyInBaseUnit NetPriceExpsrQtyInBaseUnit 1
NetPriceExpsrQtyInMassUnit NetPriceExpsrQtyInMassUnit 1
NetPriceExpsrQtyInVolumeUnit NetPriceExpsrQtyInVolumeUnit 1
NetPriceExpsrQuantity NetPriceExpsrQuantity 1
PhysicalCommodity PhysicalCommodity 1
Plant Plant 1
PlantGroup PlantGroup 1
PreviousEndOfDayTimestamp PreviousEndOfDayTimestamp 1
QuotationKeyType QuotationKeyType 1
RecordIsLogicallyDeleted RecordIsLogicallyDeleted 1
ReversedMaterialDocument ReversedMaterialDocument 1
ReversedMaterialDocumentItem ReversedMaterialDocumentItem 1
ReversedMaterialDocumentYear ReversedMaterialDocumentYear 1
SourceDocument SourceDocument 1
SourceDocumentBusObjType SourceDocumentBusObjType 1
SourceDocumentItem SourceDocumentItem 1
SourceDocumentYear SourceDocumentYear 1
SourceTransacEventEndDateTime SourceTransacEventEndDateTime 1
SourceTransactionEventDateTime SourceTransactionEventDateTime 1
StorageLocation StorageLocation 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 REF (
    CONDITIONTYPE,
    PRICINGDOCUMENTITEM,
    PRICINGKEY,
    SUBCONDITIONTYPE,
    VERSSTOCKRECORDUUID,
    BEGINGINGBOOKBALANCETTIMESTAMP,
    BUSINESSPLACE,
    CMMDTYPRICEEXPSRMASSUNIT,
    CMMDTYPRICEEXPSRQTYINMASSUNIT,
    CMMDTYPRICEEXPSRQTYINVOLUNIT,
    CMMDTYPRICEEXPSRVOLUMEUNIT,
    COMMODITY,
    COMMODITYEXPOSUREUNIT,
    COMMODITYQUANTITY,
    COMMODITYUNIT,
    COMPANYCODE,
    DAILYGRAINREPORTDATE,
    DAILYGRAINREPORTDISPLAYUNIT,
    DAILYGRAINREPORTTYPE,
    DISCPREMQTYSCHEDULETYPE,
    DISCPREMQTYSCHEDULEUNIQUEID,
    DISCPREMQTYSCHEDULEVERSION,
    DOCUMENTDATE,
    ENDOFDAYBUSINESSENTITYKEY,
    ENDOFDAYTIMESTAMP,
    GOODSMOVEMENTTYPE,
    HANDLELOSSRSRVID,
    HANDLELOSSRSRVITEM,
    HANDLELOSSRSRVVERSION,
    LOADDATACAPTUREOBJECTID,
    MATERIAL,
    MATERIALBASEUNIT,
    MESSAGETEXT,
    MTMCALCULATIONGROUP,
    MTMCONDITIONGROUPCATEGORY,
    MTMDATASOURCETYPE,
    NETDRYERRORCODE,
    NETEXPOSUREQUANTITY,
    NETPRICEEXPSRQTYINBASEUNIT,
    NETPRICEEXPSRQTYINMASSUNIT,
    NETPRICEEXPSRQTYINVOLUMEUNIT,
    NETPRICEEXPSRQUANTITY,
    PHYSICALCOMMODITY,
    PLANT,
    PLANTGROUP,
    PREVIOUSENDOFDAYTIMESTAMP,
    QUOTATIONKEYTYPE,
    RECORDISLOGICALLYDELETED,
    REVERSEDMATERIALDOCUMENT,
    REVERSEDMATERIALDOCUMENTITEM,
    REVERSEDMATERIALDOCUMENTYEAR,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTBUSOBJTYPE,
    SOURCEDOCUMENTITEM,
    SOURCEDOCUMENTYEAR,
    SOURCETRANSACEVENTENDDATETIME,
    SOURCETRANSACTIONEVENTDATETIME,
    STORAGELOCATION,
    PRIMARY KEY (CONDITIONTYPE, PRICINGDOCUMENTITEM, PRICINGKEY, SUBCONDITIONTYPE, VERSSTOCKRECORDUUID)
);