I_SLSPRCGCNDNRECDVALIDITY
Validity of Condition Record for Pricing in Sales
I_SLSPRCGCNDNRECDVALIDITY is a CDS View in S/4HANA. Validity of Condition Record for Pricing in Sales. It contains 149 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_SlsPrcgCndnRecdValidity | view | from | BASIC | Condition Record Validity |
| I_SlsPricingConditionRecordTP | view | inner | TRANSACTIONAL | Condition Record for Pricing in Sales |
| R_SlsPrcgCndnRecdValidityTP | view_entity | from | TRANSACTIONAL | Validity of Condition Record for Pricing in Sales - TP |
Fields (149)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| AccountTaxType | AccountTaxType | 1 | |
| AdditionalCustomerGroup1 | AdditionalCustomerGroup1 | 1 | |
| AdditionalCustomerGroup2 | AdditionalCustomerGroup2 | 1 | |
| AdditionalCustomerGroup3 | AdditionalCustomerGroup3 | 1 | |
| AdditionalCustomerGroup4 | AdditionalCustomerGroup4 | 1 | |
| AdditionalCustomerGroup5 | AdditionalCustomerGroup5 | 1 | |
| AdditionalMaterialGroup1 | AdditionalMaterialGroup1 | 1 | |
| AdditionalMaterialGroup2 | AdditionalMaterialGroup2 | 1 | |
| AdditionalMaterialGroup3 | AdditionalMaterialGroup3 | 1 | |
| AdditionalMaterialGroup4 | AdditionalMaterialGroup4 | 1 | |
| AdditionalMaterialGroup5 | AdditionalMaterialGroup5 | 1 | |
| Batch | Batch | 1 | |
| BillableControl | BillableControl | 1 | |
| BillToParty | BillToParty | 1 | |
| BR_NFDocumentType | BR_NFDocumentType | 1 | |
| BR_TaxCode | BR_TaxCode | 1 | |
| BRSpcfcFreeDefinedField1 | BRSpcfcFreeDefinedField1 | 1 | |
| BRSpcfcFreeDefinedField2 | BRSpcfcFreeDefinedField2 | 1 | |
| BRSpcfcFreeDefinedField3 | BRSpcfcFreeDefinedField3 | 1 | |
| BRSpcfcTaxBasePercentageCode | BRSpcfcTaxBasePercentageCode | 1 | |
| BRSpcfcTaxDepartureRegion | BRSpcfcTaxDepartureRegion | 1 | |
| BRSpcfcTaxDestinationRegion | BRSpcfcTaxDestinationRegion | 1 | |
| BRSpcfcTxGrpDynTaxExceptions | BRSpcfcTxGrpDynTaxExceptions | 1 | |
| CityCode | CityCode | 1 | |
| CndnBillingDocumentCategory | CndnBillingDocumentCategory | 1 | |
| CommodityCode | CommodityCode | 1 | |
| ConditionContract | ConditionContract | 1 | |
| ConditionIsExclusive | ConditionIsExclusive | 1 | |
| ConditionProcessingStatus | ConditionProcessingStatus | 1 | |
| ConditionReleaseStatus | ConditionReleaseStatus | 1 | |
| ConditionScaleBasisValue | ConditionScaleBasisValue | 1 | |
| ConditionValidityEndDate | ConditionValidityEndDate | 1 | |
| ConditionValidityStartDate | ConditionValidityStartDate | 1 | |
| ConfigurationNumber | ConfigurationNumber | 1 | |
| ConsumptionTaxCtrlCode | ConsumptionTaxCtrlCode | 1 | |
| Country | Country | 1 | |
| County | County | 1 | |
| Customer | Customer | 1 | |
| CustomerConditionGroup | CustomerConditionGroup | 1 | |
| CustomerGroup | CustomerGroup | 1 | |
| CustomerHierarchy | CustomerHierarchy | 1 | |
| CustomerHierarchyNodeID | CustomerHierarchyNodeID | 1 | |
| CustomerHierarchyNodeType | CustomerHierarchyNodeType | 1 | |
| CustomerHierarchyRootNode | CustomerHierarchyRootNode | 1 | |
| CustomerPriceGroup | CustomerPriceGroup | 1 | |
| CustomerTaxClassification1 | CustomerTaxClassification1 | 1 | |
| CustomerTaxClassification2 | CustomerTaxClassification2 | 1 | |
| CustomerTaxClassification3 | CustomerTaxClassification3 | 1 | |
| CustomerTaxClassification4 | CustomerTaxClassification4 | 1 | |
| CustomerTaxClassification5 | CustomerTaxClassification5 | 1 | |
| CustomerTaxClassification6 | CustomerTaxClassification6 | 1 | |
| CustomerTaxClassification7 | CustomerTaxClassification7 | 1 | |
| CustomerTaxClassification8 | CustomerTaxClassification8 | 1 | |
| CustomerTaxClassification9 | CustomerTaxClassification9 | 1 | |
| DepartureCountry | DepartureCountry | 1 | |
| DestinationCountry | DestinationCountry | 1 | |
| DistributionChannel | DistributionChannel | 1 | |
| Division | Division | 1 | |
| EngagementProject | EngagementProject | 1 | |
| EngagementProjectServiceOrg | EngagementProjectServiceOrg | 1 | |
| Equipment | Equipment | 1 | |
| IncotermsClassification | IncotermsClassification | 1 | |
| IncotermsTransferLocation | IncotermsTransferLocation | 1 | |
| Industry | Industry | 1 | |
| InternationalArticleNumber | InternationalArticleNumber | 1 | |
| LocalSalesTaxApplicabilityCode | LocalSalesTaxApplicabilityCode | 1 | |
| MainItemMaterialPricingGroup | MainItemMaterialPricingGroup | 1 | |
| MainItemPricingRefMaterial | MainItemPricingRefMaterial | 1 | |
| Material | Material | 1 | |
| MaterialCommissionGroup | MaterialCommissionGroup | 1 | |
| MaterialExternalGroup | MaterialExternalGroup | 1 | |
| MaterialGroup | MaterialGroup | 1 | |
| MaterialPricingGroup | MaterialPricingGroup | 1 | |
| MatUsageIndicator | MatUsageIndicator | 1 | |
| OrderQuantityUnit | OrderQuantityUnit | 1 | |
| OrderType | OrderType | 1 | |
| PayerParty | PayerParty | 1 | |
| Personnel | Personnel | 1 | |
| Plant | Plant | 1 | |
| PlantCity | PlantCity | 1 | |
| PlantCounty | PlantCounty | 1 | |
| PlantRegion | PlantRegion | 1 | |
| PostalCode | PostalCode | 1 | |
| PriceListType | PriceListType | 1 | |
| PricingDate | PricingDate | 1 | |
| ProductHierarchyNode | ProductHierarchyNode | 1 | |
| ProductHierarchyNode1 | ProductHierarchyNode1 | 1 | |
| ProductHierarchyNode2 | ProductHierarchyNode2 | 1 | |
| ProductHierarchyNode3 | ProductHierarchyNode3 | 1 | |
| ProductHierarchyNode4 | ProductHierarchyNode4 | 1 | |
| ProductHierarchyNode5 | ProductHierarchyNode5 | 1 | |
| ProductHierarchyNode6 | ProductHierarchyNode6 | 1 | |
| ProductHierarchyNode7 | ProductHierarchyNode7 | 1 | |
| ProductHierarchyNode8 | ProductHierarchyNode8 | 1 | |
| ProductHierarchyNode9 | ProductHierarchyNode9 | 1 | |
| ProductTaxClassification1 | ProductTaxClassification1 | 1 | |
| ProductTaxClassification2 | ProductTaxClassification2 | 1 | |
| ProductTaxClassification3 | ProductTaxClassification3 | 1 | |
| ProductTaxClassification4 | ProductTaxClassification4 | 1 | |
| ProductTaxClassification5 | ProductTaxClassification5 | 1 | |
| ProductTaxClassification6 | ProductTaxClassification6 | 1 | |
| ProductTaxClassification7 | ProductTaxClassification7 | 1 | |
| ProductTaxClassification8 | ProductTaxClassification8 | 1 | |
| ProductTaxClassification9 | ProductTaxClassification9 | 1 | |
| ProdUnivHierarchyNode | ProdUnivHierarchyNode | 1 | |
| PurgDocSupplyingPlant | PurgDocSupplyingPlant | 1 | |
| ReferenceSDDocument | ReferenceSDDocument | 1 | |
| ReferenceSDDocumentItem | ReferenceSDDocumentItem | 1 | |
| Region | Region | 1 | |
| RequirementSegment | RequirementSegment | 1 | |
| ReturnReason | ReturnReason | 1 | |
| ReturnsRefundExtent | ReturnsRefundExtent | 1 | |
| SalesDistrict | SalesDistrict | 1 | |
| SalesDocument | SalesDocument | 1 | |
| SalesDocumentItem | SalesDocumentItem | 1 | |
| SalesDocumentType | SalesDocumentType | 1 | |
| SalesGroup | SalesGroup | 1 | |
| SalesOffice | SalesOffice | 1 | |
| SalesOrderSalesOrganization | SalesOrderSalesOrganization | 1 | |
| SalesOrganization | SalesOrganization | 1 | |
| SalesSDDocumentCategory | SalesSDDocumentCategory | 1 | |
| SDDocument | SDDocument | 1 | |
| SDDocumentItem | SDDocumentItem | 1 | |
| SDDocumentReason | SDDocumentReason | 1 | |
| ServiceDocument | ServiceDocument | 1 | |
| ServiceDocumentItem | ServiceDocumentItem | 1 | |
| ShippingCondition | ShippingCondition | 1 | |
| ShippingPoint | ShippingPoint | 1 | |
| ShippingType | ShippingType | 1 | |
| ShipToParty | ShipToParty | 1 | |
| SoldToParty | SoldToParty | 1 | |
| StockSegment | StockSegment | 1 | |
| SubscriptionContractDuration | SubscriptionContractDuration | 1 | |
| SubscriptionContractLockReason | SubscriptionContractLockReason | 1 | |
| SubscrpnContrDurationUnit | SubscrpnContrDurationUnit | 1 | |
| Supplier | Supplier | 1 | |
| TaxCode | TaxCode | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| TechnicalObjectType | TechnicalObjectType | 1 | |
| TimeSheetOvertimeCategory | TimeSheetOvertimeCategory | 1 | |
| TradingContract | TradingContract | 1 | |
| TradingContractItem | TradingContractItem | 1 | |
| TransactionCurrency | TransactionCurrency | 1 | |
| TxRlvnceClassfctnForArgentina | TxRlvnceClassfctnForArgentina | 1 | |
| ValuationType | ValuationType | 1 | |
| ValueAddedServiceChargeCode | ValueAddedServiceChargeCode | 1 | |
| VariantCondition | VariantCondition | 1 | |
| VolumeRebateGroup | VolumeRebateGroup | 1 | |
| WorkItem | WorkItem | 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.
-- Validity of Condition Record for Pricing in Sales
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SLSPRCGCNDNRECDVALIDITY (
ACCOUNTTAXTYPE,
ADDITIONALCUSTOMERGROUP1,
ADDITIONALCUSTOMERGROUP2,
ADDITIONALCUSTOMERGROUP3,
ADDITIONALCUSTOMERGROUP4,
ADDITIONALCUSTOMERGROUP5,
ADDITIONALMATERIALGROUP1,
ADDITIONALMATERIALGROUP2,
ADDITIONALMATERIALGROUP3,
ADDITIONALMATERIALGROUP4,
ADDITIONALMATERIALGROUP5,
BATCH,
BILLABLECONTROL,
BILLTOPARTY,
BR_NFDOCUMENTTYPE,
BR_TAXCODE,
BRSPCFCFREEDEFINEDFIELD1,
BRSPCFCFREEDEFINEDFIELD2,
BRSPCFCFREEDEFINEDFIELD3,
BRSPCFCTAXBASEPERCENTAGECODE,
BRSPCFCTAXDEPARTUREREGION,
BRSPCFCTAXDESTINATIONREGION,
BRSPCFCTXGRPDYNTAXEXCEPTIONS,
CITYCODE,
CNDNBILLINGDOCUMENTCATEGORY,
COMMODITYCODE,
CONDITIONCONTRACT,
CONDITIONISEXCLUSIVE,
CONDITIONPROCESSINGSTATUS,
CONDITIONRELEASESTATUS,
CONDITIONSCALEBASISVALUE,
CONDITIONVALIDITYENDDATE,
CONDITIONVALIDITYSTARTDATE,
CONFIGURATIONNUMBER,
CONSUMPTIONTAXCTRLCODE,
COUNTRY,
COUNTY,
CUSTOMER,
CUSTOMERCONDITIONGROUP,
CUSTOMERGROUP,
CUSTOMERHIERARCHY,
CUSTOMERHIERARCHYNODEID,
CUSTOMERHIERARCHYNODETYPE,
CUSTOMERHIERARCHYROOTNODE,
CUSTOMERPRICEGROUP,
CUSTOMERTAXCLASSIFICATION1,
CUSTOMERTAXCLASSIFICATION2,
CUSTOMERTAXCLASSIFICATION3,
CUSTOMERTAXCLASSIFICATION4,
CUSTOMERTAXCLASSIFICATION5,
CUSTOMERTAXCLASSIFICATION6,
CUSTOMERTAXCLASSIFICATION7,
CUSTOMERTAXCLASSIFICATION8,
CUSTOMERTAXCLASSIFICATION9,
DEPARTURECOUNTRY,
DESTINATIONCOUNTRY,
DISTRIBUTIONCHANNEL,
DIVISION,
ENGAGEMENTPROJECT,
ENGAGEMENTPROJECTSERVICEORG,
EQUIPMENT,
INCOTERMSCLASSIFICATION,
INCOTERMSTRANSFERLOCATION,
INDUSTRY,
INTERNATIONALARTICLENUMBER,
LOCALSALESTAXAPPLICABILITYCODE,
MAINITEMMATERIALPRICINGGROUP,
MAINITEMPRICINGREFMATERIAL,
MATERIAL,
MATERIALCOMMISSIONGROUP,
MATERIALEXTERNALGROUP,
MATERIALGROUP,
MATERIALPRICINGGROUP,
MATUSAGEINDICATOR,
ORDERQUANTITYUNIT,
ORDERTYPE,
PAYERPARTY,
PERSONNEL,
PLANT,
PLANTCITY,
PLANTCOUNTY,
PLANTREGION,
POSTALCODE,
PRICELISTTYPE,
PRICINGDATE,
PRODUCTHIERARCHYNODE,
PRODUCTHIERARCHYNODE1,
PRODUCTHIERARCHYNODE2,
PRODUCTHIERARCHYNODE3,
PRODUCTHIERARCHYNODE4,
PRODUCTHIERARCHYNODE5,
PRODUCTHIERARCHYNODE6,
PRODUCTHIERARCHYNODE7,
PRODUCTHIERARCHYNODE8,
PRODUCTHIERARCHYNODE9,
PRODUCTTAXCLASSIFICATION1,
PRODUCTTAXCLASSIFICATION2,
PRODUCTTAXCLASSIFICATION3,
PRODUCTTAXCLASSIFICATION4,
PRODUCTTAXCLASSIFICATION5,
PRODUCTTAXCLASSIFICATION6,
PRODUCTTAXCLASSIFICATION7,
PRODUCTTAXCLASSIFICATION8,
PRODUCTTAXCLASSIFICATION9,
PRODUNIVHIERARCHYNODE,
PURGDOCSUPPLYINGPLANT,
REFERENCESDDOCUMENT,
REFERENCESDDOCUMENTITEM,
REGION,
REQUIREMENTSEGMENT,
RETURNREASON,
RETURNSREFUNDEXTENT,
SALESDISTRICT,
SALESDOCUMENT,
SALESDOCUMENTITEM,
SALESDOCUMENTTYPE,
SALESGROUP,
SALESOFFICE,
SALESORDERSALESORGANIZATION,
SALESORGANIZATION,
SALESSDDOCUMENTCATEGORY,
SDDOCUMENT,
SDDOCUMENTITEM,
SDDOCUMENTREASON,
SERVICEDOCUMENT,
SERVICEDOCUMENTITEM,
SHIPPINGCONDITION,
SHIPPINGPOINT,
SHIPPINGTYPE,
SHIPTOPARTY,
SOLDTOPARTY,
STOCKSEGMENT,
SUBSCRIPTIONCONTRACTDURATION,
SUBSCRIPTIONCONTRACTLOCKREASON,
SUBSCRPNCONTRDURATIONUNIT,
SUPPLIER,
TAXCODE,
TAXJURISDICTION,
TECHNICALOBJECTTYPE,
TIMESHEETOVERTIMECATEGORY,
TRADINGCONTRACT,
TRADINGCONTRACTITEM,
TRANSACTIONCURRENCY,
TXRLVNCECLASSFCTNFORARGENTINA,
VALUATIONTYPE,
VALUEADDEDSERVICECHARGECODE,
VARIANTCONDITION,
VOLUMEREBATEGROUP,
WORKITEM
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA