P_PURCHASEORDERCOMMITMENT

CDS View
22 Fields 1 CDS Views

Purchase Order Private View for Commitments

P_PURCHASEORDERCOMMITMENT is a CDS View in S/4HANA. Purchase Order Private View for Commitments. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_PurchaseOrderCommitment view from CONSUMPTION Commitments of Purchase Order

Fields (22)

KeyField CDS FieldsUsed in Views
KEY AccountAssignment AccountAssignment 1
KEY AccountAssignmentType AccountAssignmentType 1
KEY BudgetPeriod BudgetPeriod 1
KEY CashLedgerAccount CashLedgerAccount 1
KEY CompanyCode CompanyCode 1
KEY CostCenter CostCenter 1
KEY FiscalYearPeriod FiscalYearPeriod 1
KEY FunctionalArea FunctionalArea 1
KEY Fund Fund 1
KEY GLAccount GLAccount 1
KEY GrantID GrantID 1
KEY ProfitCenter ProfitCenter 1
KEY PubSecBudgetAccount PubSecBudgetAccount 1
KEY PubSecBudgetAccountCoCode PubSecBudgetAccountCoCode 1
KEY PubSecBudgetCnsmpnType PubSecBudgetCnsmpnType 1
KEY PubSecBudgetIsRelevant PubSecBudgetIsRelevant 1
KEY SponsoredClass SponsoredClass 1
KEY SponsoredProgram SponsoredProgram 1
KEY WBSElement WBSElement 1
KEY WBSElementInternalID WBSElementInternalID 1
_FunctionalArea _FunctionalArea 1
PurchaseOrderItemText DocumentItemText 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.

-- Purchase Order Private View for Commitments
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PURCHASEORDERCOMMITMENT (
    ACCOUNTASSIGNMENT,
    ACCOUNTASSIGNMENTTYPE,
    BUDGETPERIOD,
    CASHLEDGERACCOUNT,
    COMPANYCODE,
    COSTCENTER,
    FISCALYEARPERIOD,
    FUNCTIONALAREA,
    FUND,
    GLACCOUNT,
    GRANTID,
    PROFITCENTER,
    PUBSECBUDGETACCOUNT,
    PUBSECBUDGETACCOUNTCOCODE,
    PUBSECBUDGETCNSMPNTYPE,
    PUBSECBUDGETISRELEVANT,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    _FUNCTIONALAREA,
    PURCHASEORDERITEMTEXT,
    PRIMARY KEY (ACCOUNTASSIGNMENT, ACCOUNTASSIGNMENTTYPE, BUDGETPERIOD, CASHLEDGERACCOUNT, COMPANYCODE, COSTCENTER, FISCALYEARPERIOD, FUNCTIONALAREA, FUND, GLACCOUNT, GRANTID, PROFITCENTER, PUBSECBUDGETACCOUNT, PUBSECBUDGETACCOUNTCOCODE, PUBSECBUDGETCNSMPNTYPE, PUBSECBUDGETISRELEVANT, SPONSOREDCLASS, SPONSOREDPROGRAM, WBSELEMENT, WBSELEMENTINTERNALID)
);

Learn More