P_RU_MONITOR_CONTRACTS_DS

CDS View
17 Fields 2 CDS Views

P_RU_MONITOR_CONTRACTS_DS is a CDS View in S/4HANA. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RU_CONTRACTS_VALUE_HELP view from CONSUMPTION Contracts
P_RU_MONITOR_CONTRACTS view from CONSUMPTION Contracts

Fields (17)

KeyField CDS FieldsUsed in Views
KEY BusinessPartnerContract BusinessPartnerContract 1
BusinessPartnerContractExt BusinessPartnerContractExt 1
ContractEndDate ContractEndDate 1
ContractStartDate ContractStartDate 1
CreatedByUser CreatedByUser 1
CustCoIsBusPrpsCmpltd CustCoIsBusPrpsCmpltd 1
Customer Customer 1
CustomerAccountGroup CustomerAccountGroup 1
CustomerAuthznGrp CustomerAuthznGrp 1
CustomerCompanyAuthznGroup CustomerCompanyAuthznGroup 1
CustomerIsBusPrpsCmpltd CustomerIsBusPrpsCmpltd 1
SuplrCoIsBusPrpsCmpltd SuplrCoIsBusPrpsCmpltd 1
Supplier Supplier 1
SupplierAccountGroup SupplierAccountGroup 1
SupplierAuthznGrp SupplierAuthznGrp 1
SupplierCompanyAuthznGroup SupplierCompanyAuthznGroup 1
SupplierIsBusPrpsCmpltd SupplierIsBusPrpsCmpltd 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 P_RU_MONITOR_CONTRACTS_DS (
    BUSINESSPARTNERCONTRACT,
    BUSINESSPARTNERCONTRACTEXT,
    CONTRACTENDDATE,
    CONTRACTSTARTDATE,
    CREATEDBYUSER,
    CUSTCOISBUSPRPSCMPLTD,
    CUSTOMER,
    CUSTOMERACCOUNTGROUP,
    CUSTOMERAUTHZNGRP,
    CUSTOMERCOMPANYAUTHZNGROUP,
    CUSTOMERISBUSPRPSCMPLTD,
    SUPLRCOISBUSPRPSCMPLTD,
    SUPPLIER,
    SUPPLIERACCOUNTGROUP,
    SUPPLIERAUTHZNGRP,
    SUPPLIERCOMPANYAUTHZNGROUP,
    SUPPLIERISBUSPRPSCMPLTD,
    PRIMARY KEY (BUSINESSPARTNERCONTRACT)
);

Learn More