sap-sales-scheduling-agreement-sql-item-pricing-element-data.sql

CREATE TABLE `sap_sales_scheduling_agreement_item_pricing_element_data`
(
  `SalesSchedulingAgreement`       varchar(10) NOT NULL,
  `SalesSchedulingAgreementItem`   varchar(6) NOT NULL,
  `PricingProcedureStep`           varchar(3) NOT NULL,
  `PricingProcedureCounter`        varchar(3) NOT NULL,
  `ConditionApplication`           varchar(2) DEFAULT NULL,
  `ConditionType`                  varchar(4) DEFAULT NULL,
  `PricingDateTime`                varchar(80) DEFAULT NULL,
  `ConditionCalculationType`       varchar(3) DEFAULT NULL,
  `ConditionBaseValue`             varchar(16) DEFAULT NULL,
  `ConditionRateValue`             varchar(13) DEFAULT NULL,
  `ConditionCurrency`              varchar(5) DEFAULT NULL,
  `ConditionQuantity`              varchar(6) DEFAULT NULL,
  `ConditionQuantityUnit`          varchar(3) DEFAULT NULL,
  `ConditionCategory`              varchar(1) DEFAULT NULL,
  `PricingScaleType`               varchar(1) DEFAULT NULL,
  `ConditionRecord`                varchar(10) DEFAULT NULL,
  `ConditionSequentialNumber`      varchar(3) DEFAULT NULL,
  `TaxCode`                        varchar(2) DEFAULT NULL,
  `ConditionAmount`                varchar(13) DEFAULT NULL,
  `TransactionCurrency`            varchar(5) DEFAULT NULL,
  `PricingScaleBasis`              varchar(3) DEFAULT NULL,
  `ConditionScaleBasisValue`       varchar(13) DEFAULT NULL,
  `ConditionScaleBasisUnit`        varchar(3) DEFAULT NULL,
  `ConditionScaleBasisCurrency`    varchar(5) DEFAULT NULL,
  `ConditionIsManuallyChanged`     tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`SalesSchedulingAgreement`, `SalesSchedulingAgreementItem`, `PricingProcedureStep`, `PricingProcedureCounter`),
  CONSTRAINT `SASPSalesSchedulingAgreementItemPricingElementData_fk` FOREIGN KEY (`SalesSchedulingAgreement`) REFERENCES `sap_sales_scheduling_agreement_header_data` (`SalesSchedulingAgreement`)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4;