CDS Views for Financials Kazakhastan (FI-LOC-FI-KZ)

CDS View NameDescriptionSQL View Name
C_KZ_VATRET0RATEITEMQUERYSection 1CKZVATRET0RAT
C_KZ_VATRETCORRECTIONITEMQUERYSection 6CKZVATRETCOR
C_KZ_VATRETDEDUCTDOCCUBESection 9 Cube VeiwCKZVATRETDECDOCC
C_KZ_VATRETDEDUCTDOCQUERYSection 9CKZVATRETDECDOCQ
C_KZ_VATRETFOREIGNITEMCUBEVAT Retrun Foreign documents: Cube ViewCKZVATFOREIGNC
C_KZ_VATRETFOREIGNITEMQUERYVAT Retrun Foreign documents: Query ViewCKZVATFOREIGNQ
C_KZ_VATRETINCCUSTOMDECLNCUBESection 3 Cube VeiwCKZVATRETCSTDECL
C_KZ_VATRETINCCUSTOMDECLNQUERYSection 3 Query ViewCKZVATRETCSTDECQ
C_KZ_VATRETMAINSECTION0ITEMQRYSection 0CKZVATRETMAIN0
C_KZ_VATRETOFFSETITEMQUERYSection 4CKZVATRETOFSET
C_KZ_VATRETTAXFREEITEMQUERYSection 2CKZVATRETTXFREE
C_KZ_VATRETURNINCGINVCITEMCUBEVAT Return Incoming Invoice ItemCKZVATRETININVC
C_KZ_VATRETURNINCGINVCITEMQVAT Return Incoming Invoice Item (Query)CKZVATRETININVQ
C_KZ_VATRETURNMAINSECTIONCUBESections 0,1,2,4,6 Cube VeiwCKZVATRETDOCMAIN
C_KZ_VATRETURNOUTGINVCITEMCUBEVAT Return Outgoing Invoice ItemCKZVATRETOUTINVC
C_KZ_VATRETURNOUTGINVCITEMQVAT Return Outgoing Invoice Item (Query)CKZVATRETOUTINVQ
I_KZ_BUSINESSPARTNERCONTRACTInternal Contract NumbersIKZBPCONTRACT
I_KZ_CONTRACTTYPEContract type KZIKZCONTRACTTYPE
I_KZ_CUSTOMDECLARATIONBasic view for table fikzd_cust_declIKZCUSTDECL
I_KZ_CUSTOMERCATEGORYElectronic Invoices: Customer CategoryIKZCUSTCAT
I_KZ_MATERIALGROUPCLASSFCTNMaterial groupIKZMATGROUPCL
I_KZ_PAPERCUSTINVOICEASSGMTAssign Paper ID to CustomerIKZPAPERCUSTINVC
I_KZ_PAPERVENDORINVOICEASSGMTAssign Paper ID to VendorIKZPAPERVENDINVC
I_KZ_RETURNFIELDSMAPPINGReturn Fields Mapping Settings tableIKZRETFIELDMAP
I_KZ_TURNOVERCODESMAPPINGMapping for turnover codesIKZTURNCODMAP
I_KZ_VATCSTMDECLNITEMLOGRead log table for KZ VAT Custom DeclIKZVATCDECLLG
I_KZ_VATITEMLOGRead log table for KZ VAT DeclIKZVATITEMLOG
I_KZ_VATRETURNCUSTOMIZINGVAT Return Kazahstan CustomizingIKZVATRETCUST
I_KZ_VENDORCATEGORYElectronic invoices: Vendor CategoryIKZVENDORCAT
P_KZ_BILLINGMATERIALDETAILSBilling material details for out docsPKZBILLINGMATDOC
P_KZ_COMPANYCODEDATACompany code dataPKZCOMPCODEDATA
P_KZ_CUSTOMDECLARATIONBasic view for table fikzd_cust_declPKZCUSTDECL
P_KZ_CUSTOMDECLARATIONPREVSelection for prev custom declarationsPKZCUSTDECLPREV
P_KZ_DATE_HELPERHelper for sumPKZDATEHELPER
P_KZ_DSVATRETCDECData slection for section 3PKZDSVATRETCDEC
P_KZ_DSVATRETDEDUCTData selection for section 9PKZDSVATRETDED
P_KZ_DSVATRETDOCData selection view for section 0,1,2,4,6PKZDSVATRETDOC
P_KZ_DSVATRETFORIEGNDOCData selection for Section 5PKZDSVATRETFDOC
P_KZ_DSVATRETFORIEGNDOC1Data selection sec 5 with prevPKZDSVATRETFDOC1
P_KZ_DSVATRETFORIEGNDOCRENEWData selection for old VAT KZ ReturnPKZDSVATRETFDOCR
P_KZ_DSVATRETFORIEGNDOCRENEW1Data selection for old VAT KZ Return 1PKZDSVATRETFDR1
P_KZ_DSVATRETINDOCData selection for section 8PKZDSVATRETINDOC
P_KZ_DSVATRETINDOC1Data sselection for paper customer invoicesPKZDSVATRETIND1
P_KZ_DSVATRETOUTDOCData selection for section 7PKZDSVATRETOUT
P_KZ_DSVATRETOUTDOC1Data selction for ssection 7PKZDSVATRETOUT1
P_KZ_DSVATRETURNData selection for all sectionsPKZDSVATRETURN
P_KZ_DSVATRETURNFINALData selection for KZ VAT with CorrectionsPKZDSVATRETURNF
P_KZ_FILENAME_HELPERKZ VAT FileName Helper ViewPKZFILEHELPER
P_KZ_PURMATERIALDETAILSPurchase material details for in docsPKZPURMATDETAILS
P_KZ_SUM_HELPERHelper for sumPKZSUMHELPER
P_KZ_SUM_HELPER1Helper for sumPZSUMHELPER1
P_KZ_SUM_HELPER2Helper for sumPZSUMHELPER2
P_KZ_SUM_HELPER_1Helper for sumPKZSUMHELPER1
P_KZ_SUPPLIERSTATUSKZ Supplier StatusPKZSUPPLIERSTAT
P_KZ_VATCDECLOGRUNsubmitted custom declarationsPKZVATCDECLOGRUN
P_KZ_VATCDECLOGRUN1submitted custom declarationsPKZVATCDECLGRUN1
P_KZ_VATITEMLOGRUNRead log table for KZ VAT DeclPKZVATITEMLOGRUN
P_KZ_VATITEMLOGRUN1Submitted docsPKZVATITEMLOGRN1
P_KZ_VATRERINITIALSECTIONTOTInitial section totalsPKZINITIALSECTOT
P_KZ_VATRETCDECSelection for custome declarationsPKZVATRETCDEC
P_KZ_VATRETCDECTOTALSCustom decalration totalPKZVATRETCDECTOT
P_KZ_VATRETDEDUCTDOCSelection for section 9PKZVATRETDEDUCT
P_KZ_VATRETFOREIGNDOCSelection for foriegn documentssPKZVATRETFOREIGN
P_KZ_VATRETFOREIGNDOCRENEWSection 5 for old VAT Return KZPKZVATRETFORREN
P_KZ_VATRETFOREIGNDOCROUNDSelection for foriegn documentssPKZVATRETFOREIGR
P_KZ_VATRETFOREIGNDOCROUNDRENRound view for section 5 of old VAT returnPKZVATRETFORRR
P_KZ_VATRETFOREIGNDOCTABLEForeign documents TablePKZVATRETFORTAB
P_KZ_VATRETFOREIGNDOCTABLE1Foreign documents TablePKZVATRETFORTAB1
P_KZ_VATRETFOREIGNDOCTABLERENFinal table for VAT Return oldPKZVATRETFORR
P_KZ_VATRETFOREIGNDOCTABLETOTTable totals for foreign docsPKZVATFORTABTOT
P_KZ_VATRETFOREIGNDOCTOTALSForeign documents TotalsPKZVATRETFORTOT
P_KZ_VATRETFOREIGNDOCTOTALSRENTotls for section 5 of old VAT Retunr curr periodPKZVATRETFORTR
P_KZ_VATRETFOREIGNDOCTOTPREVForeign Docs Totals PreviousPKZVATRETFORTOTP
P_KZ_VATRETFOREIGNDOCTPREVRENTotls for section 5 of old VAT Retunr prev periodPKZVATRETFORTPR
P_KZ_VATRETINDOCSelection for incoming documentsPKZVATRETINDOC
P_KZ_VATRETINDOC1Incoming documents view 1PKZVATRETINDOC1
P_KZ_VATRETINDOC2Incoming documents view 1PKZVATRETINDOC2
P_KZ_VATRETINDOCTABLEOutgoing docs for MappingPKZVATRETINTAB
P_KZ_VATRETINDOCTABLETOTTotals for outgoing documentsPKZVATRETINTOT
P_KZ_VATRETINDOCTABLETOT1Totals for outgoing documentsPKZVATRETINTOT1
P_KZ_VATRETOUTDOCSelection for outgoing documentsPKZVATRETOUTDOC
P_KZ_VATRETOUTDOC1Outgoing invoices viewPKZBILLMATDOC1
P_KZ_VATRETOUTDOC2Outgoing invoices viewPKZBILLMATDOC2
P_KZ_VATRETOUTDOCTABLEOutgoing docs for MappingPKZVATRETOUTTAB
P_KZ_VATRETOUTDOCTABLETOTTotals for outgoing documentsPKZVATRETOUTTOT
P_KZ_VATRETOUTDOCTABLETOT1Totals for outgoing documentsPKZVATRETOUTTOT1
P_KZ_VATRETSECTION1PREVIEWVAT Return Section 1 PreviewPKZVATRETS1PREV
P_KZ_VATRETSECTION1SUBTOTALS1Section 1: Read customer countryPKZVATRETSEC1ST1
P_KZ_VATRETSECTION1SUBTOTALS2Section 1: Calculate country subtotalsPKZVATRETSEC1ST2
P_KZ_VATRETSECTION1SUBTOTALS3Section 1: Merge all subtotalsPKZVATRETSEC1ST3
P_KZ_VATRETSECTION1TOTALSSection 1: Calculate main totalsPKZVATRETSEC1TT
P_KZ_VATRETSECTION2PREVIEWSection 2: PreviewPKZVATRETSEC2PRV
P_KZ_VATRETSECTION2SUBTOTALS1Section 2: Calculate subtotalsPKZVATRETSEC2ST1
P_KZ_VATRETSECTION2TOTALSMain totals for section 2PKZVATRETSEC2TT
P_KZ_VATRETSECTION4PREVIEWSection 4: PreviewPKZVATRETSEC4PRV
P_KZ_VATRETSECTION4SUBTOTALS1Section 4: Calculate subtotalsPKZVATRETSEC4ST1
P_KZ_VATRETSECTION4TOTALSMain totals for section 4PKZVATRETSEC4TT
P_KZ_VATRETSECTION6PREVIEWSection 6: PreviewPKZVATRETSEC6PRV
P_KZ_VATRETSECTION6SUBTOTALS1Section 6: Calculate subtotalsPKZVATRETSEC6ST1
P_KZ_VATRETSECTION6TOTALSMain totals for section 6PKZVATRETSEC6TT
P_KZ_VATRETSECTION9SUBTOTALS1Subtotals for section 9PKZVATRETSEC9ST1
P_KZ_VATRETSECTION9SUBTOTALS2Subtotals for section 9PKZVATRETSEC9ST2
P_KZ_VATRETURNCUSTOMAZINGRENEWVAT Return Customazing RenewPKZVATRETCUSTR
P_KZ_VATRETURNFOREIGN1Selection for main ssections 0,1,2,4,6(1)PKZVATRETFOR1
P_KZ_VATRETURNINITIALSECTIONKZ VAT Initial SectionPKZINITIALSEC
P_KZ_VATRETURNINITSECIMPORTfor line 16 of section 0PKZINITIALSECIMP
P_KZ_VATRETURNINITSECIMPORT1for line 16 of section 0 final viewPKZINITIALSEC1
P_KZ_VATRETURNITEMVAT Return KZ CustPKZVATRETITEM
P_KZ_VATRETURNITEM1Customasing of VAT return itemsPKZVATRETITEM1
P_KZ_VATRETURNITEMTEXTCustomasing of VAT return items textPKZVATRETITMT
P_KZ_VATRETURNMAINSECTIONSelection for Main SectionPKZVATRETDOCMAIN
P_KZ_VATRETURNMAINSECTION_RNDSelection for Main SectionPKZVATRETMAINRND
P_KZ_VATRETURNSECTIONSelection for main ssections 0,1,2,4,6PKZVATRETDOC
P_KZ_VATRETURNSECTION1Selection for main ssections 0,1,2,4,6(1)PKZVATRETDOC1
P_KZ_VATRETURNSECTION2Selection for main ssections part 2PKZVATRETDOC2
P_KZ_VATRETURNSECTION3Selection for main sectionss part 3PKZVATRETDOC3
P_KZ_VATRETURNSECTION3_RNDSelection for main sectionss part 3PKZVATRETDOC3RND
P_KZ_VATRETURNSECTIONCUSTSections of VAT Return KazahstanPKZVATRETSECTC
P_KZ_VATRETURNSELCRITERIAItems selection criteria of VAT-ReturnPKZVATRETSELCRIT
P_KZ_VAT_HELPERKZ VAT Helper ViewPKZVATHELPER

Other CDS Views