_ALLOCATIONTABLEITEM

15 Fields

_ALLOCATIONTABLEITEM is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
_AllocTableBlockingReason _AllocTableBlockingReason 1
_MaterialGroup _MaterialGroup 1
_Product _Product 1
_QuantityUnit _QuantityUnit 1
_RetailPromotion _RetailPromotion 1
AllocTblItmBlockReason AllocTblItmBlockReason 1
ConfirmedQuantity ConfirmedQuantity 1
CreationDate CreationDate 1
LastChangeDate LastChangeDate 1
MaterialGroup MaterialGroup 1
PlannedQuantity PlannedQuantity 1
Product Product 2
PurchaseOrder PurchaseOrder 1
QuantityUnit QuantityUnit 1
RetailPromotion RetailPromotion 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 _ALLOCATIONTABLEITEM (
    _ALLOCTABLEBLOCKINGREASON,
    _MATERIALGROUP,
    _PRODUCT,
    _QUANTITYUNIT,
    _RETAILPROMOTION,
    ALLOCTBLITMBLOCKREASON,
    CONFIRMEDQUANTITY,
    CREATIONDATE,
    LASTCHANGEDATE,
    MATERIALGROUP,
    PLANNEDQUANTITY,
    PRODUCT,
    PURCHASEORDER,
    QUANTITYUNIT,
    RETAILPROMOTION
);

Learn More