P_ARUNASSGMTSUPTYPE

CDS View

P_ARUNASSGMTSUPTYPE is a CDS View in S/4HANA. It contains 9 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
I_SupDmndAllDoc3rdPtyOrdAssgC view from COMPOSITE Cube View for Third Party Orders Assignment Details
I_SupDmndAllDocContrAssgC view from COMPOSITE Cube View for Contract Assignment Details
I_SupDmndAllDocMakeToOrdAssgC view from COMPOSITE Cube View for Make To Order Assignment Details
I_SupDmndAllDocPlndIndepRqmt1C view from COMPOSITE Cube View for Planned Independent Requirement Assignments
I_SupDmndAllDocPlndOrdComp1C view from COMPOSITE Cube View for Planned Order Components Assignment Details
I_SupDmndAllDocProdnOrdComp1C view from COMPOSITE Cube View for Production Order Components Assignment Details
I_SupDmndAllDocPurOrdComp1C view from COMPOSITE Cube View for Sub Contracting PO Components Assignments
I_SupDmndAllDocPurReqnComp1C view from COMPOSITE Cube View for Sub Contracting PR Components Assignments
I_SupDmndAllDocPurToOrdAssgC view from COMPOSITE Cube View for Purchase To Order Assignment Details
I_SupDmndAllDocRetsSupAssgC view from COMPOSITE Cube View for Returns from PO/STO Assignment Details
I_SupDmndAllDocSlsOrdAssgC view from COMPOSITE Cube View for Sales Order Assignment Details
I_SupDmndAllDocStkTransptReq1C view from COMPOSITE Cube View for Stock Transport Requisition Assignment Details
I_SupDmndAllDocSTOAssgC view from COMPOSITE Cube View for Stock Transport Order Assignment Details
I_SupDmndAllDocSupProt1C view from COMPOSITE Supply Protection Assignment Details

Fields (9)

KeyField CDS FieldsUsed in Views
KEY AssignedSupplyType AssignedSupplyType 14
KEY ProductAvailabilityDate ProductAvailabilityDate 1
KEY RequestedDate RequestedDate 1
KEY SupAssgmtSource SupAssgmtSource 14
ARunTmpAssignedQuantityInBsUnt ARunTmpAssignedQuantityInBsUnt 14
AssignedQuantityInBaseUnit AssignedQuantityInBaseUnit 13
BaseUnit BaseUnit 1
NormalAssignedQuantityInBsUnt NormalAssignedQuantityInBsUnt 13
PreviewAssignedQuantityInBsUnt PreviewAssignedQuantityInBsUnt 13

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 P_ARUNASSGMTSUPTYPE (
    ASSIGNEDSUPPLYTYPE,
    PRODUCTAVAILABILITYDATE,
    REQUESTEDDATE,
    SUPASSGMTSOURCE,
    ARUNTMPASSIGNEDQUANTITYINBSUNT,
    ASSIGNEDQUANTITYINBASEUNIT,
    BASEUNIT,
    NORMALASSIGNEDQUANTITYINBSUNT,
    PREVIEWASSIGNEDQUANTITYINBSUNT,
    PRIMARY KEY (ASSIGNEDSUPPLYTYPE, PRODUCTAVAILABILITYDATE, REQUESTEDDATE, SUPASSGMTSOURCE)
);