C_QuantityContractAcctAssgmt

Quantity Contract Account Assignment | view: CQTYCONTRACCT | TRAN | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATE, EKAB, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKKN, QTY_CON_PAI, EKKO, EKPO, TKA01, T001W, T161, T162, T000, LFA1
Column Name Description
PurchaseContract FK Purchasing Contract Header
PurchaseContractItem Item Number of Purchasing Contract
AccountAssignmentNumber Sequential Number of Account Assignment
ReleaseOrder FK Purchasing Document Number
ReleaseOrderItem FK Item Number of Purchasing Document
Column Name Description
💲 Display Currency (DisplayCurrency):
TargetAmount Target Amount
RelOrdLvlContractTargetAmount Target Amount
ReleaseOrderItemNetAmount Release Net Amount
PredictedConsumptionAmount Release Net Amount
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Quantity
ReleaseOrderItemOrderQuantity Release Order Quantity
Column Name Description
ValidityEndDate End of Validity Period
ContractExpiryPredictedDate Predicted Contract Expiry Date
Column Name Description
DocNumber Data type for Data provider field Show values
PurchasingDocumentCategory Purchasing Document Category Show values
Column Name Description Domain name
PurchaseOrderItemUniqueID null
FormattedPurchaseContractItem Purchase Contract Item ID
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
PurgCatName Name of Purchasing Category /SRMSMC/MEDIUM_NAME
CreatedByUser User of person who created a purchasing document USNAM
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarMonth Calendar Month NUM2
CalendarWeek Calendar Week NUM2
PredictedDaysToContrExpiry null
PredictiveConsumptionInPct null
NumberOfPurchaseOrders null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_QUANTITYCONTRACTACCTASSGMT.COMPANYCODE == T001.BUKRS
  • C_QUANTITYCONTRACTACCTASSGMT.MANDT == T001.MANDT
Cost Center
  • ?
  • Cost Center
  • ?
  • Client
  • C_QUANTITYCONTRACTACCTASSGMT.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_QUANTITYCONTRACTACCTASSGMT.COSTCENTER == CSKS.KOSTL
  • C_QUANTITYCONTRACTACCTASSGMT.[column in domain "DATBI"] == CSKS.DATBI
  • C_QUANTITYCONTRACTACCTASSGMT.MANDT == CSKS.MANDT
Material Number
  • Client
  • Material Number
  • C_QUANTITYCONTRACTACCTASSGMT.MANDT == MARA.MANDT
  • C_QUANTITYCONTRACTACCTASSGMT.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • C_QUANTITYCONTRACTACCTASSGMT.MATERIALGROUP == T023.MATKL
  • C_QUANTITYCONTRACTACCTASSGMT.MANDT == T023.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_QUANTITYCONTRACTACCTASSGMT.ORDERQUANTITYUNIT == T006.MSEHI
  • C_QUANTITYCONTRACTACCTASSGMT.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • C_QUANTITYCONTRACTACCTASSGMT.MANDT == T001W.MANDT
  • C_QUANTITYCONTRACTACCTASSGMT.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • C_QUANTITYCONTRACTACCTASSGMT.PURCHASECONTRACTTYPE == T161.BSART
  • C_QUANTITYCONTRACTACCTASSGMT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_QUANTITYCONTRACTACCTASSGMT.MANDT == T161.MANDT
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_QUANTITYCONTRACTACCTASSGMT.MANDT == T163.MANDT
  • C_QUANTITYCONTRACTACCTASSGMT.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • C_QUANTITYCONTRACTACCTASSGMT.MANDT == T024.MANDT
  • C_QUANTITYCONTRACTACCTASSGMT.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • C_QUANTITYCONTRACTACCTASSGMT.PURCHASINGORGANIZATION == T024E.EKORG
  • C_QUANTITYCONTRACTACCTASSGMT.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_QUANTITYCONTRACTACCTASSGMT.SUPPLIER == LFA1.LIFNR
  • C_QUANTITYCONTRACTACCTASSGMT.MANDT == LFA1.MANDT