C_PT_SAFTSalesInvoiceHeaderQry

Column Name Description
PortugueseInvoiceNumber Signature PT: Invoice Number
Column Name Description
💲 Currency Key (TransactionCurrency):
TotalTaxAmount null
TotalNetAmount null
TotalGrossAmount Amount in local currency
InvoiceAmountInFrgnCurrency null
CashDiscountAmtInCoCodeCrcy null
CashDiscountAmtInTransacCrcy Condition Amount or Percentage
Column Name Description
Column Name Description
PortugueseInvoiceDate Field of type DATS
CashDiscount1DueDate null
CashDiscount2DueDate null
ActualDeliveryDate null
Column Name Description
DocumentType SAF-T Invoice Type Show values
Column Name Description Domain name
DocumentBillingStatus null
LastChangeDateTimeText Signature PT: System Entry Date and Time CHAR19
ReversalReasonName null
LastChangedByUser User that created the journal entry
SourceBillingDocumentType null
PortugueseDigitalSignature PT Digital Signature with max. supported length for CHAR
PortugueseDgtlSgntrKeyVersion Signature PT: Encryption Key Version
FiscalPeriod Fiscal Period POPER
CreatedByUser User that created the journal entry
PTDgtlSgntrSystemDateTimeText Signature PT: System Entry Date and Time CHAR19
DocumentTransaction null
PortugueseCustomerWithVersion null
ExchangeRate null
CustomerPaymentTerms null
CustomerPaymentTermsName null
DestinationLocationName null
TranspOrdDestLocationName null
CreationDateTime null
TranspDestLocationCityName null
TranspDestLocationPostalCode null
TranspOrdStageDestLocCntry null
TranspOrdSrceLocationName null
TranspSourceLocationCityName null
TranspSourceLocationPostalCode null
TranspOrdStageSrceLocCntry null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_PT_SAFTSALESINVOICEHEADERQRY.COMPANYCODE == T001.BUKRS
  • C_PT_SAFTSALESINVOICEHEADERQRY.MANDT == T001.MANDT
Reason for Reversal or Inverse Posting
  • Client
  • Reason for Reversal or Inverse Posting
  • C_PT_SAFTSALESINVOICEHEADERQRY.MANDT == T041C.MANDT
  • C_PT_SAFTSALESINVOICEHEADERQRY.REVERSALREASON == T041C.STGRD