I_CFinPurchasingDocument

CFin Purchasing Document: Header | view: ICFINPOROOT | TRAN | Extraction: Not supported | Component: Accounting View of Logistics Information
Tables used: CFIN_AV_PO_ROOTEKKO
Column Name Description
SenderLogicalSystem FK Logical system
CFinPurchasingDocument Central Finance Purchasing Document
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
PurchasingDocumentOrderDate Purchasing Document Date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchasingCompletenessStatus Purchase order not yet complete Show values
PurchasingProcessingStatus Purchasing document processing state Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
PurchasingDocumentIsAged Document is aged Show values
Column Name Description Domain name
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash discount days 1 ZBDXT
CashDiscount2Days Cash discount days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash discount percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
ExchangeRate Exchange Rate FINS_CFIN_WKURS_NO_CONV
PricingDocument Number of the Document Condition KNUMV
CreatedByUser Name of Person Responsible for Creating the Object USNAM
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_CFINPURCHASINGDOCUMENT.MANDT == T001.MANDT
  • I_CFINPURCHASINGDOCUMENT.COMPANYCODE == T001.BUKRS
Currency Key
  • Currency Key
  • Client
  • I_CFINPURCHASINGDOCUMENT.DOCUMENTCURRENCY == TCURC.WAERS
  • I_CFINPURCHASINGDOCUMENT.MANDT == TCURC.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • I_CFINPURCHASINGDOCUMENT.INVOICINGPARTY == LFA1.LIFNR
  • I_CFINPURCHASINGDOCUMENT.MANDT == LFA1.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • I_CFINPURCHASINGDOCUMENT.[column in domain "KAPPL"] == T683.KAPPL
  • I_CFINPURCHASINGDOCUMENT.MANDT == T683.MANDT
  • I_CFINPURCHASINGDOCUMENT.PRICINGPROCEDURE == T683.KALSM
  • I_CFINPURCHASINGDOCUMENT.[column in domain "KVEWE"] == T683.KVEWE
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • I_CFINPURCHASINGDOCUMENT.PURCHASINGDOCUMENTTYPE == T161.BSART
  • I_CFINPURCHASINGDOCUMENT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • I_CFINPURCHASINGDOCUMENT.MANDT == T161.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • I_CFINPURCHASINGDOCUMENT.MANDT == T024.MANDT
  • I_CFINPURCHASINGDOCUMENT.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • I_CFINPURCHASINGDOCUMENT.PURCHASINGORGANIZATION == T024E.EKORG
  • I_CFINPURCHASINGDOCUMENT.MANDT == T024E.MANDT
Logical system I_CFINPURCHASINGDOCUMENT.SENDERLOGICALSYSTEM == TBDLS.LOGSYS
Supplier
  • Client
  • Supplier
  • I_CFINPURCHASINGDOCUMENT.MANDT == LFA1.MANDT
  • I_CFINPURCHASINGDOCUMENT.SUPPLIER == LFA1.LIFNR
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • I_CFINPURCHASINGDOCUMENT.MANDT == T001W.MANDT
  • I_CFINPURCHASINGDOCUMENT.SUPPLYINGPLANT == T001W.WERKS
Goods Supplier
  • Client
  • Goods Supplier
  • I_CFINPURCHASINGDOCUMENT.MANDT == LFA1.MANDT
  • I_CFINPURCHASINGDOCUMENT.SUPPLYINGSUPPLIER == LFA1.LIFNR
Country/Region for Tax Report
  • Country/Region for Tax Report
  • Client
  • I_CFINPURCHASINGDOCUMENT.TAXRETURNCOUNTRY == T005.LAND1
  • I_CFINPURCHASINGDOCUMENT.MANDT == T005.MANDT