_INFORECORD

_INFORECORD is an SAP database table in S/4HANA. It contains 19 fields.

Fields (19)

KeyField CDS FieldsUsed in Views
AvailabilityEndDate AvailabilityEndDate 2
AvailabilityStartDate AvailabilityStartDate 2
Currency Currency 2
IncotermsClassification IncotermsClassification 1
IsDeleted IsDeleted 2
Manufacturer Manufacturer 2
Material Material 2
MaterialGroup MaterialGroup 2
MaterialPlannedDeliveryDurn MaterialPlannedDeliveryDurn 1
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct 1
PricingDateControl PricingDateControl 1
PriorSupplier PriorSupplier 2
PurchasingGroup PurchasingGroup 1
PurgDocOrderQuantityUnit BaseUnit 1
Supplier Supplier 2
SupplierMaterialNumber SupplierMaterialNumber 2
SupplierSubrange SupplierSubrange 2
TaxCode TaxCode 1
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 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 _INFORECORD (
    AVAILABILITYENDDATE,
    AVAILABILITYSTARTDATE,
    CURRENCY,
    INCOTERMSCLASSIFICATION,
    ISDELETED,
    MANUFACTURER,
    MATERIAL,
    MATERIALGROUP,
    MATERIALPLANNEDDELIVERYDURN,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    PRICINGDATECONTROL,
    PRIORSUPPLIER,
    PURCHASINGGROUP,
    PURGDOCORDERQUANTITYUNIT,
    SUPPLIER,
    SUPPLIERMATERIALNUMBER,
    SUPPLIERSUBRANGE,
    TAXCODE,
    UNDERDELIVTOLRTDLMTRATIOINPCT
);