/ACCGO/T_PRMT_MD

Transparent Table Application Table
33 Fields 2 CDS Views

Pricing Master Data

/ACCGO/T_PRMT_MD is an SAP database table in S/4HANA. Pricing Master Data. It contains 33 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ACMTrdgContrPrcgMaster view from BASIC Pricing Master Data
P_ACCGOPMMD view from BASIC

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY program_id /ACCGO/E_PROG_ID Program ID
program_name /ACCGO/E_PROG_NAME Program Name
external_code /ACCGO/E_EXT_CODE External Code
program_family /ACCGO/E_PGM_FAM Program Family
program_type /ACCGO/E_PGM_TYPE Program Type
external_code_pt /ACCGO/E_EXT_CODE_PT Program Type (Code)
sign_up_start_date /ACCGO/E_START_DAT Signup Start Date
sign_up_end_date /ACCGO/E_END_DAT Signup End Date
pricing_start_date /ACCGO/E_PR_SDATE PR SDat
pricing_end_date /ACCGO/E_PR_EDATE Pricing End Date
maturity_code TBA_CONTRACT_CODE Contr. Maturity Code
crop_year /ACCGO/E_CROP_YEAR Crop Year
marketing_timing /ACCGO/E_MARKET_TIMING Market Timing
price_futures /ACCGO/E_PRICE_FUTURES Futures Pricing
price_futures_text /ACCGO/E_PRICE_FUTURES_TEXT Price Futures Text
minimum_price /ACCGO/E_MINUMUM_PRICE Minimum Price
target_price /ACCGO/E_TARGET_PRICE Target Price
maximum_price /ACCGO/E_MAXIMUM_PRICE Maximum Price
currency KONWA Cond. Currency
unit_of_measurement /ACCGO/E_UOM Unit of Measure
per_quantity EPEIN Price Unit
status /ACCGO/E_STAT Stat
status_text /ACCGO/E_PM_STATUS_TEXT Status Text
free_text /ACCGO/E_FREE_TEXT Free Text
contingent_offer /ACCGO/E_CONTINGENT_OFFER Contingent Offer
contingent_offer_text /ACCGO/E_CONTINGENT_OFFER_TEXT Cont. Offer Text
created_by /ACCGO/E_CREATED_BY Created By
created_on /ACCGO/E_FCREATED_ON CrtdOn
created_tstmp TIMESTAMP Time Stamp
changed_by /ACCGO/E_CHANGED_BY Changed By
changed_on /ACCGO/E_FCHANGED_ON Changed On
changed_tstmp TIMESTAMP Time Stamp

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.

-- Pricing Master Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /ACCGO/T_PRMT_MD (
    MANDT,                  -- Client [MANDT]
    PROGRAM_ID,             -- Program ID [/ACCGO/E_PROG_ID]
    PROGRAM_NAME,           -- Program Name [/ACCGO/E_PROG_NAME]
    EXTERNAL_CODE,          -- External Code [/ACCGO/E_EXT_CODE]
    PROGRAM_FAMILY,         -- Program Family [/ACCGO/E_PGM_FAM]
    PROGRAM_TYPE,           -- Program Type [/ACCGO/E_PGM_TYPE]
    EXTERNAL_CODE_PT,       -- Program Type (Code) [/ACCGO/E_EXT_CODE_PT]
    SIGN_UP_START_DATE,     -- Signup Start Date [/ACCGO/E_START_DAT]
    SIGN_UP_END_DATE,       -- Signup End Date [/ACCGO/E_END_DAT]
    PRICING_START_DATE,     -- PR SDat [/ACCGO/E_PR_SDATE]
    PRICING_END_DATE,       -- Pricing End Date [/ACCGO/E_PR_EDATE]
    MATURITY_CODE,          -- Contr. Maturity Code [TBA_CONTRACT_CODE]
    CROP_YEAR,              -- Crop Year [/ACCGO/E_CROP_YEAR]
    MARKETING_TIMING,       -- Market Timing [/ACCGO/E_MARKET_TIMING]
    PRICE_FUTURES,          -- Futures Pricing [/ACCGO/E_PRICE_FUTURES]
    PRICE_FUTURES_TEXT,     -- Price Futures Text [/ACCGO/E_PRICE_FUTURES_TEXT]
    MINIMUM_PRICE,          -- Minimum Price [/ACCGO/E_MINUMUM_PRICE]
    TARGET_PRICE,           -- Target Price [/ACCGO/E_TARGET_PRICE]
    MAXIMUM_PRICE,          -- Maximum Price [/ACCGO/E_MAXIMUM_PRICE]
    CURRENCY,               -- Cond. Currency [KONWA]
    UNIT_OF_MEASUREMENT,    -- Unit of Measure [/ACCGO/E_UOM]
    PER_QUANTITY,           -- Price Unit [EPEIN]
    STATUS,                 -- Stat [/ACCGO/E_STAT]
    STATUS_TEXT,            -- Status Text [/ACCGO/E_PM_STATUS_TEXT]
    FREE_TEXT,              -- Free Text [/ACCGO/E_FREE_TEXT]
    CONTINGENT_OFFER,       -- Contingent Offer [/ACCGO/E_CONTINGENT_OFFER]
    CONTINGENT_OFFER_TEXT,  -- Cont. Offer Text [/ACCGO/E_CONTINGENT_OFFER_TEXT]
    CREATED_BY,             -- Created By [/ACCGO/E_CREATED_BY]
    CREATED_ON,             -- CrtdOn [/ACCGO/E_FCREATED_ON]
    CREATED_TSTMP,          -- Time Stamp [TIMESTAMP]
    CHANGED_BY,             -- Changed By [/ACCGO/E_CHANGED_BY]
    CHANGED_ON,             -- Changed On [/ACCGO/E_FCHANGED_ON]
    CHANGED_TSTMP,          -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (MANDT, PROGRAM_ID)
);

Learn More