C_MMNonDeletedContractVH

Active Purchase Contract Value Help | view: CMMACTPURCTRVH | TRAN | Extraction: Not supported | Component: Self-Service Procurement
Column Name Description
PurchaseContract FK Purchasing Contract Header
PurchaseContractItem Item Number of Purchasing Contract
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
IsEndOfPurposeBlocked Business Purpose Completed Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
PurchasingContractDeletionCode Deletion Indicator in Purchasing Document ELOEK
Master Data Relations Join Conditions
Material Number
  • Client
  • Material Number
  • C_MMNONDELETEDCONTRACTVH.MANDT == MARA.MANDT
  • C_MMNONDELETEDCONTRACTVH.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_MMNONDELETEDCONTRACTVH.MANDT == T023.MANDT
  • C_MMNONDELETEDCONTRACTVH.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_MMNONDELETEDCONTRACTVH.MANDT == T001W.MANDT
  • C_MMNONDELETEDCONTRACTVH.PLANT == T001W.WERKS
Purchasing Document Type
  • ?
  • Client
  • Purchasing Document Type
  • C_MMNONDELETEDCONTRACTVH.[column in domain "BSTYP"] == T161.BSTYP
  • C_MMNONDELETEDCONTRACTVH.MANDT == T161.MANDT
  • C_MMNONDELETEDCONTRACTVH.PURCHASECONTRACTTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • C_MMNONDELETEDCONTRACTVH.PURCHASINGGROUP == T024.EKGRP
  • C_MMNONDELETEDCONTRACTVH.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_MMNONDELETEDCONTRACTVH.PURCHASINGORGANIZATION == T024E.EKORG
  • C_MMNONDELETEDCONTRACTVH.MANDT == T024E.MANDT
Supplier
  • Client
  • Supplier
  • C_MMNONDELETEDCONTRACTVH.MANDT == LFA1.MANDT
  • C_MMNONDELETEDCONTRACTVH.SUPPLIER == LFA1.LIFNR