PPS_POITM_PRCG_D

Transparent Table Application Table
91 Fields 1 CDS Views

Draft table for entity R_PPS_PURORDITMPRCGELEMENTTP

PPS_POITM_PRCG_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURORDITMPRCGELEMENTTP. It contains 91 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurOrdItmPrcgElmntDrft view_entity from BASIC PurchaseOrder PrcgElement - Draft

Fields (91)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY purchaseorder EBELN Purchasing Doc.
KEY purchaseorderitem EBELP Item
KEY pricingdocument KNUMV Doc. Condition
KEY pricingdocumentitem KPOSN Item
KEY pricingprocedurestep STUNR Step Number
KEY pricingprocedurecounter VFPRC_COND_COUNT Counter
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
conditionapplication KAPPL Application
conditiontype KSCHA Condition Type
priceconditiondeterminationdte KDATU CndnPricingDate
conditioncalculationtype KRECH_LONG Calculat.Type
conditionbasevalue VFPRC_ELEMENT_BASE_VALUE Cond.Basis
conditionrateamount VFPRC_RATE_AMOUNT Condition Amount
conditionrateratio VFPRC_ELEMENT_RATIO Ratio
conditioncurrency WAERS Currency
pricedetnexchangerate KURSK_NOT_CONVERTED Exchange Rate
conditionquantity KPEIN Pricing Unit
conditionquantityunit KVMEI Condition Unit
conditiontobaseqtynmrtr VFPRC_NUMERATOR Numerator
conditiontobaseqtydnmntr VFPRC_DENOMINATOR Denominator
conditioncategory KNTYP Condit.Category
conditionisforstatistics KSTAT Statistical
pricingscaletype STFKZ Scale Type
isrelevantforaccrual KRUEK Accruals
cndnisrelevantforinvoicelist KRELI Inv.List Cond.
conditionorigin KHERK Condit.Origin
isgroupcondition KGRPE Group Condition
accessnumberofaccesssequence KOLNR Access
conditionrecord KNUMH Cond.Record No.
conditionsequentialnumber KOPOS_LONG SequNo of Cond.
accountkeyforglaccount KVSL1 Account Key
glaccount SAKNR G/L Account
taxcode MWSKZ Tax Code
acctkeyforaccrualsglaccount KVSL2 Accruals
accrualsglaccount SAKNR_ACCR Accruals Acc.
withholdingtaxcode WT_WITHCD W/Tax Code
freightsupplier LIFNR Supplier
cndnroundingoffdiffamount KDIFF CondRoundDiff.
conditionamount VFPRC_ELEMENT_VALUE Condition Value
transactioncurrency WAERK Doc. Currency
conditioncontrol KSTEU Cond.Control
conditioninactivereason KINAK Inactive
conditioninactivereasonname PRICE_ELEMENT_INACTIVE_DESCR Inactive
conditionclass KOAID Condition Class
prcgprocedurecounterforheader VFPRC_COND_COUNT_HEAD Counter
factorforconditionbasisvalue KFAKTOR CondFactor
structurecondition KDUPL Structure Cond.
periodfactorforcndnbasisvalue KFAKTOR1 CondFactor
pricingscalebasis KZBZG_LONG Scale Basis
conditionscalebasisvalue VFRPC_SCALE_BASE_VALUE Scale Base Val.
conditionscalebasisunit KONMS Scale UoM
conditionscalebasiscurrency KONWS Scale Currency
conditionalternativecurrency KWAEH Cndn Currency
conditionamountinlocalcrcy VFPRC_ELEMENT_VALUE Condition Value
cndnisrelevantforintcobilling KFKIV IntcoBillCond
conditionismanuallychanged KMPRS Changed Manual.
billingpricesource PRSQU1 Price Source
taxjurisdictionlevel TXJCD_LEVEL Jurisdiction level
conditionbytesequence KBFLAG BitFlags
cndnisrelevantforlimitvalue KOUPD Condit. Update
conditionbasislimitexceeded KMXAW Max Basis Value
conditionamountlimitexceeded KMXWR Maximum Amount
cumulatedconditionbasisvalue VFPRC_ELEMENT_BASE_VALUE Cond.Basis
customerrebaterecipient KUNNR_KO Customer
conditionisforconfiguration KVARC UsedfVarConfig
variantcondition VARCOND Variant Key
conditionacctassgmtrelevance KTREL Rel.Acc.Assig.
conditionmatrixmaintrelevance MDFLG Matrix Maint.
configblparametersandformulas CPF_GUID Form. ID in Document
conditionratevalue VFPRC_ELEMENT_AMOUNT Amount
conditionadjustedquantity KAQTY Adjusted Qty.
conditiontypename VTXTM Description
conditionbasevalueintlunit WAERS Currency
conditionbasevalueunit KOEIN Unit
conditionratevalueintlunit WAERS Currency
conditionratevalueunit WAERS Currency
taxcodename PRICE_ELEMENT_TAX_CODE_DESCR Tax Code Descr.
conditionisdeletable abap.char
pricingprocedure KALSM_D Procedure
superordinatedocument abap.char
superordinatedocumentitem abap.char
ppsfieldchangeindicatorbinary PPS_E_CONTROL_FLAG Control
purchaseorderdraftuuid SDRAFT_UUID Draft Document ID
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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.

