I_CONDITIONCONTRACT

CDS View
75 Fields 22 CDS Views

Condition Contract

I_CONDITIONCONTRACT is a CDS View in S/4HANA. Condition Contract. It contains 75 fields. 22 CDS views read from this table.

CDS Views using this table (22)

ViewTypeJoinVDMDescription
C_CndnContrOPg view from CONSUMPTION Condition Contract Object Page
C_CndnContrWrkflwRel view from CONSUMPTION cds-view to release workflow scenarios for CndnContr
C_CndnContrWrkflwRelReWrk view from CONSUMPTION cds-view to rework workflow scenarios for CndnContr
C_CndnContrWrkflwSettlmtRel view from CONSUMPTION cds-view to release settlmt workflow scenarios for CndnContr
C_CndnContrWrkflwSettlmtReWrk view from CONSUMPTION cds-view to rework settlmt workflow scenarios for CndnContr
C_MngCustCndnContr view from CONSUMPTION Monitor Customer Condition Contracts
C_MngSuplrCndnContr view from CONSUMPTION Monitor Supplier Condition Contracts
C_MntrRoytyCndnContr view_entity from CONSUMPTION Monitor Royalty Condition Contracts
ESH_B_CNDNCONTR view from Enterprise Search for Condition Contracts "Basicview"
I_CndnContrCustomerListStdVH view from COMPOSITE Condition Contract Customer List
I_CndnContrCustomerStdVH view from COMPOSITE Customer Condition Contracts
I_CndnContrExtSlsCommsnStdVH view_entity from COMPOSITE External Sales Commissions
I_CndnContrPlantListStdVH view from COMPOSITE Condition Contract Plant List
I_CndnContrPurgRbteStdVH view_entity from COMPOSITE Purchasing Rebate Condition Contracts
I_CndnContrRoyaltyStdVH view from COMPOSITE Royalty Condition Contracts
I_CndnContrSupplierListStdVH view from COMPOSITE Condition Contract Supplier List
I_CndnContrSupplierStdVH view from COMPOSITE Supplier Condition Contracts
I_ConditionContractStdVH view from COMPOSITE Condition Contract
I_TrdCndnContrChkBook view from COMPOSITE TMA Condition Contract Checkbook
P_CndnContrOPg view from CONSUMPTION Enhanced View for C_CndnContrOPg
R_CndnContrActiveStatus view inner BASIC Active Status of Condition Contract
R_CndnContrPlainLongText view inner BASIC Plain Long Texts of a Condition Contract

Fields (75)

KeyField CDS FieldsUsed in Views
KEY ConditionContract ConditionContract 18
_CndnContrClassfctnType _CndnContrClassfctnType 4
_CndnContrCurrency _CndnContrCurrency 3
_CndnContrIsInactive _CndnContrIsInactive 3
_CndnContrPointsQtyUnit _CndnContrPointsQtyUnit 3
_CndnContrProcVar _CndnContrProcVar 3
_CndnContrPurposeCat _CndnContrPurposeCat 3
_CndnContrSourceDocCat _CndnContrSourceDocCat 3
_CndnContrType _CndnContrType 3
_CndnContrUnit _CndnContrUnit 3
_CndnContrVolumeUnit _CndnContrVolumeUnit 3
_CndnContrWeightUnit _CndnContrWeightUnit 3
_CompanyCode _CompanyCode 3
_Customer _Customer 8
_DistributionChannel _DistributionChannel 3
_Division _Division 3
_PersonWorkAgreement _PersonWorkAgreement 8
_PriorSupplier _PriorSupplier 8
_PurchasingGroup _PurchasingGroup 3
_PurchasingOrganization _PurchasingOrganization 3
_SalesGroup _SalesGroup 3
_SalesOffice _SalesOffice 3
_SalesOrganization _SalesOrganization 3
_SettlmtProduct _SettlmtProduct 3
_Supplier _Supplier 8
AccrualUpdateIsRequired AccrualUpdateIsRequired 3
AmountFieldGroup AmountFieldGroup 1
AssignmentReference AssignmentReference 1
CashDiscount1Days CashDiscount1Days 3
CashDiscount1Percent CashDiscount1Percent 3
CashDiscount2Days CashDiscount2Days 3
CashDiscount2Percent CashDiscount2Percent 3
CndnContrAssgmtRef CndnContrAssgmtRef 3
CndnContrClassfctnType CndnContrClassfctnType 5
CndnContrCurrency CndnContrCurrency 4
CndnContrCustSettlmtCat CndnContrCustSettlmtCat 1
CndnContrExtensionCalendar CndnContrExtensionCalendar 1
CndnContrExternalPartner CndnContrExternalPartner 4
CndnContrIsInactive CndnContrIsInactive 9
CndnContrPointsQtyUnit CndnContrPointsQtyUnit 3
CndnContrProcVar CndnContrProcVar 3
CndnContrPurposeCat CndnContrPurposeCat 4
CndnContrSourceDoc CndnContrSourceDoc 4
CndnContrSourceDocCat CndnContrSourceDocCat 4
CndnContrSourceUUID CndnContrSourceUUID 3
CndnContrType CndnContrType 13
CndnContrUnit CndnContrUnit 3
CndnContrUUID CndnContrUUID 4
CndnContrValidFrom CndnContrValidFrom 17
CndnContrValidTo CndnContrValidTo 17
CndnContrVolumeUnit CndnContrVolumeUnit 3
CndnContrWeightUnit CndnContrWeightUnit 3
CndnContrWorkerCostCenter CndnContrWorkerCostCenter 13
CompanyCode CompanyCode 10
CreatedByUser CreatedByUser 5
CreationDate CreationDate 2
Customer Customer 14
DistributionChannel DistributionChannel 13
Division Division 13
DocumentReferenceID DocumentReferenceID 4
ExternalDocumentReferenceID ExternalDocumentReferenceID 10
LastChangedByUser LastChangedByUser 4
LastChangedDate LastChangedDate 1
NetPaymentDays NetPaymentDays 3
PaymentMethod PaymentMethod 4
PaymentTerms PaymentTerms 3
PersonWorkAgreement PersonWorkAgreement 13
PriorSupplier PriorSupplier 12
PurchasingGroup PurchasingGroup 12
PurchasingOrganization PurchasingOrganization 12
SalesGroup SalesGroup 4
SalesOffice SalesOffice 4
SalesOrganization SalesOrganization 13
SettlmtProduct SettlmtProduct 4
Supplier Supplier 13

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.

