Sheet2Print Purchase Order
Nomor PO[S1]
Purchase OrderReturn
PO HOKode KolomFieldTableSpec[A]LogoZlogoZlogo[A]dimanaEKKO-EBELN = [S1] -->nomor purchase ordercek EKKO-BUKRSjika EKKO-BUKRS = GUMIKantor Pusat :Lokasi Pengiriman _____ : [B]Stock Transport Ordermaka munculkan ZLOGO GUMIWisma Barito Pacific Tower B Lantai 10Plant : [B1]Sloc : [B2]jika EKKO-BUKRS = TBSIJl. Let. Jend. S. Parman Kav. 62-63Desa Balai Sepuak Kec Belitang Hulu [C]Nomor PO :124231[H]maka munculkan ZLOGO TBSIJakarta 11410Kabupaten Sekadau [D]Tanggal PO :5 Januari 2015[I]jika EKKO-BUKRS = TBSDTelepon : (021) 5306348Kalimantan Barat [E]maka munculkan ZLOGO TBSDFax : (021) 5306344, 5306680Telepon : [F]No Ref Permintaan :abcde[J]jika EKKO-BUKRS = RIMIFax : [G]Tanggal Pengiriman sampai ke lokasi :12 Januari 2015[K]maka munculkan ZLOGO RIMIPenyuplaiPlant :[L1]Sloc :[L2][B]LokasiEKKO-ZLOKASIEKKO-ZLOKASIDesa Balai Sepuak Kec Belitang Hulu [M]dimanaKabupaten Sekadau [N]EKPO-EBELN = [S1]Kalimantan Barat [O]cek EKPO-WERKSTelepon : [P]dimanaFax : [Q]EKPO-EBELPEKPO-LOEKZ != 'L'ambil nilai EKPO-WERKS yang EKPO-EBELPnya yang EKPO-LOEKZ != 'L'(Header Text) [R]Jika digit ke 4 dari EKPO-WERKS = 'E'maka munculkan EKKO-ZLOKASI = 'Kebun'Header note[S]jika digit ke 4 dari EKPO-WERKS = 'M'No.Kode BarangPart NoNama Barang Merk/KeteranganJumlahUnitmaka munculkan EKKO-ZLOKASI = 'PKS'1XYZ-001Jasa service Tune Up1AUlainnya maka munculkan EKKO-ZLOKASI = 'HO'2ZYZ-002Oli [X]2PC3AIU-001ABCDEBaut 1PC[B1]PlantEKPO-WERKSEKPO-WERKS4ZBA-001JKLMNFilter 1PCdimana[T][U][V][W][Y][Z]EKPO-EBELN = [S1]EKPO-EBELP yang pertama
[B2]SlocEKPO-LGORTEKPO-LGORTdimanaEKPO-EBELN = [S1]EKPO-EBELP yang pertama
[C]AlamatADRC-STR_SUPPL1Cek EKPO-WERKS dimana EKPO-EBELN = [S1]ataujika EKPO-WERKS = GUMI atau RIMI atau TBSI atau TBSDMengetahui dan menyetujui : (Peminta)Mengetahui dan menyetujui : (Pengirim)ADRC-STREETmaka munculkan ADRC-STR_SUPPL1dimanaKTUManagerGMKTUManagerGMADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKPO-WERKS(_______________)(_______________)(_______________)(_______________)(_______________)(_______________)lainnyaNama :Nama :Nama :Nama :Nama :Nama :maka munculkan ADRC-STREETTanggal :Tanggal :Tanggal :Tanggal :Tanggal :Tanggal :dimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKPO-WERKS[D]ADRC-STREETCek EKPO-WERKS dimana EKPO-EBELN = [S1]jika EKPO-WERKS = GUMI atau RIMI atau TBSI atau TBSDmaka munculkan ADRC-STR_STREETdimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKPO-WERKSlainnya blank
[E]Postal CodeADRC-CITY1 Cek EKPO-WERKS dimana EKPO-EBELN = [S1]ADRC-POST_CODE1jika EKPO-WERKS = GUMI atau RIMI atau TBSI atau TBSDmaka munculkan ADRC-CITY1 dan ADRC-POST_CODE1dimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKPO-WERKSlainnyamaka munculkan ADRC-CITY1dimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKPO-WERKS[F]TelponADRC-TEL_NUMBERADRC-TEL_NUMBERdimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKPO-WERKSdimanaEKPO-EBELN = [S1][G]FaxADRC-FAX_NUMBERADRC-FAX_NUMBERdimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKPO-WERKSdimanaEKPO-EBELN = [S1][H]Nomor POEKKO-EBELNEKKO-EBELNdimanaEKKO-EBELN = [S1][I]Tanggal POEKKO-BEDATEKKO-BEDATdimanaEKKO-EBELN = [S1][J]No Ref PermintaanEKPO-BANFNEKPO-BANFNdimanaEKPO-EBELN = [S1]EKPO-EBELP yang pertama[K]Tanggal pengirimanEKET-EINDTEKET-EINDTdimanaEKET-EBELN = [S1]EKET-EBELP yang pertama[L1]PlantEKKO-RESWKEKKO-RESWKdimanaEKKO-EBELN = [S1][L2]SlocEKPO-RESLOEKPO-RESLOdimanaEKPO-EBELN = [S1]EKPO-EBELP yang pertama[M]AlamatADRC-STR_SUPPL1Cek EKKO-RESWK dimana EKKO-EBELN = [S1]ataujika EKKO-RESWK = GUMI atau RIMI atau TBSI atau TBSDADRC-STREETmaka munculkan ADRC-STR_SUPPL1dimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKKO-RESWKlainnyamaka munculkan ADRC-STREETdimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKKO-RESWK
[N]ADRC-STREETCek EKKO-RESWK dimana EKKO-EBELN = [S1]jika EKKO-RESWK = GUMI atau RIMI atau TBSI atau TBSDmaka munculkan ADRC-STR_STREETdimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKKO-RESWKlainnya blank
[O]Postal CodeADRC-CITY1 Cek EKKO-RESWK dimana EKKO-EBELN = [S1]ADRC-POST_CODE1jika EKKO-RESWK = GUMI atau RIMI atau TBSI atau TBSDmaka munculkan ADRC-CITY1 dan ADRC-POST_CODE1dimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKKO-RESWKlainnyamaka munculkan ADRC-CITY1dimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKKO-RESWK
[P]TelponADRC-TEL_NUMBERADRC-TEL_NUMBERdimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKKO-RESWKdimanaEKKO-EBELN = [S1]
[Q]FaxADRC-FAX_NUMBERADRC-FAX_NUMBERdimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKKO-RESWKdimanaEKKO-EBELN = [S1]ADR6-ADDRNUMBER = LFA1-ADRNR[R]Header TextCall FM READ_TEXTCall FM READ_TEXTClient = SY-MANDTID = "F01"Language = "EN"Name = [S1]Object = "EKKO"[S]Header NoteCall FM READ_TEXTCall FM READ_TEXTClient = SY-MANDTID = "F02"Language = "EN"Name = [S1]Object = "EKKO"[T]Nomor urutnomor urut1,2,3, dst[U]Material NumberEKPO-MATNREKPO-MATNR dimanaEKPO-EBELN = EKKO-EBELN = [S1]EKPO-EBELPEKPO-LOEKZ ne 'X'[V]Part NoMARA-BISMT atau MARA-MFRPNMARA-BISMT atau MARA-MFRPNdimanaMARA-MATNR = [U]hanya ambil salah satunya saja[W]DescEKPO-TXZ01EKPO-TXZ01 dimanaEKPO-EBELN = EKKO-EBELN = [S1]EKPO-EBELPEKPO-LOEKZ ne 'X'
[X]KeteranganCall FM READ_TEXTCall FM READ_TEXTClient = SY-MANDTID = "F01"Language = "EN"Name = [S1] + EKPO-EBELPObject = "EKPO"[Y]JumlahEKPO-MENGEEKPO-MENGEdimanaEKPO-EBELN = EKKO-EBELN = [S1]EKPO-EBELPEKPO-LOEKZ ne 'X'EKPO-MATNR = [U][Z]UnitEKPO-MEINSEKPO-MEINSdimanaEKPO-EBELN = EKKO-EBELN = [S1]EKPO-EBELPEKPO-LOEKZ ne 'X'EKPO-MATNR = [U]
PO ReturnKode KolomFieldTableSpec[A]LogoZlogoZlogo[A]dimanaEKKO-EBELN = [H] -->nomor purchase ordercek EKKO-BUKRSjika EKKO-BUKRS = GUMIKantor Pusat :Lokasi Pengiriman _____ : [B]PURCHASE ORDER RETURNmaka munculkan ZLOGO GUMIWisma Barito Pacific Tower B Lantai 10Desa Balai Sepuak Kec Belitang Hulu [C]jika EKKO-BUKRS = TBSIJl. Let. Jend. S. Parman Kav. 62-63Kabupaten Sekadau [D]Nomor PO :124231[H]maka munculkan ZLOGO TBSIJakarta 11410Kalimantan Barat [E]Tanggal PO :5 Januari 2015[I]jika EKKO-BUKRS = TBSDTelepon : (021) 5306348Telepon : [F]maka munculkan ZLOGO TBSDFax : (021) 5306344, 5306680Fax : [G]No Ref Permintaan :abcde[J]jika EKKO-BUKRS = RIMITanggal Pengiriman sampai ke lokasi :12 Januari 2015[K]maka munculkan ZLOGO RIMIKepada Yth :Pengiriman Invoice ke :Kantor Pusat[Fixed]PT Ucok Baba[M]N.P.W.P :123433123[L][B]LokasiEKKO-ZLOKASIEKKO-ZLOKASIJl. Ga Pake Lubang[N]dimanaKota Di Awan 12345[O]EKPO-EBELN = [H]cek EKPO-WERKSdimanaUp & HP :Ucok, 0819123121, [email protected][P]EKPO-EBELPTel :21121901[Q]Fax :2122312[R]EKPO-LOEKZ != 'L'netto tanpa 10%ambil nilai EKPO-WERKS yang EKPO-EBELPnya yang EKPO-LOEKZ != 'L'Mata Uang :Harga : Franco Pontianak, termasuk PPN 10%[T]Waktu service : Sudah diservice Tgl 3 Juni 2014Jika digit ke 4 dari EKPO-WERKS = 'E'Rupiah[S]Pembayaran : 30 Days after delivery and invoice submission[U](Header Text)[V]maka munculkan EKKO-ZLOKASI = 'Kebun'Account : free text (Header Note)[W]jika digit ke 4 dari EKPO-WERKS = 'M'No.Kode BarangPart NoNama Barang Merk/KeteranganJumlahUnitHarga/unitHarga Totalmaka munculkan EKKO-ZLOKASI = 'PKS'1XYZ-001Jasa service Tune Up1AU15000001500000lainnya maka munculkan EKKO-ZLOKASI = 'HO'2ZYZ-002Oli [A2]2PC2500005000003AIU-001ABCDEBaut 1PC1000010000[C]AlamatADRC-STR_SUPPL1Cek EKPO-WERKS dimana EKPO-EBELN = [S1]4ZBA-001JKLMNFilter 1PC1240012400ataujika EKPO-WERKS = GUMI atau RIMI atau TBSI atau TBSD[X][Y][Z][A1][A3][A4][A5][A6]ADRC-STREETmaka munculkan ADRC-STR_SUPPL1Ongkos Angkut10000dimanaSubtotal532400ADRC-ADDRNUMBER = T001W-ADRNRPPN 10%53240dimanaPBB-KB 7,5%T001W-WERKS = EKPO-WERKSPPhlainnyaPPh 22 BBMmaka munculkan ADRC-STREETBiaya MateraidimanaTotal2022400Sum AllADRC-ADDRNUMBER = T001W-ADRNRTerbilang : Dua Juta Dua Puluh Dua Ribu Empat Ratus RupiahdimanaT001W-WERKS = EKPO-WERKSPihak penjual telah menyetujui seluruh syarat dan kondisi yang tertulis pada Purchase Order ini :disetujui[D]ADRC-STREETCek EKPO-WERKS dimana EKPO-EBELN = [S1]Disetujui oleh :jika EKPO-WERKS = GUMI atau RIMI atau TBSI atau TBSDNama :maka munculkan ADRC-STR_STREETTanggal :dimanaMohon PO yang telah disetujui dan ditandatangani oleh pihak penjual difax ke 021-5306344LucidirekturADRC-ADDRNUMBER = T001W-ADRNRtgltgldimanaT001W-WERKS = EKPO-WERKSlainnya blank
[E]Postal CodeADRC-CITY1 Cek EKPO-WERKS dimana EKPO-EBELN = [S1]ADRC-POST_CODE1jika EKPO-WERKS = GUMI atau RIMI atau TBSI atau TBSDmaka munculkan ADRC-CITY1 dan ADRC-POST_CODE1dimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKPO-WERKSlainnyamaka munculkan ADRC-CITY1dimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKPO-WERKS[F]TelponADRC-TEL_NUMBERADRC-TEL_NUMBERdimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKPO-WERKSdimanaEKPO-EBELN = [S1][G]FaxADRC-FAX_NUMBERADRC-FAX_NUMBERdimanaADRC-ADDRNUMBER = T001W-ADRNRdimanaT001W-WERKS = EKPO-WERKSdimanaEKPO-EBELN = [S1][H]Nomor POEKKO-EBELNEKKO-EBELNdimanaEKKO-EBELN = [S1][I]Tanggal POEKKO-BEDATEKKO-BEDATdimanaEKKO-EBELN = [S1][J]No Ref PermintaanEKPO-BANFNEKPO-BANFNdimanaEKPO-EBELN = [S1]EKPO-EBELP yang pertama[K]Tanggal pengirimanEKET-EINDTEKET-EINDTdimanaEKET-EBELN = [S1]EKET-EBELP yang pertama[L]N.P.W.PCek EKKO-BUKRS dimana EKKO-EBELN = [S1]Jika EKKO-BUKRS = GUMImaka N.P.W.P = 02.261.916.7-705.001Jika EKKO-BUKRS = RIMImaka N.P.W.P = 02.427.216.3-014.000Jika EKKO-BUKRS = TBSImaka N.P.W.P = 02.343.543.1-705.000Jika EKKO-BUKRS = TBSDmaka N.P.W.P = 02.916.146.0-705.000[M]Nama VendorLFA1-NAME1LFA1-NAME1 dimana LFA1-LIFNR = EKKO-LIFNR; EKKO-EBELN =[S1][N]Alamat vendorLFA1-STRASLFA1-STRAS, where LFA1-LIFNR = EKKO-LIFNRdimanaLFA1-LIFNR = EKKO-LIFNREKKO-EBELN =[S1][O]postal codeLFA1-ORT01, LFA1-PSTLZLFA1-ORT01, LFA1-PSTLZ dimana LFA1-LIFNR = EKKO-LIFNREKKO-EBELN =[S1][P]up & HPLFM1-VERKF, LFM1-TELF1, ADR6-SMTP_ADDRLFM1-VERKF, LFM1-TELF1, ADR6-SMTP_ADDRdimanaLFM1-LIFNR = EKKO-LIFNREKKO-EBELN =[S1]untuk ADR6dimanaLFA1-LIFNR = EKKO-LIFNRambil nilai LFA1-ADRNRambil nilai ADR6-SMTP_ADDRdimanaADR6-ADDRNUMBER = LFA1-ADRNR[Q]TlpLFA1-TELF1LFA1-TELF1dimanaLFA1-LIFNR = EKKO-LIFNREKKO-EBELN =[S1][R]FaxLFA1-TELFXLFA1-TELFXdimanaLFA1-LIFNR = EKKO-LIFNREKKO-EBELN =[S1][S]Mata uangEKKO-WAERSEKKO-WAERSdimanaEKKO-EBELN =[S1][T]HargaTINC-BEZEI, EKKO-INCO2TINC-BEZEI, EKKO-INCO2dimanaEKKO-EBELN=[S1]ambil nilai EKKO-INCO1TINC-INCO1 = EKKO-INCO1ambil nilai TINC-BEZEIcek EKPO-MWSKZdimanaEKPO-EBELN = EKKO-EBELN = [S1]ambil nilai EKPO-MWSKZ, untuk EKPO-EBELP pertamasusun kalimat dengan nilai tersebut dengan urutan berikutJika MWSKZ = V1"Harga : TINC-BEZEI EKKO-INCO2, termasuk PPN 10%"Jika MWSKZ != V1"Harga : TINC-BEZEI EKKO-INCO2, netto"[U]PembayaranT052-TEXT1T052-TEXT1dimanaT052-ZTERM = EKKO-ZTERMdimanaEKKO-EBELN = [S1][V]Header TextCall FM READ_TEXTCall FM READ_TEXTClient = SY-MANDTID = "F01"Language = "EN"Name = [S1]Object = "EKKO"[W]Header NoteCall FM READ_TEXTCall FM READ_TEXTClient = SY-MANDTID = "F02"Language = "EN"Name = [S1]Object = "EKKO"[X]Nomor urutnomor urut1,2,3, dst[Y]Material NumberEKPO-MATNREKPO-MATNR dimanaEKPO-EBELN = EKKO-EBELN = [S1]EKPO-EBELPEKPO-LOEKZ ne 'X'[Z]Part NoMARA-BISMT atau MARA-MFRPNMARA-BISMT atau MARA-MFRPNdimanaMARA-MATNR = [Y]hanya ambil salah satunya saja[A1]DescEKPO-TXZ01EKPO-TXZ01 dimanaEKPO-EBELN = EKKO-EBELN = [S1]EKPO-EBELPEKPO-LOEKZ ne 'X'[A2]KeteranganCall FM READ_TEXTCall FM READ_TEXTClient = SY-MANDTID = "F01"Language = "EN"Name = [S1] + EKPO-EBELPObject = "EKPO"[A3]JumlahEKPO-MENGEEKPO-MENGEdimanaEKPO-EBELN = EKKO-EBELN = [S1]EKPO-EBELPEKPO-LOEKZ ne 'X'EKPO-MATNR = [Y][A4]UnitEKPO-MEINSEKPO-MEINSdimanaEKPO-EBELN = EKKO-EBELN = [S1]EKPO-EBELPEKPO-LOEKZ ne 'X'EKPO-MATNR = [Y][A5]Harga / unitEKPO-NETPR
