PERSISTENCE

44 Fields

PERSISTENCE is an SAP database table in S/4HANA. It contains 44 fields.

Fields (44)

KeyField CDS FieldsUsed in Views
KEY LoadDataCaptureObjId LoadDataCaptureObjId 2
KEY PurchaseOrder PurchaseOrder 3
KEY PurchaseOrderItem PurchaseOrderItem 3
KEY SalesOrder SalesOrder 3
KEY SalesOrderItem SalesOrderItem 3
KEY TradingContractItem TradingContractItem 2
KEY TradingContractNumber TradingContractNumber 2
ii_quantity_emo ii_quantity_emo 1
ii_unit_emo ii_unit_emo 1
ppsconfigurablelineitemnumber PPSconfigurablelineitemnumber 2
ppsguaranteedminimumamount PPSGuaranteedMinimumAmount 4
ppsguaranteedminimumcurrency PPSGuaranteedMinimumCurrency 4
ppshdrdownpaymentdays PPSHdrDownpaymentDays 2
ppshdrdownpaymentpercent PPSHdrDownpaymentPercent 2
ppshdrdownpaymenttype PPSHdrDownpaymentType 2
ppshdrretentionpercent PPSHdrRetentionPercent 2
ppshdrretentiontype PPSHdrRetentionType 2
ppsisacceptedatorigin PPSIsAcceptedAtOrigin 2
ppsisguaranteedminimumforitem PPSIsGuaranteedMinimumForItem 2
ppsisoptionalitem PPSIsOptionalItem 2
ppsitmdownpaymentdays PPSItmDownPaymentDays 2
ppsitmdownpaymentpercent PPSItmDownPaymentPercent 2
ppsitmdownpaymenttype PPSItmDownPaymentType 2
ppsitmretentionpercent PPSItmRetentionPercent 2
ppsmodificationtype PPSModificationType 1
ppsmodificationtypetext PPSModificationTypeText 1
ppsoptionexerciseenddate PPSOptionExerciseEndDate 2
ppsoptionexercisestartdate PPSOptionExerciseStartDate 2
ppsperdofperfenddate PPSPerdOfPerfEndDate 3
ppsperdofperfstartdate PPSPerdOfPerfStartDate 3
ppsrevisioncomment PPSRevisionComment 1
ppsrevisionreasoncode PPSRevisionReasonCode 1
ppssmartdocumentnumber PPSSmartDocumentNumber 2
ppssmartnumberheader PPSSmartNumberHeader 1
ppssmartnumberheaderismanual PPSSmartNumberHeaderIsManual 1
ppssrcgprojnmbrofmodification PPSSrcgProjNmbrOfModification 1
ppssrcgprojopngdatetime PPSSrcgProjOpngDateTime 1
ppssrcgprojprepublishsts PPSSrcgProjPrePublishSts 1
ppssrcgprojproceduretype PPSSrcgProjProcedureType 1
ppssrcgprojstrtdatetime PPSSrcgProjStrtDateTime 1
ppssrcprjbindgperdenddate PPSSrcPrjBindgPerdEndDate 2
ppssrcprjsuplrregnddlndatetime PPSSrcPrjSuplrRegndDlnDateTime 1
ppssuplrqtnfllwondocsts PPSSuplrQtnFllwOnDocSts 1
simulated simulated 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 PERSISTENCE (
    LOADDATACAPTUREOBJID,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    SALESORDER,
    SALESORDERITEM,
    TRADINGCONTRACTITEM,
    TRADINGCONTRACTNUMBER,
    II_QUANTITY_EMO,
    II_UNIT_EMO,
    PPSCONFIGURABLELINEITEMNUMBER,
    PPSGUARANTEEDMINIMUMAMOUNT,
    PPSGUARANTEEDMINIMUMCURRENCY,
    PPSHDRDOWNPAYMENTDAYS,
    PPSHDRDOWNPAYMENTPERCENT,
    PPSHDRDOWNPAYMENTTYPE,
    PPSHDRRETENTIONPERCENT,
    PPSHDRRETENTIONTYPE,
    PPSISACCEPTEDATORIGIN,
    PPSISGUARANTEEDMINIMUMFORITEM,
    PPSISOPTIONALITEM,
    PPSITMDOWNPAYMENTDAYS,
    PPSITMDOWNPAYMENTPERCENT,
    PPSITMDOWNPAYMENTTYPE,
    PPSITMRETENTIONPERCENT,
    PPSMODIFICATIONTYPE,
    PPSMODIFICATIONTYPETEXT,
    PPSOPTIONEXERCISEENDDATE,
    PPSOPTIONEXERCISESTARTDATE,
    PPSPERDOFPERFENDDATE,
    PPSPERDOFPERFSTARTDATE,
    PPSREVISIONCOMMENT,
    PPSREVISIONREASONCODE,
    PPSSMARTDOCUMENTNUMBER,
    PPSSMARTNUMBERHEADER,
    PPSSMARTNUMBERHEADERISMANUAL,
    PPSSRCGPROJNMBROFMODIFICATION,
    PPSSRCGPROJOPNGDATETIME,
    PPSSRCGPROJPREPUBLISHSTS,
    PPSSRCGPROJPROCEDURETYPE,
    PPSSRCGPROJSTRTDATETIME,
    PPSSRCPRJBINDGPERDENDDATE,
    PPSSRCPRJSUPLRREGNDDLNDATETIME,
    PPSSUPLRQTNFLLWONDOCSTS,
    SIMULATED,
    PRIMARY KEY (LOADDATACAPTUREOBJID, PURCHASEORDER, PURCHASEORDERITEM, SALESORDER, SALESORDERITEM, TRADINGCONTRACTITEM, TRADINGCONTRACTNUMBER)
);

Learn More