-- Condition Contract
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CONDITIONCONTRACT (
    CONDITIONCONTRACT,
    _CNDNCONTRCLASSFCTNTYPE,
    _CNDNCONTRCURRENCY,
    _CNDNCONTRISINACTIVE,
    _CNDNCONTRPOINTSQTYUNIT,
    _CNDNCONTRPROCVAR,
    _CNDNCONTRPURPOSECAT,
    _CNDNCONTRSOURCEDOCCAT,
    _CNDNCONTRTYPE,
    _CNDNCONTRUNIT,
    _CNDNCONTRVOLUMEUNIT,
    _CNDNCONTRWEIGHTUNIT,
    _COMPANYCODE,
    _CUSTOMER,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _PERSONWORKAGREEMENT,
    _PRIORSUPPLIER,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _SALESGROUP,
    _SALESOFFICE,
    _SALESORGANIZATION,
    _SETTLMTPRODUCT,
    _SUPPLIER,
    ACCRUALUPDATEISREQUIRED,
    AMOUNTFIELDGROUP,
    ASSIGNMENTREFERENCE,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    CNDNCONTRASSGMTREF,
    CNDNCONTRCLASSFCTNTYPE,
    CNDNCONTRCURRENCY,
    CNDNCONTRCUSTSETTLMTCAT,
    CNDNCONTREXTENSIONCALENDAR,
    CNDNCONTREXTERNALPARTNER,
    CNDNCONTRISINACTIVE,
    CNDNCONTRPOINTSQTYUNIT,
    CNDNCONTRPROCVAR,
    CNDNCONTRPURPOSECAT,
    CNDNCONTRSOURCEDOC,
    CNDNCONTRSOURCEDOCCAT,
    CNDNCONTRSOURCEUUID,
    CNDNCONTRTYPE,
    CNDNCONTRUNIT,
    CNDNCONTRUUID,
    CNDNCONTRVALIDFROM,
    CNDNCONTRVALIDTO,
    CNDNCONTRVOLUMEUNIT,
    CNDNCONTRWEIGHTUNIT,
    CNDNCONTRWORKERCOSTCENTER,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMER,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTREFERENCEID,
    EXTERNALDOCUMENTREFERENCEID,
    LASTCHANGEDBYUSER,
    LASTCHANGEDDATE,
    NETPAYMENTDAYS,
    PAYMENTMETHOD,
    PAYMENTTERMS,
    PERSONWORKAGREEMENT,
    PRIORSUPPLIER,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SETTLMTPRODUCT,
    SUPPLIER,
    PRIMARY KEY (CONDITIONCONTRACT)
);

Learn More