_RETAILPROMOTION

16 Fields

_RETAILPROMOTION is an SAP database table in S/4HANA. It contains 16 fields.

Fields (16)

KeyField CDS FieldsUsed in Views
_DistributionChannel _DistributionChannel 2
_PurchasingGroup _PurchasingGroup 2
_PurchasingOrganization _PurchasingOrganization 2
_RetailPromotionType _RetailPromotionType 2
_RtlPromnSalesPriceActvtnSts _RtlPromnSalesPriceActvtnSts 2
_RtlPromotionAnnouncementSts _RtlPromotionAnnouncementSts 2
_SalesOrganization _SalesOrganization 2
DistributionChannel DistributionChannel 2
PromotionAnnouncementStatus PromotionAnnouncementStatus 2
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
RetailPromotionSalesFromDate RetailPromotionSalesFromDate 3
RetailPromotionSalesToDate RetailPromotionSalesToDate 3
RetailPromotionType RetailPromotionType 2
SalesOrganization SalesOrganization 2
SalesPriceActivationStatus SalesPriceActivationStatus 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 _RETAILPROMOTION (
    _DISTRIBUTIONCHANNEL,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _RETAILPROMOTIONTYPE,
    _RTLPROMNSALESPRICEACTVTNSTS,
    _RTLPROMOTIONANNOUNCEMENTSTS,
    _SALESORGANIZATION,
    DISTRIBUTIONCHANNEL,
    PROMOTIONANNOUNCEMENTSTATUS,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    RETAILPROMOTIONSALESFROMDATE,
    RETAILPROMOTIONSALESTODATE,
    RETAILPROMOTIONTYPE,
    SALESORGANIZATION,
    SALESPRICEACTIVATIONSTATUS
);

Learn More