_PURREQNITEMEXTENSION

27 Fields

_PURREQNITEMEXTENSION is an SAP database table in S/4HANA. It contains 27 fields.

Fields (27)

KeyField CDS FieldsUsed in Views
PPSAutoSourcingLogHandle PPSAutoSourcingLogHandle 1
PPSConfigurableLineItemNumber PPSConfigurableLineItemNumber 6
PPSEarmarkedFundsDocument PPSEarmarkedFundsDocument 1
PPSEstimatedDeliveryDate PPSEstimatedDeliveryDate 4
PPSFiscalYear PPSFiscalYear 2
PPSIsIncrementalFundedItem PPSIsIncrementalFundedItem 1
PPSIsOptionalItem PPSIsOptionalItem 2
PPSItemIsFullyFunded PPSItemIsFullyFunded 1
PPSItemProcessType PPSItemProcessType 1
PPSOptionalItemStatus PPSOptionalItemStatus 1
PPSOptionExerciseEndDate PPSOptionExerciseEndDate 3
PPSOptionExerciseStartDate PPSOptionExerciseStartDate 2
PPSPerdOfPerfEndDate PPSPerdOfPerfEndDate 4
PPSPerdOfPerfStartDate PPSPerdOfPerfStartDate 4
PPSPurchaseRequisitionItemKey PPSPurchaseRequisitionItemKey 2
PPSPurchaseRequisitionKey PPSPurchaseRequisitionKey 1
PPSPurgDocItmDoblgnStatus PPSPurgDocItmDoblgnStatus 2
PPSPurReqnItemApprovalDate PPSPurchaseReqnApprovalDate,PPSPurReqnItemApprovalDate 4
PPSPurReqnItemCompletionStatus PPSPurReqnItemCompletionStatus 3
PPSPurReqnItemProcessingStatus PPSPurReqnItemProcessingStatus 3
PPSPurReqnItemStatus PPSPurReqnItemStatus 6
PPSPurReqnItemStatusInternal PPSPurReqnItemStatusInternal 2
PPSPurReqnSourcingType PPSPurReqnSourcingType 3
PPSResponsiblePurchaser PPSResponsiblePurchaser 4
PPSSmartNumberItem PPSSmartNumberItem 3
PPSSmartNumberItemIsManual PPSSmartNumberItemIsManual 2
PurchasingDeliveryAddressType PurchasingDeliveryAddressType 1

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 _PURREQNITEMEXTENSION (
    PPSAUTOSOURCINGLOGHANDLE,
    PPSCONFIGURABLELINEITEMNUMBER,
    PPSEARMARKEDFUNDSDOCUMENT,
    PPSESTIMATEDDELIVERYDATE,
    PPSFISCALYEAR,
    PPSISINCREMENTALFUNDEDITEM,
    PPSISOPTIONALITEM,
    PPSITEMISFULLYFUNDED,
    PPSITEMPROCESSTYPE,
    PPSOPTIONALITEMSTATUS,
    PPSOPTIONEXERCISEENDDATE,
    PPSOPTIONEXERCISESTARTDATE,
    PPSPERDOFPERFENDDATE,
    PPSPERDOFPERFSTARTDATE,
    PPSPURCHASEREQUISITIONITEMKEY,
    PPSPURCHASEREQUISITIONKEY,
    PPSPURGDOCITMDOBLGNSTATUS,
    PPSPURREQNITEMAPPROVALDATE,
    PPSPURREQNITEMCOMPLETIONSTATUS,
    PPSPURREQNITEMPROCESSINGSTATUS,
    PPSPURREQNITEMSTATUS,
    PPSPURREQNITEMSTATUSINTERNAL,
    PPSPURREQNSOURCINGTYPE,
    PPSRESPONSIBLEPURCHASER,
    PPSSMARTNUMBERITEM,
    PPSSMARTNUMBERITEMISMANUAL,
    PURCHASINGDELIVERYADDRESSTYPE
);

Learn More