WB2_D_ASGT_DIST

Transparent Table Application Table
15 Fields 3 CDS Views

Assignment distributions

WB2_D_ASGT_DIST is an SAP database table in S/4HANA. Assignment distributions. It contains 15 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ACMApplAssgmtDistrData view from BASIC Assignment Distibution Data
P_ACCGO_PRASP_DTLS view left_outer BASIC
P_ACMAssignDistr view_entity from BASIC ACM Assignment Distribution Private

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY a_guid WLF_ASSGMT_GUID Assignment GUID
KEY pr_aspect WLF_PR_ASPECT Pricing Aspect
KEY pr_count WLF_PR_COUNT Aspect Counter
assgd_quan WLF_ASGT_DIST_QUANTITY_IND AsgtDistQuan
assgd_uom WLF_ASSGD_UOM Assigned UoM
ad_guid WLF_ASSIGNMENT_DISTRIB_GUID AssgmtDistribGUID
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
_dataaging DATA_TEMPERATURE Data Aging
place_holder abap.char

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.

-- Assignment distributions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WB2_D_ASGT_DIST (
    CLIENT,        -- Client [MANDT]
    A_GUID,        -- Assignment GUID [WLF_ASSGMT_GUID]
    PR_ASPECT,     -- Pricing Aspect [WLF_PR_ASPECT]
    PR_COUNT,      -- Aspect Counter [WLF_PR_COUNT]
    ASSGD_QUAN,    -- AsgtDistQuan [WLF_ASGT_DIST_QUANTITY_IND]
    ASSGD_UOM,     -- Assigned UoM [WLF_ASSGD_UOM]
    AD_GUID,       -- AssgmtDistribGUID [WLF_ASSIGNMENT_DISTRIB_GUID]
    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]
    _DATAAGING,    -- Data Aging [DATA_TEMPERATURE]
    PLACE_HOLDER,  -- abap.char
    PRIMARY KEY (CLIENT, A_GUID, PR_ASPECT, PR_COUNT)
);

Learn More