P_PRASP_DISTR

31 Fields 2 CDS Views

Generated Table for View

P_PRASP_DISTR is an SAP database table in S/4HANA. Generated Table for View. It contains 31 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_ACCGO_APPDOC_DTLS view left_outer BASIC
P_ACCGO_STOR_DTLS view left_outer BASIC

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
type_from WLF_SHADOW_DOC_TYPE Document Type
document_from WLF_GENERIC_DOC_NUM DocNum
item_from WLF_GENERIC_ITEM_NUM Item Number
side_from WLF_PR_SIDE_FROM Side From
sub_item_from WLF_GENERIC_SUB_ITEM_NUM SubItemNumber
tkonn TKONN Trading Contract
tposn TPOSN Item Number
side_to WLF_PR_SIDE_TO Side To
tposn_com WLF_TPOSN_COM Com. item num.
assgd_quan WLF_ASSGD_QUANTITY_IND AssignedQuan
assgd_quan_orig WLF_ASSGD_QUANTITY_ORIG AssignedQuanOrig
assgd_uom WLF_ASSGD_UOM Assigned UoM
a_guid WLF_ASSGMT_GUID Assignment GUID
pred_a_guid WLF_PRED_ASSGMT_GUID PrAssgmtGUID
pred_quan WLF_PRED_ASSGD_QUANTITY PredAssgdQuan
frozen WLF_ASSGMT_FROZEN AssgmtFrozen
cr_name ERNAM Created By
cr_date ERDAT Created On
cr_time WLF_ERZEIT Created At
ch_name AENAM Changed By
ch_date AEDAT Changed On
ch_time AEZEIT Changed At
cancel_flag WLF_CANCEL Cancel
_dataaging DATA_TEMPERATURE Data Aging
place_holder abap.char
contract_number TKONN Trading Contract
contract_item_number TPOSN Item Number
pricing_aspect_id WLF_PR_ASPECT Pricing Aspect
pricing_aspect_counter WLF_PR_COUNT Aspect Counter
price_fixation_number CPET_TERMNO Term Number

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PRASP_DISTR (
    MANDT,                   -- Client [MANDT]
    TYPE_FROM,               -- Document Type [WLF_SHADOW_DOC_TYPE]
    DOCUMENT_FROM,           -- DocNum [WLF_GENERIC_DOC_NUM]
    ITEM_FROM,               -- Item Number [WLF_GENERIC_ITEM_NUM]
    SIDE_FROM,               -- Side From [WLF_PR_SIDE_FROM]
    SUB_ITEM_FROM,           -- SubItemNumber [WLF_GENERIC_SUB_ITEM_NUM]
    TKONN,                   -- Trading Contract [TKONN]
    TPOSN,                   -- Item Number [TPOSN]
    SIDE_TO,                 -- Side To [WLF_PR_SIDE_TO]
    TPOSN_COM,               -- Com. item num. [WLF_TPOSN_COM]
    ASSGD_QUAN,              -- AssignedQuan [WLF_ASSGD_QUANTITY_IND]
    ASSGD_QUAN_ORIG,         -- AssignedQuanOrig [WLF_ASSGD_QUANTITY_ORIG]
    ASSGD_UOM,               -- Assigned UoM [WLF_ASSGD_UOM]
    A_GUID,                  -- Assignment GUID [WLF_ASSGMT_GUID]
    PRED_A_GUID,             -- PrAssgmtGUID [WLF_PRED_ASSGMT_GUID]
    PRED_QUAN,               -- PredAssgdQuan [WLF_PRED_ASSGD_QUANTITY]
    FROZEN,                  -- AssgmtFrozen [WLF_ASSGMT_FROZEN]
    CR_NAME,                 -- Created By [ERNAM]
    CR_DATE,                 -- Created On [ERDAT]
    CR_TIME,                 -- Created At [WLF_ERZEIT]
    CH_NAME,                 -- Changed By [AENAM]
    CH_DATE,                 -- Changed On [AEDAT]
    CH_TIME,                 -- Changed At [AEZEIT]
    CANCEL_FLAG,             -- Cancel [WLF_CANCEL]
    _DATAAGING,              -- Data Aging [DATA_TEMPERATURE]
    PLACE_HOLDER,            -- abap.char
    CONTRACT_NUMBER,         -- Trading Contract [TKONN]
    CONTRACT_ITEM_NUMBER,    -- Item Number [TPOSN]
    PRICING_ASPECT_ID,       -- Pricing Aspect [WLF_PR_ASPECT]
    PRICING_ASPECT_COUNTER,  -- Aspect Counter [WLF_PR_COUNT]
    PRICE_FIXATION_NUMBER,   -- Term Number [CPET_TERMNO]
    PRIMARY KEY (MANDT)
);

Learn More