CDS Views for Financials Portugal (FI-LOC-FI-PT)

CDS View NameDescriptionSQL View Name
C_PT_DOCITEMWHLDGTXCSHDISCCCube for Portugal annual listCPTWTCDCUBE
C_PT_DOCITEMWHLDGTXCSHDISCQQuery for Portugal Annual ListCPTWTCDQUERY
C_PT_STRPTAXITEMQUERYVAT Tax Item Query for PortugalCPTSRQTAXITEMQ
P_PT_DOCITEMCSHDISCCash Discount ItemsPTDOCITEMCSHDISC
P_PT_DOCITEMPARTNERView to select all partner and customer line itemPTDOCITEMPARTER
P_PT_DOCITEMPARTNERJOINWITJoin Partner and WIT viewPPTPARTJOINWIT
P_PT_DOCITEMWHLDGTXWithholding Tax itemsPTDOCITEMWHLDGTX
P_PT_DOCITEMWHLDGTXCSHDISCCash Discount and WithHolding Tax items unionPTDOCITEMWTCD
P_PT_DOCITEMWHLDGTXCSHDISCSUMVatRegistration SumPPTWTCDSUMAMT
P_PT_DOCITEMWHLDGTXCSHDISCSUMTPortugal Annual :Amount Total with parameterPPTWTCDSUMT
P_PT_DOCITEMWHLDGTXCSHDISCTPortugal Annual : Complete Amount TotalPPTWTCDTOTAL
P_PT_DOCITEMWITQuery to extract only WIT itemPTDOCITEMWIT

Other CDS Views