R_CONDITIONCONTRACTDEX

CDS View
73 Fields 1 CDS Views

Condition Contract Extraction

R_CONDITIONCONTRACTDEX is a CDS View in S/4HANA. Condition Contract Extraction. It contains 73 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ConditionContractDEX view_entity from CONSUMPTION Condition Contract Extraction

Fields (73)

KeyField CDS FieldsUsed in Views
_Customer _Customer 1
_PersonWorkAgreement _PersonWorkAgreement 1
_PriorSupplier _PriorSupplier 1
_Supplier _Supplier 1
AccrualClearingSettlmtCalendar AccrualClearingSettlmtCalendar 1
AccrualUpdateIsRequired AccrualUpdateIsRequired 1
AmountFieldGroup AmountFieldGroup 1
BasicConditionContract BasicConditionContract 1
BusVolTableGroup BusVolTableGroup 1
CashDiscount1Days CashDiscount1Days 1
CashDiscount1Percent CashDiscount1Percent 1
CashDiscount2Days CashDiscount2Days 1
CashDiscount2Percent CashDiscount2Percent 1
CndnContrActvtnStatus CndnContrActvtnStatus 1
CndnContrAssgmtRef CndnContrAssgmtRef 1
CndnContrClassfctnType CndnContrClassfctnType 1
CndnContrCurrency CndnContrCurrency 1
CndnContrCustSettlmtCat CndnContrCustSettlmtCat 1
CndnContrExtensionCalendar CndnContrExtensionCalendar 1
CndnContrExternalPartner CndnContrExternalPartner 1
CndnContrPointsQtyUnit CndnContrPointsQtyUnit 1
CndnContrProcVar CndnContrProcVar 1
CndnContrPurposeCat CndnContrPurposeCat 1
CndnContrSemanticCode CndnContrSemanticCode 1
CndnContrSourceDoc CndnContrSourceDoc 1
CndnContrSourceDocCat CndnContrSourceDocCat 1
CndnContrSourceDocItem CndnContrSourceDocItem 1
CndnContrSuplrSettlmtCat CndnContrSuplrSettlmtCat 1
CndnContrType CndnContrType 1
CndnContrUnit CndnContrUnit 1
CndnContrValidFrom CndnContrValidFrom 1
CndnContrValidTo CndnContrValidTo 1
CndnContrVolumeUnit CndnContrVolumeUnit 1
CndnContrWeightUnit CndnContrWeightUnit 1
CndnContrWorkerCostCenter CndnContrWorkerCostCenter 1
CompanyCode CompanyCode 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreationTime CreationTime 1
CreationTimeZone CreationTimeZone 1
CreationUTCDateTime CreationUTCDateTime 1
Customer Customer 1
DeltaAccrualSettlmtCalendar DeltaAccrualSettlmtCalendar 1
DeltaSettlmtCalendar DeltaSettlmtCalendar 1
DistributionChannel DistributionChannel 1
Division Division 1
DocumentReferenceID DocumentReferenceID 1
ExchangeRate ExchangeRate 1
ExchangeRateDate ExchangeRateDate 1
ExchangeRateType ExchangeRateType 1
ExternalDocumentReferenceID ExternalDocumentReferenceID 1
FinalSettlmtCalendar FinalSettlmtCalendar 1
LastChangedByUser LastChangedByUser 1
LastChangedDate LastChangedDate 1
LastChangeTime LastChangeTime 1
LastChangeUTCDateTime LastChangeUTCDateTime 1
NetPaymentDays NetPaymentDays 1
PartialSettlmtCalendar PartialSettlmtCalendar 1
PaymentMethod PaymentMethod 1
PaymentTerms PaymentTerms 1
PersonWorkAgreement PersonWorkAgreement 1
PrecedingConditionDocument PrecedingConditionContract 1
PriorSupplier PriorSupplier 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
SalesGroup SalesGroup 1
SalesOffice SalesOffice 1
SalesOrganization SalesOrganization 1
SettlmtPartTxRegnCntry SettlmtPartTxRegnCntry 1
SettlmtPartTxRegnNmbr SettlmtPartTxRegnNmbr 1
SettlmtProduct SettlmtProduct 1
Supplier Supplier 1
TaxCountry TaxCountry 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.

-- Condition Contract Extraction
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_CONDITIONCONTRACTDEX (
    _CUSTOMER,
    _PERSONWORKAGREEMENT,
    _PRIORSUPPLIER,
    _SUPPLIER,
    ACCRUALCLEARINGSETTLMTCALENDAR,
    ACCRUALUPDATEISREQUIRED,
    AMOUNTFIELDGROUP,
    BASICCONDITIONCONTRACT,
    BUSVOLTABLEGROUP,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    CNDNCONTRACTVTNSTATUS,
    CNDNCONTRASSGMTREF,
    CNDNCONTRCLASSFCTNTYPE,
    CNDNCONTRCURRENCY,
    CNDNCONTRCUSTSETTLMTCAT,
    CNDNCONTREXTENSIONCALENDAR,
    CNDNCONTREXTERNALPARTNER,
    CNDNCONTRPOINTSQTYUNIT,
    CNDNCONTRPROCVAR,
    CNDNCONTRPURPOSECAT,
    CNDNCONTRSEMANTICCODE,
    CNDNCONTRSOURCEDOC,
    CNDNCONTRSOURCEDOCCAT,
    CNDNCONTRSOURCEDOCITEM,
    CNDNCONTRSUPLRSETTLMTCAT,
    CNDNCONTRTYPE,
    CNDNCONTRUNIT,
    CNDNCONTRVALIDFROM,
    CNDNCONTRVALIDTO,
    CNDNCONTRVOLUMEUNIT,
    CNDNCONTRWEIGHTUNIT,
    CNDNCONTRWORKERCOSTCENTER,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CREATIONTIMEZONE,
    CREATIONUTCDATETIME,
    CUSTOMER,
    DELTAACCRUALSETTLMTCALENDAR,
    DELTASETTLMTCALENDAR,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    EXCHANGERATEDATE,
    EXCHANGERATETYPE,
    EXTERNALDOCUMENTREFERENCEID,
    FINALSETTLMTCALENDAR,
    LASTCHANGEDBYUSER,
    LASTCHANGEDDATE,
    LASTCHANGETIME,
    LASTCHANGEUTCDATETIME,
    NETPAYMENTDAYS,
    PARTIALSETTLMTCALENDAR,
    PAYMENTMETHOD,
    PAYMENTTERMS,
    PERSONWORKAGREEMENT,
    PRECEDINGCONDITIONDOCUMENT,
    PRIORSUPPLIER,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SETTLMTPARTTXREGNCNTRY,
    SETTLMTPARTTXREGNNMBR,
    SETTLMTPRODUCT,
    SUPPLIER,
    TAXCOUNTRY
);

Learn More