-- Draft table for entity R_PPS_PURORDITMPRCGELEMENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_POITM_PRCG_D (
    MANDT,                           -- Client [MANDT]
    PURCHASEORDER,                   -- Purchasing Doc. [EBELN]
    PURCHASEORDERITEM,               -- Item [EBELP]
    PRICINGDOCUMENT,                 -- Doc. Condition [KNUMV]
    PRICINGDOCUMENTITEM,             -- Item [KPOSN]
    PRICINGPROCEDURESTEP,            -- Step Number [STUNR]
    PRICINGPROCEDURECOUNTER,         -- Counter [VFPRC_COND_COUNT]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    CONDITIONAPPLICATION,            -- Application [KAPPL]
    CONDITIONTYPE,                   -- Condition Type [KSCHA]
    PRICECONDITIONDETERMINATIONDTE,  -- CndnPricingDate [KDATU]
    CONDITIONCALCULATIONTYPE,        -- Calculat.Type [KRECH_LONG]
    CONDITIONBASEVALUE,              -- Cond.Basis [VFPRC_ELEMENT_BASE_VALUE]
    CONDITIONRATEAMOUNT,             -- Condition Amount [VFPRC_RATE_AMOUNT]
    CONDITIONRATERATIO,              -- Ratio [VFPRC_ELEMENT_RATIO]
    CONDITIONCURRENCY,               -- Currency [WAERS]
    PRICEDETNEXCHANGERATE,           -- Exchange Rate [KURSK_NOT_CONVERTED]
    CONDITIONQUANTITY,               -- Pricing Unit [KPEIN]
    CONDITIONQUANTITYUNIT,           -- Condition Unit [KVMEI]
    CONDITIONTOBASEQTYNMRTR,         -- Numerator [VFPRC_NUMERATOR]
    CONDITIONTOBASEQTYDNMNTR,        -- Denominator [VFPRC_DENOMINATOR]
    CONDITIONCATEGORY,               -- Condit.Category [KNTYP]
    CONDITIONISFORSTATISTICS,        -- Statistical [KSTAT]
    PRICINGSCALETYPE,                -- Scale Type [STFKZ]
    ISRELEVANTFORACCRUAL,            -- Accruals [KRUEK]
    CNDNISRELEVANTFORINVOICELIST,    -- Inv.List Cond. [KRELI]
    CONDITIONORIGIN,                 -- Condit.Origin [KHERK]
    ISGROUPCONDITION,                -- Group Condition [KGRPE]
    ACCESSNUMBEROFACCESSSEQUENCE,    -- Access [KOLNR]
    CONDITIONRECORD,                 -- Cond.Record No. [KNUMH]
    CONDITIONSEQUENTIALNUMBER,       -- SequNo of Cond. [KOPOS_LONG]
    ACCOUNTKEYFORGLACCOUNT,          -- Account Key [KVSL1]
    GLACCOUNT,                       -- G/L Account [SAKNR]
    TAXCODE,                         -- Tax Code [MWSKZ]
    ACCTKEYFORACCRUALSGLACCOUNT,     -- Accruals [KVSL2]
    ACCRUALSGLACCOUNT,               -- Accruals Acc. [SAKNR_ACCR]
    WITHHOLDINGTAXCODE,              -- W/Tax Code [WT_WITHCD]
    FREIGHTSUPPLIER,                 -- Supplier [LIFNR]
    CNDNROUNDINGOFFDIFFAMOUNT,       -- CondRoundDiff. [KDIFF]
    CONDITIONAMOUNT,                 -- Condition Value [VFPRC_ELEMENT_VALUE]
    TRANSACTIONCURRENCY,             -- Doc. Currency [WAERK]
    CONDITIONCONTROL,                -- Cond.Control [KSTEU]
    CONDITIONINACTIVEREASON,         -- Inactive [KINAK]
    CONDITIONINACTIVEREASONNAME,     -- Inactive [PRICE_ELEMENT_INACTIVE_DESCR]
    CONDITIONCLASS,                  -- Condition Class [KOAID]
    PRCGPROCEDURECOUNTERFORHEADER,   -- Counter [VFPRC_COND_COUNT_HEAD]
    FACTORFORCONDITIONBASISVALUE,    -- CondFactor [KFAKTOR]
    STRUCTURECONDITION,              -- Structure Cond. [KDUPL]
    PERIODFACTORFORCNDNBASISVALUE,   -- CondFactor [KFAKTOR1]
    PRICINGSCALEBASIS,               -- Scale Basis [KZBZG_LONG]
    CONDITIONSCALEBASISVALUE,        -- Scale Base Val. [VFRPC_SCALE_BASE_VALUE]
    CONDITIONSCALEBASISUNIT,         -- Scale UoM [KONMS]
    CONDITIONSCALEBASISCURRENCY,     -- Scale Currency [KONWS]
    CONDITIONALTERNATIVECURRENCY,    -- Cndn Currency [KWAEH]
    CONDITIONAMOUNTINLOCALCRCY,      -- Condition Value [VFPRC_ELEMENT_VALUE]
    CNDNISRELEVANTFORINTCOBILLING,   -- IntcoBillCond [KFKIV]
    CONDITIONISMANUALLYCHANGED,      -- Changed Manual. [KMPRS]
    BILLINGPRICESOURCE,              -- Price Source [PRSQU1]
    TAXJURISDICTIONLEVEL,            -- Jurisdiction level [TXJCD_LEVEL]
    CONDITIONBYTESEQUENCE,           -- BitFlags [KBFLAG]
    CNDNISRELEVANTFORLIMITVALUE,     -- Condit. Update [KOUPD]
    CONDITIONBASISLIMITEXCEEDED,     -- Max Basis Value [KMXAW]
    CONDITIONAMOUNTLIMITEXCEEDED,    -- Maximum Amount [KMXWR]
    CUMULATEDCONDITIONBASISVALUE,    -- Cond.Basis [VFPRC_ELEMENT_BASE_VALUE]
    CUSTOMERREBATERECIPIENT,         -- Customer [KUNNR_KO]
    CONDITIONISFORCONFIGURATION,     -- UsedfVarConfig [KVARC]
    VARIANTCONDITION,                -- Variant Key [VARCOND]
    CONDITIONACCTASSGMTRELEVANCE,    -- Rel.Acc.Assig. [KTREL]
    CONDITIONMATRIXMAINTRELEVANCE,   -- Matrix Maint. [MDFLG]
    CONFIGBLPARAMETERSANDFORMULAS,   -- Form. ID in Document [CPF_GUID]
    CONDITIONRATEVALUE,              -- Amount [VFPRC_ELEMENT_AMOUNT]
    CONDITIONADJUSTEDQUANTITY,       -- Adjusted Qty. [KAQTY]
    CONDITIONTYPENAME,               -- Description [VTXTM]
    CONDITIONBASEVALUEINTLUNIT,      -- Currency [WAERS]
    CONDITIONBASEVALUEUNIT,          -- Unit [KOEIN]
    CONDITIONRATEVALUEINTLUNIT,      -- Currency [WAERS]
    CONDITIONRATEVALUEUNIT,          -- Currency [WAERS]
    TAXCODENAME,                     -- Tax Code Descr. [PRICE_ELEMENT_TAX_CODE_DESCR]
    CONDITIONISDELETABLE,            -- abap.char
    PRICINGPROCEDURE,                -- Procedure [KALSM_D]
    SUPERORDINATEDOCUMENT,           -- abap.char
    SUPERORDINATEDOCUMENTITEM,       -- abap.char
    PPSFIELDCHANGEINDICATORBINARY,   -- Control [PPS_E_CONTROL_FLAG]
    PURCHASEORDERDRAFTUUID,          -- Draft Document ID [SDRAFT_UUID]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, PURCHASEORDER, PURCHASEORDERITEM, PRICINGDOCUMENT, PRICINGDOCUMENTITEM, PRICINGPROCEDURESTEP, PRICINGPROCEDURECOUNTER, DRAFTUUID)
);

Learn More